Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a graph with a couple measures the user can select but i would like to (if possible) have the name of the selected measure in the sub title of the graph. Is this possible?
Yes, But you need some work around in script with Island table..
How you are selecting Measure?
Is it Alternate Measure or something?
I'll invite not to use alternative measure to achieve this but as follow:
Let's assume you have 3 measures :
1) sum(measure1)
2) sum(measure2)
3) sum(measure3)
first thing to do :
in the script, create a new table:
Measures:
load * inline [
Measure, MeasureID
Measure1, 1
Measure2, 2
Measure3, 3
];
Once done, on your presentation, add the new field Measure as a filter :
Now, in you chart, you'll only ONE MEASURE:
if(MeasureID=1, sum(measure1),
if(MeasureID=2,sum(measure2),
if(MeasureID=3,sum(measure3)
)))
And as a title: ='The selected measure is : '&Measure
The user will only have to choose a Measure from the filter to have it shown in the graph.
Hope this was clear