New user here - I'm sure this is basic but I can't figure it out. In Excel I'd just do subtotals.
How do I go from an initial report of x = people and y = widgets they have, to a summary showing the number of people who have each count of widgets? Basically counting the columns.
EDIT: My first attempt at this wasn’t correct, I don’t think.
Create a new Summarize row in the current Question and Summarize by Count (the derived column from the previous Summarize row).
Something like this (using Sample Database data):
The resultant chart is this, where X axis is the number of a widget the user purchased, and the Y axis is the number of such users:
That worked! Thanks so much!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
