Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculating Previous Quarter Average

I have Data in a table that looks like this:

 

It's feedback from a survey and I've created measures that counts each type of category by person. I've also created a measure to get the percentages of each type as well. Positive for instance looks like this:


 

Which works as intended. This calcuation is for the overall feedback which is two years worth of data. What I'm trying to figure out is how to do the same thing but for the previous Quarter (Jan-Mar). I created a measure that looks like this:

 

But for some reason this is giving me the same numbers as the overall satisfaction % numbers:

I've used this DATEADD formula with other measures to get first quarter results so I'm not sure why it's not working here. Any thoughts?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous

     

    Try the function PREVIOUSQUARTER()

     

    Hope it works.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous Tried it. Still gives the same results...

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    Have you added Date field as shown in the following similar screenshot? 


    Regards,
    Lydia