Skip to main content

I'm trying to create a calculation that lists out fields as a text string (with commas) only if NOT All fields are selected in the filter otherwise display the text "All" (or hide it from the dashboard).

 

The issue I'm running into is the "All" text is being duplicated by the number of values (because of the dimension on the detail mark).

 

I attached a sample .tbwx dashboard to show what is happening but I tried something along the lines of:

 

IF TOTAL(COUNTD(Segment)) = SUM({FIXED :COUNTD(Segment)}) THEN "All"

ELSE

(IF LAST()!=0 THEN MIN(Segment)+","

ELSE MIN(Segment)

END)

END

 

For context, I'm trying to create a sort of a Appendix dashboard that lists out all filter selection values but it isn't necessary to see if the selection is All.

 

Any advice would be great.

5 answers
  1. Sep 2, 2020, 7:53 PM

    Hi Kelly,

    That's what I was wondering. If you want this to be a sheet that servers as a title or the like, you can use LAST()=0 to achieve this and place the list creation field on your text pane. :)

     

    Updated for you here!

     

    Best,

    Bryce

0/9000