1 of 1 people found this helpful
What data source are you using? If it is Excel, text files or google sheets you can pivot the fields from columns to rows. That way only 1 calculated field would serve your need. Take a look at this:
Additionally, if it is not one of those data sources, you can write a custom SQL query so your data is shaped the way it is easily consumable within Tableau. Taller data structure is what you need and wider data structure is what you have. So reshaped data would work best!
Hope this helps!
Thanks for your responses.
What I forgot to mention is that I have discrete date dimension set to months. Is there a way to do it without calculation for each month?
Is the same method.
You drag the month dimension in columns, drag the value and set percentage table down.
I'm totally in on how to set percent of total using the quick calculations. However, I want to be able to filter out one or several of the products without changing the total for that market.
I have worked around this by using lookup(attr......) as a filter instead of using a quick filter, but I'm guessing that this could be solved using LOD expressions. Why I want a better solution than the lookup function is that I cannot use the calculated filter (lookup(attr....)) for any other viz. Hence, for my specific dashboard I'm inclined to use several product filters instead of one across several vizzes.
Hope this makes more sense.
How about you post twbx or xls file with your data and explain your full requirements?
In this way we could solve your issues faster.
I used your data and pivoted it.
A 2 2 2 1 2 1 1 1 B 1 1 1 1 1 2 3 2 C 2 2 1 2 3 1 1 1 D 3 1 1 3 1 2 3 2 E 2 2 2 1 2 4 2 1 Total 10 8 7 8 9 10 10 7
See twbx file.
thread-213683.twbx 15.0 KB