Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I would like to know the correct formula, let's say:
Source | Type |
---|---|
Telephone | converted |
Mobile | reserved |
Telephone | others |
Mobile | converted |
Telephone | reserved |
The outcome should be
Total count Source /Type(converted & reserved)
Thanks.
Hi,
Can you show us your required output?
Hi,
Check this. Is this required output?
Count:
LOAD * INLINE [
Source,Type
Telephone,converted
Mobile,reserved
Telephone,others
Mobile,converted
Telephone,reserved
];
Hi Ice,
First load your data
and use following expression in front end:
choose table
dimension = Source
Measure = count(total source)/count({<Type={'converted','reserved'}>}Type)