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.
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!