Sisense Dynamic period comparison: using past period
Hi
We are trying to build a KPI indicator widget that will show the current value of KPI (based on user date filter) + also shows % change with 'previous period' which should be the dynamically adjusted based on user date values. for example
- Custom range
- single date (eg: Jan 17th) → Compares to the previous date (Jan 16th in this case)
- particular week (Jan 1 to Jan 17th) etc.. --> to compare with same period of time prior to the start of the range (the prior 17 days in this case)
- Current Week --> compared with the previous week
- Last Week → Compared to the week prior
- Current Month → compared with last month
- Last Month → Compared to the month prior
- Last 3 Months --> compared with 3 months before last 3 months
- Last 6 Months --> compared with 6 months before last 6 months
- Last Year --> compared with previous year
I experiemented with 'growth' function under % change of over time. Its working as expected for few date options but not all. Example
if i select 'This month' --> it will compare against last month
if i select 'last 2 months' --> it does not work as expected. Ideally it should compare against the previous 2 months but it calculates T-1 eg: As we are August currently, Last 2 months should be compared against April and May but instead 'growth' is calculated against May and Jun. I see the same behaviour when i select any particular date range.
Is there any solution to this?
Is this something that can be done in Sisense?