How to display 2 measure columns with different timerange but the date filter remains same

Q&A
, , , ,
1

For example , i have a column order_date as a filter in the dashboard and amount , amount_last30days, amount_last 60days as a measure columns and with some other dimension columns.
When i select the order date as april 1 to april 10 then
amount column should display data from april 1 to april 10 and
amount_last30days should display data from march 2 to march 11 and
amount_last 60 days should display data from Jan 31st to Feb 9

in this way the data should be changed and meanwhile i will change the order date filter as per my custom range

2

Hello @manideep1

I made an example of this in arena:
Two KPIs Current/Previous Period

This is displaying as two KPIs and a table if you want to add this different visuals you will need to customize it.

3

Hi @WLS-D ,

This is not working for me,
Can you provide one more example.

Both current sales and previous sales should be in a same analysis

4

Below are the screenshots how i have used the logics, let me know if iam doing any wrong calculations

image
image635×250 6.02 KB

image
image634×435 28.8 KB

5

@WLS-D ,

any update on my request please