SusieQ Member

Yes, I've used it before; it's been awhile since I've dabbled and I'll have to test it again - I'm publishing the cards to SharePoint via the PowerPoint option.

That will have to do! Interestingly I just came across this scenario again and in googling found my own question. LOL. It's just too bad, as sharing the card via PowerPoint all the data will be split up. Thanks again!

Sorry that I missed your response long ago! I wanted the legend to display only the counties that have a value. For example, "DuPage - 2".

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?