Best Of

@RobSomers yes i did use the arrow and select all datasets

@MichelleH i wanted to avoid using that global date filter as the use case is for users to select specific quarter ranges.

overall i found the issue: although i select all datasets when setting the page filter, upon using the date filter there is an additional dataset drop down option. I've now changed that to the 'most complete' dataset and the issue is resolved for me. I saved this new configuration with the default filter but still user is saying they are still having this issue.

It is also unfortunate that in this additional dropdown I am not able to multi-select.

@JasonAltenburg You would need to make sure that the field you're using for your x-axis is a timestamp that contains minutes. Also make sure that your field is has both date and time:

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 

In an effort to more simplify the comma delimited version of the beast mode I'm posting an alternative version instead of having to check every single different potential lengths it will automatically calculate the different sections automatically making the beast mode more readable. This version also handles numbers up to the quadrillions (21 digits). It also reduces the original version of the beast mode from roughly 60 lines to about 9 and increases the digits of precision (billions -> quadrillions).

REPLACE(TRIM(CONCAT(
  SUBSTRING(`Number`, 1, CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END), ' ',
  SUBSTRING(`Number`, 1 + (3*0) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' ',
  SUBSTRING(`Number`, 1 + (3*1) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' ',
  SUBSTRING(`Number`, 1 + (3*2) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' '),
  SUBSTRING(`Number`, 1 + (3*3) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' '),
  SUBSTRING(`Number`, 1 + (3*4) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' '),
  SUBSTRING(`Number`, 1 + (3*5) + CASE WHEN MOD(LENGTH(`Number`), 3) = 0 then 3 ELSE MOD(LENGTH(`Number`), 3) END, 3), ' ')
), ' ', ',')

This is a simplified version which only handles positive whole numbers but could be expanded to handle negative numbers and decimals.

I played around a bit with combining a multi-value gauge card with a flex table card:

I feel like that provides a pretty clean look.