#WOW2024 | Week 23 | Manually overwrite a value in a table


This challenge started out with one idea which turned into something very different. It’s a little wacky & a little hacky, which I suppose is the essence of these challenges. The main element of this challenge became figuring out how to move a Parameter input box to a different position on the page, based on the user’s selection. It wasn’t easy to do and I’m not sure I’d do it again, but it’s certainly worthy of the Workout Wednesday crew!

Looking forward to seeing all of your solutions!



Dashboard size: 1100 x 650 px

  • Create a table with Category, Sub-Category and Average % Discount
  • Create a KPI chart with Sales
  • Create a line chart of Sales by Month
  • Put everything together in a dashboard
Now for the hard part:
  • Allow the user to overwrite the Average % Discount for a single Sub-Category (the value should update in the Table)
  • Enable the user to select the Sub-Category from the Table itself. The “user input box” should move to be in-line with the selected Sub-Category.
  • The “user input box” should not be visible when no Sub-Category is selected
  • Calculate and Updated Sales value (in blue) based on this new Sub-Category Discount value + the % difference from the original Sales value (in grey).
  • Plot the Updates Sales value (blue) on the same axis as the original Sales value (grey).
  • Fix the axis for the line chart such that the grey line never moves.
  • For the formatting, clean up any additional lines/borders/tooltips and make the layout look clean, but don’t worry if you don’t match all of the formatting exactly.


This challenge uses Sample Superstore data which you can find here on Data.World


When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2024 in your description to make it searchable!


After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday and @_hughej



Scroll to Top