Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a line chart from a data set that the following fields:
ReportDate | Department | Division | Section | Employee | Color | Count |
I am trying to create a line chart to track the historical trends of "Color" between each report date. I will have "Department", "Division", "Section", and "Employee" as filter panes only. Within "Color" there are 5 options: "Green", "Yellow", "Orange", "Red", and "Other" all as text. I want my line chart to ONLY display "Green", "Yellow", "Orange", and "Red", NOT "Other". At the moment, my line chart displays all 5. I tried the formula below, but it did not work.
=aggr(only({<[Color]-={'Other'}>}[Color]), [Color])
Any guidance or assistance would be greatly appreciated.
I suppose I wasn't thinking, that's why 🙂
Since I already have all the counts in my data, I changed it to the SUM and it worked beautifully. Thank you very much @dplr-rn !
Sum({<[Color]-={'Other'}>}Count])