Hi all,
I want to find the sum of the values of top 20 clients when aggregated on base number.
WINDOW_SUM(IF [rank] = "Top 20 Clients" THEN SUM([aggregation on base_no]) END)
The above calculated field gives me null as an output.
Harshitha,
For this to work you should place client name to details and set your table calc based on Client.
Feb 14, 2018 5:03 AM
Hi
not certain what you expect but see the attached
to get the single mark I un-selected aggregate data
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim,
I have attached the screenshot. I have tried doing the same but still it
shows null.
On Wed, Feb 14, 2018 at 6:33 PM, Jim Dehner <tableaucommunity@tableau.com>
Hi,
Actually I have a legend which shows the percentage of top 5, top 10, top
20 clients respectively. But I can find that something is wrong with it.
Percentages should be in the order top5 < top10 < top20 clients. Can
someone help me with this. I changed the detail to base number as it is my
requirement. But it doesn't work. Can someone help me with this.
Regards
Harshitha
On Wed, Feb 14, 2018 at 6:57 PM, Tushar More <tableaucommunity@tableau.com>
I am not clear what is your expected output?
Something like this based on base no.
~Tushar
Hi Tushar
Yes a legend like that based on base number. Logically percentage
contributed by top 5 clients should be less than the percentage
contributed by top 10 clients but the results contradicts this. This is the
problem I am facing and I am not able to identify the cause.
Regards
Harshitha
On Thu, Feb 15, 2018 at 12:39 PM, Tushar More <tableaucommunity@tableau.com>
Harshitha,
I am not sure about the reason why you are getting the correct result. But, as a workaround I created two sheets top 5 and top 10, and combine them in a dashboard.
~Tushar
Hi Tushar
Can you share the workbook with me?
Regards
Harshitha
On Thu, Feb 15, 2018 at 2:03 PM, Tushar More <tableaucommunity@tableau.com>
Hi Tushar,
I use tableau version 10.4. Can you please downgrade your workbook and
share it with me?
Regards
Harshitha
On Thu, Feb 15, 2018 at 2:12 PM, Tushar More <tableaucommunity@tableau.com>
Feb 15, 2018 5:16 AM
Hi
I've been traveling
your workbook is attached
this is the aggregation bast total
this is the top 20
you have a choice of output
the disaggregate level
or like this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
