Ok, so here is my problem. I have table that i have link to Tableau, that contains member visits (1 row for each visit). I want to create a field that i can use as a filter that contains regular uses (<=2 visits), frequent users (3-9 visits), and super users (10+ visits).
I cant figure out how to make this happen. I have other filters like time period and county. I need the counts to adjust when someone filters these.
January time period and coos county are selected. I would only want the records for those (easy so far...). Now i want to add another filter called "Utl Group" (that contains "regular user, frequent user, and super user"). I tried a few different ways but the numbers always come out wrong.
Hopefully im not sounding crazy here.
So if i had a summary page and i filtered for: Jan, Coos, Super User = 1 member
All, Coos, Super User = 2 members
All, Coos, Frequent User = 1 member
You get the idea.
Any thoughts on how i could create this Utl field? I've tried a case statement in a calculated field and have come up short.
Hi Brett. It sounds like you might need to use LODs. Try this:
SUM(Number of Records)