How do I drill down in a bar chart?

[Anonymous]

Good day

I have a bar and line chart with dates as a dimension. The bar display the monthly ave and the line the quarterly ave.

Sum({<TypeDrill={Hybrid},[MonthIndex] = {'<=$(vMaxPeriod)'}>}MetersDrilled)/sum({<TypeDrill={Hybrid},[MonthIndex] = {'<=$(vMaxPeriod)'}>}Repairs)/4

Now if I only want to see the current year's data the quarterly ave is recalculated starting at 0.

This is a misinterpretation of the data as it started at 0 in 2016.

How do i fix it?

[sunny_talwar]

Would you be able to share a sample to show the issue?

[Anonymous]

Good day

Here is my graph.

When you make a selection, it recalculates the quarterly ave as seen below from 655 to 356.

How do I stop it from recalculation. I only want to zoom in on the data for those periods.

[gerry_hdm]

You Setting a new Dimension by Group working

set the fields in the Group

()DateMonth

The Group is your new dimension

[sunny_talwar]

Would you be able to share the qvw to test?