Skip to main content

I have a set of ticketing data that includes individual rows for each ticket. I'm attempting to see the number of games each individual fan and then group the fans that have attended X games, Y games, etc. Is there a way to do this? I keep running into AGG issues where I can see the data for each fan but can't show it as a bar graph for the total number of fans by the games they attended.

 

Attached what I was able to do.

Distinct Counts across two dimensionsScreenshot 2021-11-17 112548Screenshot 2021-11-17 112606

1 answer
  1. Nov 17, 2021, 4:40 PM

    Might trying going to Menu, Analysis, then UNCHECK Aggregate Measures. Best, Don

     

    Initial results w/Superstore Data:

    Might trying going to Menu, Analysis, then UNCHECK Aggregate Measures.After unchecking:

    Screen Shot 2021-11-17 at 8.39.55 AM

0/9000