Filter multiple months by specific days of the month

Will_DOMO · 2022-07-25T15:54:25+00:00

There was an error rendering this rich post.

Hi - I'm looking for a way to take a card with a date range of the previous 13 months and have the ability to filter it for certain days of the month so I've got more of an apples-to-apples comparison. Ex., if today is July 15th then I want to filter the exact days to include so that other months on the card only show data for the first 15 days. Ideally I'd just be able to set the days I wanted to show either via a range or radio button selection.

I'm not seeing an out-of-the-box way to do this. Thanks!

Find more posts tagged with

Cards

Date

Card Builder

Accepted answers

MarkSnodgrass

You can actually do this quite easily with beast mode to ensure that you are only showing the same amount in each month.

(CASE when DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END)

You can then drag this beast mode into your filters and filter on Include. You can let your date range be whatever time period you want, and this beast mode will filter out dates that are past whatever day in the month it is for previous months.

Hope this helps.

Will_DOMO

Thanks to you both. These didn't get me where I needed to be HOWEVER they did provide enough info/context to figure it out. As it turns out it was even simpler and only required the DAYOFMONTH ('datecolumn'). Then I setup the beast mode as a range filter and it's perfect.

Screen Shot 2022-07-25 at 1.55.20 PM.png

All comments

Will_DOMO

GrantSmith

they only thing out of the box that would handle this correctly is doing a year to date selection. What I recommend is to configure your own date offset dataset to do a more apples to apples comparison. I’ve written up on this method before https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

MarkSnodgrass

You can actually do this quite easily with beast mode to ensure that you are only showing the same amount in each month.

(CASE when DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END)

Hope this helps.

Will_DOMO