Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I make a choice from a list box called Metric, I can see the value I have choosen in a text box by putting =GetFieldSelections(Metric) in the Text Box on the General tab of the Text Object.
I would like to graph the median of this value on a line chart. I cannot seem to get it to calculate the median of what I have choosen. I have tried putting these expressions in the definition of the expression on the Expressions tab but none of them produce anything. What is the correct syntax?
$(Median(=GetFieldSelections([Metric]))
$(Median(GetFieldSelections([Metric])))
Median($(GetFieldSelections([Metric])))
$(Median($(GetFieldSelections([Metric]))))
Thanks in advance
Help on Median function:
If you want to show a line at the level of the Median in your chart, go to the Presentation tab and add a "Reference Line" (bottom right corner).
Here is an example of the expression in a situation where you want to show the median of all Durations (metric) per YearQuarter:
= Median(aggr(sum(Duration), YearQuarter))
You are not understanding my question. The Dimension in my line chart is correct. In this case I am using YearMonth. The problem is what expression do I use on the expression tab to graph the metric they have selected in the list box. I have tried a number of ways but none of syntax work. I need to know what syntax I would use on the expression tab.
Thanks