7 Replies Latest reply: Nov 8, 2017 9:00 AM by raffaele di francia RSS

    How to get previous week metric data  in another metri

    bobby ch

      Hi Team,

      Good day

      since last few days i am trying to achieve below mentioned issue in my dashboard

       

      issue:

      1.i need to display the previous metric data in another metric

      2.again i need to subtract the current week data with previous metric data

       

      EX:

      in my issue   i have date,previous week and current week fields

       

      so now along with date i need to display previos and current week date

      like below ;

      Main table from Database:

          Date                              current                   

         5-march-2017                  5                          

         12-march-2017                8                         

         19-march-2017               10                       

         26-march-2017                15 

      Note:

      Date columns contain only week data 

                

      out put table i need to show in dashboard:

            Date                        current      previous                                               difference(currentweek-previousweek) metric 

        12-march-2017                 8                5(this value is 5-march-current week data)          3

         19-march-2017              10                 8                                                                     2

         26-march-2017              15                10                                                                    5

       

       

      could you please suggest me how can i achive solution for this?

       

      i have attached the QVW as well for same