How to combine values in one Field under one value

[kfahri342]

Hi All,

I have a Donut chart with the following expression 

Count({<[Status] *= {'Complete', '*Planned 2020', 'Planned 2021', 'Pending'}>} ID)

For some views, its important that the Planned 2020 & Planned 2021 values are umbrellas under one field (lets call it 'Planned')

Can someone advise me on how to make this possible?

[fannybenand · Accepted solution]

Hello !

I guess you should create a new dimension "Status group' like the following:

=if(SubStringCount([Status], 'Planned')=1, 'Planned', [Status])

And then add this dimension to your donut.

Fanny