5 Replies Latest reply: Jul 16, 2014 4:35 AM by Padmashri Rajagopal RSS

    Monthly value at week level

    Padmashri Rajagopal

      Hi All,

      I have a requirement to represent the weekly value( Value) at month level.

      What i have done is , i have performed a Group by at the month level to get the monthly level Value(in the script).

      But the challenge is to represent the monthly value at the Week level.( Image2), without using the Month, in the dimensions , because it messes up my other KPI's

      So far I'm only able to represent it month wise( Image1)

      As shown in  image2

      Week 18- Week 22-  Month1

      Week 23- Week 26 -  Month 2

      Week 27- Week 31- Month 3


      Anyway I can get the Monthly value at week level?

      Thanks in advance for your time and help.