Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have below "Customer Table":
Segment | Customer ID |
SME | 12345 |
SOHO | 12346 |
SOHO | 12347 |
INDIVUDUAL | 12348 |
SOHO | 12349 |
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
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))