Forum Discussion
PREVIOUSQUARTER returns nothing
Hello, this really has me stumped as everything else works OK! I can count and average if I put in manually the dates and the current quarter time intellignce works but not the previous quarter ones....
Interkoubess
Solution Sage
Solution SageHi misterian
I opened your file and make a quick test, if you create a filled map with calendar date and let's vary the date you will notice that the Response Prev Q Avg works...
The system needs to know what is the previous period so if you choose then the system can generate the previous quarter...
Let us know if it is not working..
I'm not sure I understand what you are getting at. I need to have a card showing only the previous month's value, nothing else as part of my dashboard. The user must see only the previous Q relative to now without any interaction with the report.