Forum Discussion
Creating categories for X axis
Hi Community,
In one of my reports I wanted to create a visual that shows the amount of days in categories. So 1to 30 days is category 01, 31-60 days is category 02, and so on. I have a solution that works, see the graph below. As you can see it shows the categories.
However, to accomplish this I had to create quite an extensive formula for this, as shown below. Does anyone have any ideas for better and faster ways to accomplish this?
Thanks in Advance!
Menno
Click on the column you want to group then in column tools > data groups create a new data grouping.
I prefer to work with the list grouping and specify what goes into each group. Hope this helps!
1 Reply
- Syk
Resident Rockstar
Click on the column you want to group then in column tools > data groups create a new data grouping.
I prefer to work with the list grouping and specify what goes into each group. Hope this helps!