Product Feedback Forum
Help us make Sisense better by posting your product feedback here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: New Idea

Hi,
I have issue with setting two date dimensions in dashboard.
The goal I want to achieve is to have a history of records, which are also have it's own date dimension. You can download model and dashboard. I would like to have difference in growth ower selected period for defined dates.

For example 2 days ago I sold a car for 1000, and yesterday the proce have changed to 1500. The sale date is for today. So the growth over 2 days is 1500, and for 1 day 500.

Additionally i would like to compare those values to previous year, and go back with both date dimensions.

Tricky part is also, that if there is not sale for this year, PastYear() wont count prior year.

I tried to play around with filtered measure plugin, however it doesn't give me exactly what i want.

Do you have any suggestions how can I approach such data and 2 date dimensions?
Thanks 🙂