Filter data from line chart

[mskusace]

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.

[dplr-rn · Accepted solution]

Why are you using aggr here? Any specific reason?

It maybe simpler than that
Suppose measure in your line chart is Count(IDs)
change it to Count( {<[Color]-={'Other'}>} IDs)

[mskusace]

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])