Hello,
I have a group pie chart that shows number of occurrences based on some parameter being in several predefined ranges (group1: 0-20, group2: 20-50, group3: 50-80,..... )
I want to update entire dashboard if some group on this chart is selected and filter only data that have the parameter in the specified range. Thus I need to get 2 tokens with limits of the range that was selected.
$click.value seems to be not set properly and things like this:
<drilldown>
<eval token="BI_groupLow">case(match($click.value$, "less than 20"), 0)</eval>
<eval token="BI_groupHigh">case(match($click.value$, "less than 20"), 20)</eval>
</drilldown>
doesn't seem to work either.....
Does anyone have an idea how get range limits in this case?
Thanks in advance!