Sisense Dynamic period comparison: using past period | Help and How-To

ramansingh89 · 2024-08-09T14:52:21.132000Z

HiWe 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 exampleCustom rangesingle 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 weekLast Week → Compared to the week priorCurrent Month → compared with last monthLast Month → Compared to the month priorLast 3 Months --> compared with 3 months before last 3 monthsLast 6 Months --> compared with 6 months before last 6 monthsLast Year --> compared with previous yearI experiemented with 'growth' function under % change of over time. Its working as expected for few date options but not all. Exampleif i select 'This month' --> it will compare against last monthif 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?

MoreDiscussions

Sisense Dynamic period comparison: using past period | Help and How-To | Sisense Community