Quarter Filter On a dashboard

mlanterma

Hello,

I need to add a filter that contains the list of quarters in the data.

I can get the quarters to show in the card by using a beast mode QUARTER (Date Range), but am not able to get the quarter to show in the shared filters as a drop down list of values. The beast mode is shared to the data set.

Quarters shown on the card:

All the shared filter shows is a min of 1 and max of 4, which is not exactly what i need. Ideally I would have a list of:

2019-Q2

2019-Q3

2019-Q4

etc...

Thoughts on how I can add a list of quarters to the filter?

MarkSnodgrass

You can mimic the date range quarter display by using CONCAT in a beast mode like this:

CONCAT(YEAR(`dt`),'-Q',QUARTER(`dt`))

If this is applied to all your datasets, then this should work as a shared filter.

The other option would be to use the date field that is driving your date range as your shared filter and use the between condition in the range. This would require people to enter in the start and end dates, so it may not be ideal for you.

GrantSmith

Essentially yes. Domo does supply a Dates dataset in the Domo Dimensions connector which gives you a list of dates as a starting point you can modify with a view or ETL to do additional processing / adding of columns to.

MarkSnodgrass

You can mimic the date range quarter display by using CONCAT in a beast mode like this:

CONCAT(YEAR(`dt`),'-Q',QUARTER(`dt`))

If this is applied to all your datasets, then this should work as a shared filter.

The other option would be to use the date field that is driving your date range as your shared filter and use the between condition in the range. This would require people to enter in the start and end dates, so it may not be ideal for you.

GrantSmith

Depending on when your quarters start you might want to think about using a date dimension table which has your quarters defined if it doesn’t start on Q1=Jan-Mar. You can use a view to join this date dimension table to your dataset and then pull in the quarter from your date dimension table.

mlanterma

Hi,

Thank you for the answers.

The Concat worked for what I needed.

For the date dimension table, would that be a static spreadsheet that I load into Domo and then join to whichever data flow requires?

GrantSmith

Essentially yes. Domo does supply a Dates dataset in the Domo Dimensions connector which gives you a list of dates as a starting point you can modify with a view or ETL to do additional processing / adding of columns to.

jaeW_at_Onyx

@mlanterma

1) yes, you can upload your date dimension as a spreadsheet and then add it to your dataflows.

2) you can generate one in MySQL with the columns you need (this is what I implement for clients)

3) you can use the Date Dimension as @GrantSmith recommended.

No matter which method you adopt, the point is to create one place where you implement the logic that you need for all your date-based calculations. This way you don't have to keep implementing the same logic in each of your cards in analyzer, it's just part of the data.