Filter using multiple date fields

Kadambari
Kadambari Member
in Charting

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.

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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.

    If I solved your problem, please select "yes" above

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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.

    If I solved your problem, please select "yes" above

Categories