Thanks, I found that on how to add the % symbol, but curious now how to change just the format of the numbers as some will have no decimal points and some will. I appreciate the link.
You could do things with converting the value to a string and doing all the formatting from there, but here's an alternative approach. Create calculated fields for each of your measures such that, if the matching measure is selected, you'll get the value. Otherwise, you'll get NULL.
AHT (if Selected)
// Only show AHT if it is selected. Otherwise show NULL.
IF [Select a Metric]="AHT" THEN
NPS (if Selected)
// Only show NPS if it is selected. Otherwise show NULL.
IF [Select a Metric]="NPS" THEN
Survey Results (if Selected)
// Only show Survey Results if it is selected. Otherwise show NULL.
IF [Select a Metric]="Survey Results" THEN
Then remove Metric from the text card and drag all three of the above to the text card.
Now click on the text card and edit the text. It'll look like this:
<AGG(NPS (if Selected))>
<AGG(AHT (if Selected))>
<AGG(Survey Results (if Selected))>
Change it so that these are all on the same line:
<AGG(NPS (if Selected))><AGG(AHT (if Selected))><AGG(Survey Results (if Selected))>
Finally, right-click on each of the three pills and apply your formatting to each independently.
Because the calculated fields only show the selected value, the other two will always be NULL, so you'll only see one value on the table, formatted as desired.
See attached workbook.
Select a Metric.twbx 43.8 KB
Thanks, that's a few extra steps, but at least gets me to a solution. I appreciate the help!
Yes, agreed. It requires some extra work, but I prefer this over trying to format everything as a string. That solution just seems to break eventually.