How to combine values in one Field under one value

kfahri342 — Sat, 16 Nov 2024 01:19:44 GMT

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?

Re: How to combine values in one Field under one value

fannybenand — Fri, 07 Feb 2020 12:00:59 GMT

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