4 Replies Latest reply on Feb 3, 2019 5:50 AM by Adam Aliz

    YOY and YOY% not reflecting in the  calculation!!!

    Adam Aliz

      Hi,

       

      I am trying to calculate the YOY and YOY% based on the two field. But could not get the output ..

       

      Using fields in the workbook are Current , Previous, YOY & YOY%. What i would like to view is the YOY and YOY% in the respective columns. So , when i change the parameter to either QTD, MTD, YTD. it should populate accordingly.

       

      Here is the screenshot..

       

       

       

        • 2. Re: YOY and YOY% not reflecting in the  calculation!!!
          Zhouyi Zhang

          Hi, Adam

           

          You need use the month name ranther than the month year.

           

          Hope this makes sense.

           

          ZZ

          • 3. Re: YOY and YOY% not reflecting in the  calculation!!!
            Adam Aliz

            Zhouyi Zhang Thankyou.

             

             

            I am finding a way to built  a dashboard like this. Lets look at only one chart, Bus feet reliability.

             

            I want to show in KPI dashboard , YTD as bar graph as seen below (Comparing with current YTD and previous YTD). Fiscal Month should start from April.

            In the bar graph, current YTD value should contains April 2017 to March 2018, and Previous value YTD value should contains April 2016 to March 2017.

            Comparing last 2 years fiscal year only.

             

            And in the line graph below, Month over month change. Example: In the line graph, the trend should focus on the last 2 years , the starting x-axis month value should be April 2016 to March 2017. The end dot of the month should be able to alert via red color for bad and green color for good.When i over the individual month point , i should see in the tooltips, the MOM% change.

             

            Finally, dedicated month and dedicated day filter need to provide. Month should go backwards until the last 2 years, in this case should April 2016 and should stop at March 2017. so when the new data comes in for next month which is April 2017.it should populate accordingly.

             

            And the date field also same, in this format 01 April 2016 ... all the way to 31 March 2017... and when the next day comes in 01 April 2017 it should be populate automatically.

             

            the dashboard should stick to current day when ever it opens .and the user can click around the month and day to see the changes . so both ytd graph and mom graph should change accordingly.

             

            would be very helpful if i get answer. I  tried figuring out by seeing the describe sheet option, but not getting it.

             

             

             

            Attaching workbook for reference

            • 4. Re: YOY and YOY% not reflecting in the  calculation!!!
              Adam Aliz

              Zhouyi Zhang

               

              Thanks for the reply. I mark this thread as answer correct as it helps to solves the issue that i have mentioned above.

               

              For the second issue, i have dedicatedly created a new thread , subject as : Doubt in KPI Dashboard.

               

              Thankyou very much