Ifelse - Interactive Formula Correction

Question & Answer
, ,
1

Hello, I have been building an interactive dashboard that changes all tables and “Gauge” graphs based off of the selected locations in my “first” tile. I have not ran into a problem with the tables but I seem to have a problem within my gauge graphs. I want to show the progress for individual location budgets when selected (And I have been successful in this part), and then the region’s budget progress when nothing has been selected but I have been having issues when no locations have been selected. The formula I am using for my target value is below (Keep in mind that for the “Value” field, my data changes as well, but I have no issues with that formula):

ifelse(
contains(toString(LocationName), ‘4001 Abingdon’), ${4001VolBudget},
contains(toString(LocationName), ‘4002 Elmwood’), ${4002VolBudget},
contains(toString(LocationName), ‘4003 Erie’), ${4003VolBudget},
contains(toString(LocationName), ‘4004 Sheffield’), ${4004VolBudget},
contains(toString(LocationName), ‘4005 Logan Square’), ${4005VolBudget},
contains(toString(LocationName), ‘4010 Chicago’), ${4010VolBudget},
contains(toString(LocationName), ‘4011 Harvey’), ${4011VolBudget},
contains(toString(LocationName), ‘4012 Marseilles’), ${4012VolBudget},
${LHILVolBudget})

I have set the aggregation to “max” currently and I have a region filter built into the visual as well, but I cannot seem to figure out why I am not able to see the region budget when no options have been selected.

I am unsure if the screenshot below will load but if it does, the correct value metric for this graph is 11,274. And the correct Target Value metric for this graph would be 24,875. So, I am unsure where 4,536 comes from.

{9835C5F4-A43C-4EE4-82F9-23495D835F37}
{9835C5F4-A43C-4EE4-82F9-23495D835F37}356×351 12.6 KB

If there is anything that I might need to change or add to this question to give more detail please feel free to let me know and i will see what i can do to help! Other than that, if you have any suggestions on what i could change to try and make this work I would really appreciate it!

2

Hi @J_Elrod52

I observed a behavior where initially when you enter the dashboard the Select All basically has a list of all your selections and when you later change the selections and do select the Select All it has a null.

@EricG has provided a solution for similar issue that worked for me. See if this would help solve your problem as well

1 Like
3

@Giridhar.Prabhu

How would I apply this to my dashboard? I am unfamiliar with Multiple value parameters.

4

Hi @J_Elrod52,
To setup a multiple value parameter, see below:
Start by building a parameter and select ‘Multiple Values’

image
image602×738 29.4 KB

Once created, add a control for the parameter and link it to the dataset (probably your LocationName field for this instance)

image
image587×651 20.8 KB

Let us know if you have any additional questions!

1 Like
5

Hi @J_Elrod52,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!