4 Replies Latest reply: Apr 4, 2018 7:04 AM by Sunny Talwar RSS

    How do I drill down in a bar chart?

    Marlize Broodryk

      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?