Hi, I have an issue which should be simple to resolve.... but it isn't!
I'm trying to create a chart that is restricted based on a number of different measurements. Measure A Measure B Measure C etc, that each have a max and min value attributed to them. The chart displays one bar per measure per whether they exceed the max or the min -
eg
Measure a above max
measure a below min
measure b above max
measure b below min
: :
: :
currently I am achieving this by joining the table containing the measures to a max and min input table and restricting the dimensino on the chart to an expression like : =if( Val >= Max then Measure & ' above Max',
if(Val <Min ,Measure & ' below min')
based on a table
Measure Val
A X
A X
B X
B X
joint to an input table
Measure, Max, Min
A, 50, 10
This is so the user can enter their own limits. I am calculating this in the dimension rather than an expression so the user can click on one of the bars and filter for just the minimum or maximum values of A (which then pop up in a separate screen)
I would like the flexibility that you get with variables though, as the input table isn't user friendly. My first option was to create a variable for each min / max and do a nested if, but this was memory intensive.
What I am trying to do now is join the measurements table onto a table which lists variable names in the fields.EG
Measure VariableMaxName VariableMinName
A vAMax vAMin
B vBMax vBMin
: : :
And then reference these in a table. The problem is that I can't get it to call the value from the variable, even in a straight table expression. I've tried =$(VariableMaxName) and then various combinations of quotes, equals signs and even a dollar sign expansion inside a dollar sign expansion!
Could anyone give me insight as to why this isn't working? It just wont return the value of the variable - only a null. I have tried something similar before, but where it references a field, rather than a variable. Help!
Many thanks,
Erica
.png "Luminary Alumni"){kind=icon}
