4 Replies Latest reply on Oct 23, 2018 9:03 PM by Divya Sharma

Dashboard Actions - filters

Divya Sharma Oct 22, 2018 10:27 PM

Hi Experts,

I need your help in this. I have used the Sample Superstore -data source to replicate my issue as follows. I have a dashboard which includes two sheets.

In Sheet 1, i have created a calculated field 'City Count = CountD(City)' and a multi select filter called 'City' . Based on this filter, City Count changes.

My requirement is, on the dashboard, when we Click on City Count for eg. 12 , I should see 12 related cities in Sheet 2.

Workbook attached.

Would really appreciate your help.

Thanks.

RequirementExample.twbx 1.2 MB

1. Re: Dashboard Actions - filters

Zhouyi Zhang Oct 22, 2018 10:31 PM (in response to Divya Sharma)
Hi, Divya

You need add the sub category as detail level

Create the action filter as below

and the reuslt

Hope this helps

ZZ

RequirementExample_v10.4.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
2. Re: Dashboard Actions - filters

Divya Sharma Oct 22, 2018 11:19 PM (in response to Zhouyi Zhang)

Hi Zhouyi,
Thanks for your reply. I have edited this post to illustrate my requirements properly.
Please visit this post again.
Many thanks.
Like Show 0 Likes(0)

Actions
3. Re: Dashboard Actions - filters

Zhouyi Zhang Oct 23, 2018 4:56 PM (in response to Divya Sharma)
Hi, Divya

In this case, you need a bit change of your calculation as shown below

And the result

An updated workbook attached for your reference.

Hope this helps

ZZ

RequirementExample (1)_v10.4.twbx 1.2 MB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Dashboard Actions - filters

Divya Sharma Oct 23, 2018 9:03 PM (in response to Zhouyi Zhang)

Hi Zhouyi,

Thanks for looking into it. It helped me .
Please advise how can i get the Cities name in the tool tip of Sheet 1.

Many Thanks.
Like Show 0 Likes(0)

Actions