Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!
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!
User | Count |
---|---|
57 | |
21 | |
18 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |