3 Replies Latest reply: Sep 11, 2017 2:18 AM by Shraddha Gajare RSS

    Quarter-o-Quarter & Year-o-Year

    Ajinkya Bhonsle

      Hi,

       

      I would like to compare the data for "current quarter" vs "last quarter" and "current quarter" vs "last year quarter".

       

      I have a inline table:

      InlineMonth:

      Load * inline

      [

      transactionMonth, Month, Quarter, QuarterMonth

      1,Jan,Q1,JanQ1

      2,Feb,Q1,FebQ1

      3,Mar,Q1,MarQ1

      4,Apr,Q2,AprQ2

      5,May,Q2,MayQ2

      6,Jun,Q2,JunQ2

      7,Jul,Q3,JulQ3

      8,Aug,Q3,AugQ3

      9,Sep,Q3,SepQ3

      10,Oct,Q4,OctQ4

      11,Nov,Q4,NovQ4

      12,Dec,Q4,DecQ4

      ];

       

      the filed I would be using is the "QuarterMonth"

      I would like to assign variables in my load script like  "current quarter", "Previous Quarter", "Year Ago Quarter". I am looking for an expression and then use the above variables in my dashboard.

       

      HELP!