Forum Discussion

gvg's avatar
gvg
Post Prodigy
9 years ago

Getting date value from report date filter

Hi All,

 

Is it possible to get filter level value in the report? I need to perform different calculations based on which date hierarchy level is selected. I.e. if years are selected, I need to apply one formula, if months are selected, the formula is different, etc.. Is there a way to know if user has filtered the report by year, quarter, month or day? Like in this example below I need to know what is the lowest date hierarchy filtered. In this case it is Quarter.