SusieQ

Ingenious. Thank you!

Thanks for the reply! We installed on sandbox for all users. We uninstalled and reinstalled and it seems to be working now. No idea why.

Yes! The case statement worked. Thanks so much!

Good thought! I applied your formula, but no luck. It still appears blank in the table without the text. I also double-checked my report source and there are no extra spaces. Any other ideas are welcomed, I am willing to try!

This worked! Brilliant. Thank you! Also, I took your suggestion and used the current date. For anyone who is reading this post, the solution for me was: COUNT(case when YEAR(`Last Login`) = year(CURRENT_DATE()) then `Last Login` end) I used the Progress Bar chart type and got the results needed.

We are also having card sizing issues. The card cuts off the legend or eliminates key information like averages. The only way to get the information to display is to make a full page card size, but we need them smaller (like 3x3). Is there any resolution to size and include all of the card information?