Filtered Period Comparison reflect in tables

Kanokkarn · 2024-07-25T02:46:00+00:00

There was an error rendering this rich post.

I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create another dimension with %chg based on two periods.

For ex. User wants to see total GMV between Sept 1st to Sept 5th for 2024 compared with Mar 12th to Mar20th 2024(Select the filtered date between 2 periods). also see the % change for this two period. Does DOMO also support this easily?

Can you please advise?

Find more posts tagged with

Date

Table

Accepted answers

ArborRose

I don't know about whether it does it "easily".

You would need to create a table in Domo where users can select date comparisons between two periods and see the data along with the percentage change.

Create two Beast Mode fields to capture the start and end dates for both periods.

CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN 'Period 1'

     WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN 'Period 2'

ELSE 'Other' END

Create filters for date selection using Domo’s interactive filters for users to select the date ranges. Set up two date range filters, one for each comparison period.

SUM(`GMV`)

Create separate Beast Mode calculations to sum GMV for each selected period.

-- GMV for Period 1

SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END)


-- GMV for Period 2

SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

Create a calculation for percentage change..

(SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END) -

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END))

 /

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

 * 100

Then setup the table visualization, probably a pivot table. Add you date range filters to the card.

All comments

ArborRose

CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN 'Period 1'

     WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN 'Period 2'

ELSE 'Other' END

Create filters for date selection using Domo’s interactive filters for users to select the date ranges. Set up two date range filters, one for each comparison period.

SUM(`GMV`)

Create separate Beast Mode calculations to sum GMV for each selected period.

-- GMV for Period 1

SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END)


-- GMV for Period 2

SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

Create a calculation for percentage change..

(SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END) -

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END))

 /

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

 * 100

Then setup the table visualization, probably a pivot table. Add you date range filters to the card.

Kanokkarn

@ArborRose hi thank you

but if the user wants to filtered the date by themselves? how could we create a filtered applied to tables for two periods comparison

and for somehow your method only allow one filtered which applied to the whole table. I want to have two filtered separate into each period. is that possible?

I want the user to adjust the filtered between two period by themselves.

CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN 'Period 1'
WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN 'Period 2'
ELSE 'Other' END

For ie. those two period can be varied outside of the period I provided.