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