Best Of

@crico Since you are using multiple datasets, I recommend using dynamic date range filters and Filter Views. The global date filter is not tied to a specific date field, but instead uses whatever field is used in the Date Range settings of each card.

https://domohelp.domo.com/hc/en-us/articles/360042923914-Applying-Page-Level-Filters-with-Filter-Views#5.

@NathanDorsch You don't need your final "end". You only need an end when you're dealing with individual CASE WHEN statements.

Hi @NathanDorsch try removing the last "end" and see if that resolves the error.

You can filter your card to display only the latest information using analyzer and then on you can edit the dashboard it's on and change the interactions and tell it to not be affected by any filters.

When you have multiple items to clean, you will have one case statement and multiple when statements, like this:

 case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO'
 when Right(`Entry Store`,5) = 'VAC"}' then 'VAC'
 when Right(`Entry Store`,5) = 'SIC"}' then 'SICK'
 when Right(`Entry Store`,3) = 'OTH' then 'OTHER'
  end 

you can vary what you are evaluating on as well. In the last when statement, for example, I am just looking at the last 3 character of the field. I could also look at a totally different field if I wanted. You can also add an ELSE statement just before end to deal with any scenarios you didn't account for, like this

 case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO'
 when Right(`Entry Store`,5) = 'VAC"}' then 'VAC'
 when Right(`Entry Store`,5) = 'SIC"}' then 'SICK'
 when Right(`Entry Store`,3) = 'OTH' then 'OTHER'
 else `Entry Store` end