Hello! I created a Test dashboard that pulls all of our art school classes for a specific season. I'm trying to figure out if there's a criteria or a simple formula that pulls classes with 0 registrations. I attached my dashboard below. I thought using a conditional formula that is equal to 0 for registrations but there's no change. One class called Studio Art Sampler: Sequential Monoprinting, we know for sure that it has 0 registrations.
Our Art School department would like to see both the # of registrations and 0 registrations to see classes that aren't getting attention.
Spring2024YardSchoolofArtTEST.dash
Thanks!
If there is NO data, it will count as a NULL (not 0). I'd suggest using a CASE statement. Something like this:CASE WHEN [Total Ticket Count] = NULL THEN SUM(0) ELSE [Total Ticket Count] END
Would it be considered a new formula or insert it the ticket count values? Sorry, I'm very beginner level when it comes to formulas.
I would click the vertical ellipse and Duplicate the Value. Then I would turn off the original. You just mess with the duplicate version and can always go back to the original. Does that make sense?
Yes it does. Unfortunately, adding the formula did not change anything. It's not pulling any performances with no registration.
Does it help if you add "Seat Count" as a value?
This is what I did and nothing changed.
Actually figured it out. By turning off the fiscal current year offset in the widget filter brought back the performances with 0 registrations. Thanks for all the help.
Yeah, those Filter settings are notorious for that. I usually revisit my filters when it doesn't give me the expected results. More times than not, it was the filter settings.