Pre-defined date periods as analytic functions
We have customers on different financial years. For example, ending 31st Dec, 30th June, 31st April. We can set the financial year in each Client Organisation and that works well with the Predefined Date Periods feature.
But we also want to have Financial Year related fields in our date hierarchy. For example:
- Financial Year Start Date eg 1st July 2018
- Financial Quarter Name eg Quarter 3
- Financial Quarter of Year - eg 1, 2, 3, 4
Most of our client's reporting involves filtering and grouping by financial year and/or financial quarter.
Would be great if we could apply these types of date functions as analytic functions so we this type of dynamic data/drill down.