Dynamic POP Comparison on Dashboard

Hi Sisense

We are building a dashboard where user will be allowed to select from the following date scenarios

Custom Range
Current Week
Last Week
Current Month
Last Month
Last 3 Months
Last 6 Months
Last Year

We are building KPI dashboard which will show the current metrics and will show previous period comparison with a particular timeframe and will show the % change.

Is there a way we can allow our dashboard users to select 'previous period' dynamically?

example compare last year with last 3 weeks, or compare last 1 day with particular time period

any examples would be really helpful

ramansingh89

Posted 2 years ago · Edited 2 years ago·Last reply 2 years ago

5 comments

DRay

·2 years ago

Hello ramansingh89.

I wanted to follow up to see if the solution offered worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

ramansingh89

OP2 years ago

Hi,

I was able to build the solution with existing Sisense Diffpastperiod functionality 🙂

DRay

·2 years ago

Hi ramansingh89,

Would this solution work for you? https://community.sisense.com/t5/knowledge/compare-a-time-window-against-the-immediately-preceding-t...

DRay

·2 years ago

Hi ramansingh89,

Thank you for reaching out. I'm having trouble visualizing how that report would look. Are you able to provide any examples that we can look at?

ramansingh89

OP2 years ago

cc DRay