I'm really unsure how to ask this question without a picture.
I'm trying to use Chart (Graph > Chart) to display the number of username occurrences in a csv, grouped by month and, obviously, the usernames by color. Basically, a colorful histogram grouped by month (day, time, etc.).
The problem is, there are so many users, it really becomes visually cluttered when usernames are given a space in a month where they don't show up. For example, the first blue arrow shows 'tz' having zero occurrences one month, and then the other blue arrow shows 'tz' having more than zero occurrences another month. The other colored arrows highlight the same thing with other names. I would love to be able to hide the names without any data for those months.
If there is any possible way to do this–i.e. use a different graph–I would be the most glad receiver of that know-how.
Thank you for your help in advance!
Can you try using Graph Builder and nesting your grouping column for month on the X-axis along with Name?
I think that will give you what you're looking for. Here's an example with Big Class. Pretend that Age is your Month column.
If you go to:
Rows==>Data Filter
and then select your X column to filter on and select the "Select","Show" and "Include",
You can restrict the values displayed on the X axis
The local data filter is your friend in situations where the graph has a bit too much on it. The tricky part is to identify what the items you wish to exclude have in common.
In this case you wish to exclude where your Y variable is missing or zero. If the cells contain zeros then you can add the Y to the local data filter and adjust the range.
If the cells are empty (missing) then you will need to choose 'Select Missing' from the hotspot on the filter for your Y variable and check the 'Inverse' button.
It seems like we are very close to an answer, but the problem–from what I can tell–is that my Y variable is the number of occurrences of one of my X variables, username.
In the picture below, I need the variable to not show up under the left black arrow, but to show up under the right black arrow.
Thank you for the help!
Can you try using Graph Builder and nesting your grouping column for month on the X-axis along with Name?
I think that will give you what you're looking for. Here's an example with Big Class. Pretend that Age is your Month column.
Wow. I am almost certain that was one of the first things I tried–everything in Graph Builder–and it didn't work, but now it most certainly does. As an FYI, one of the main things I was bumping was that I had no Y variable, as your example does. However, Graph Builder used the count of occurrences (histogram) as the Y variable. Brilliant. Thank you!