Very nice. This was on a worksheet. Now how can you do the same thing on dashboards?

Great stuff here - thank you!

Nice job!

how do you override the "None" value that can get returned?

great video!

@TableauWeston

2 жыл бұрын

Glad you enjoyed it

I am seeing "All" or the unique institution aliases - institutional name variable called Alias1, but not "All Institutions" or "Selected Institutions". Tableau says the calculation is valid however. Do you have any advice? It looks like my syntax matches yours. if COUNTD([Alias1]) = 1 THEN MAX([Alias1]) ELSEIF COUNTD([Alias1]) = MAX({countd([Alias1])}) Then "All Institutions" ELSE "Selected Institutions" END

Awesome!!

@davida6146

4 жыл бұрын

Weston Palmer I subscribed :)

My data has null values for one of the Markets, so MAX (COUTD (Market) ) never gets equal to COUTD (Market) and hence never says "All Markets". How to tackle that?

@vishwas22khare

4 жыл бұрын

I am facing same problem with correct spelling of countd

Not working for me plz help me IF COUNTD([Category])=1 THEN MIN([Category])+" country" ELSEIF COUNTD([Category])=MIN({COUNTD([Category])}) THEN 'All countries' ELSE 'Multiple countries' END

There is not an example for dashboard page

@TableauWeston

2 жыл бұрын

You are correct. The example walks through a worksheet, but the concepts will work for the dashboard as well. For a dashboard, you will create a worksheet without any data, just a title. If it's not clear, let me know and I'll see what I can do.

@oterotube13

2 жыл бұрын

@@TableauWeston hi Weston, thanks you for your reply. I just got you what you mean, but I had to take it from another example. It shouldn’t take a sheet just for the title (dynamic) in the dashboard page. It should be a direct feature from the application. Thank you a lot for helping the community.

@TableauWeston

2 жыл бұрын

You're welcome. If you find that feature or an easier solution, please let me know. I'd love to incorporated it into my dashboards as well.