Using data as a grouping

tommyl — Sat, 16 Nov 2024 05:11:58 GMT

Hello,

I have below "Customer Table":

And a "configuration table" like:

Segment Name

SOHO

SME

INDIVIDUAL

Segment Names are alterable/ dynamic (new segment name can be added to this table).

I need to count the customer's by segment name but in the set expression i don't want to write this hardcoded:

count(distinct(({$<segment={'SME'}>}customerid)).

I need to take the segment names(above set expression 'SME' value) from the configuration table. Is there a way to do this?

Thank you

Re: Using data as a grouping

Gysbert_Wassenaar — Tue, 23 Jul 2019 09:36:09 GMT

I think that when loading the data you should rename the field Segment to Segment Name.

But if you want to do it the complicated way you can try: count(distinct(({$<segment=P([Segment Name])>}customerid))