Forum Discussion
Drill down with reduced dimension
Hi,
I have a chart with data per minute, and I have created 3 dimensions for daily min, max, and average. When I drill down from day to min, the chart shows 3 lines (min, max, and average) representing the same value (which is correct). It also give 3 same values at the data points.
Is there a way to simply reduce to one dimension (eg. max) when drill down to min ?
Thanks
.Have the min and max measures return BLANK() when minute ISINSCOPE()
4 Replies
- lbendlin
Super User
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Based on the time series data (a data per minute), I created 3 dimensions, min, max and average. The chart works well when the x-axis is by day or hour, but when I drill down to minute, the 3 lines coincide into one (obviously min, max, avg of one single data is the same).
I try to show only one line when drill down to minute level. Is there a way to achieve it ?
- lbendlin
.Have the min and max measures return BLANK() when minute ISINSCOPE()
