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.