Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have the following set analysis which works O.K in a Text box, and the result return 02:03
=
Time(RangeFractile(.5, $(=Concat([Total Wait], ',') & ',' & Concat(CONCLUSION_WAIT_MINS, ','))I want to use this set anlysis as an expression in a graph. My dimension to plot against this againist is called Main_Week. However the graph currently shows 02:03 for every week.
Could someone kindly help me write the correct syntax so the graph changes for every week
Thanks
Helen
Helen,
the dollar sign expansion is evaluated once per chart, in global context, so won't take your dimension values into account.
If you could create a single common field from [Total Wait] and [CONCLUSION_WAIT_MINS], you could use fractile() function without a dollar sign expansion, instead of the current solution.