Need help building your own parameter-driven reference lines? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Excellent starter video. In my experience, customers want an individual target for each category (e.g., Chairs = $99,000, Phones = $224,000 ...). - This approach typically requires an additional data source such as an Excel with targets (users can manually update the targets). - However, with your approach, we could replace an Excel with targets and use a Parameter for EACH category. That works, but each category is one worksheet. - Sample "Sales Target for Chairs" : {FIXED [Sub-Category] = "Chairs": MAX([Parameter Target Chairs])} Nice advanced version, if I may say so ...
Hi Patrick, thanks for sharing your thoughts! Your approach should work. You could even do something like this.... CASE [Category] WHEN "Category A" THEN [Parameter A] WHEN "Category B" THEN [Parameter B] WHEN "Category C" THEN [Parameter C] END That calculation could then be used like a standard field and referenced in a reference line and gives the user the ability to change each value individually if they want!