I was able to create a bar chart view by adapting the formula from a post here titled ("Count and group with a ref"), and I got this view (image below). What I want is to display the COUNT in ascending (or descending) order. How do I do that?
The adapted formula is:
COUNT(
SELECT(enrollment[enrollment_id], AND(
[status] = "Completed",
[mentor_id] = [_ThisRow].[mentor_id]
))
)
'enrollment' is the parent table; 'mentor_id' Ref's the 'mentor' table:
Solved! Go to Solution.
You can sort by aggregate values with the in-preview charting feature, but I don't believe it's possible with the base charting functionality.
You can sort by aggregate values with the in-preview charting feature, but I don't believe it's possible with the base charting functionality.
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |