Filter using multiple date fields

Kadambari

Hi there,

I have created 5 calculated columns in DOMO analyser that get me the max date in each of the fields (Let's call them- Reconsideration date, Complied Date, Status last updated date, Appeal date and Death Penalty Date). They are all derived from a number of different fields with different conditions and then I applied MAX() to each of these calculated columns. Is there a way to have a date range filter that will control all these calculated columns? And based on the selected date range, I should be able to see the max date output in each of these columns that fall within that range. DOMO filter only allows me to choose one field but that won't be helpful in this case since we are dealing with multiple date fields.

I have tried so many things and I am so lost now.

GrantSmith

Filters work on a per column basis so you couldn't have an individual filter for all of the dates. What you may be able to do is utilize a Date Dropdown variable, write a beast mode to determine if any of the dates are between the start date variable and the end date variable and return 1 if they are or 0 if they are not and then filter for the value 1 in your card.

ColemenWilson

You can use the GREATEST() function in a beast mode to get the max date across these date fields and then use that as the date filter.

GrantSmith

Filters work on a per column basis so you couldn't have an individual filter for all of the dates. What you may be able to do is utilize a Date Dropdown variable, write a beast mode to determine if any of the dates are between the start date variable and the end date variable and return 1 if they are or 0 if they are not and then filter for the value 1 in your card.

ColemenWilson

You can use the GREATEST() function in a beast mode to get the max date across these date fields and then use that as the date filter.