Creating categories for X axis

[Anonymous]

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

[Syk · Accepted solution]

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!