Hi Anonymous
We are trying to build a KPI ndicator 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
![]()
Is this something that can be done in Sisense?