topic Re: How do I drill down in a bar chart? in App Development

How do I drill down in a bar chart?

Anonymous — Wed, 28 Mar 2018 09:45:15 GMT

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 — Tue, 03 Apr 2018 15:38:58 GMT

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

Anonymous — Wed, 04 Apr 2018 09:41:36 GMT

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 — Wed, 04 Apr 2018 09:46:16 GMT

You Setting a new Dimension by Group working

set the fields in the Group

()DateMonth

The Group is your new dimension

sunny_talwar — Wed, 04 Apr 2018 11:04:10 GMT

Would you be able to share the qvw to test?