Dynamic POP Comparison on Dashboard

[ramansingh89]

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]

cc @DRay 

[DRay]

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?

[DRay]

Hi @ramansingh89,

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

[DRay]

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 · Accepted solution]

Hi, 

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