Forum Discussion

ramansingh89's avatar
08-09-2024

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

  1. Custom range
    1. single date (eg: Jan 17th) â†’ Compares to the previous date (Jan 16th in this case)
    2. 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)
  2. Current Week --> compared with the previous week
  3. Last Week â†’ Compared to the week prior
  4. Current Month â†’ compared with last month
  5. Last Month â†’ Compared to the month prior
  6. Last 3 Months --> compared with 3 months before last 3 months
  7. Last 6 Months --> compared with 6 months before last 6 months
  8. 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?

5 Replies