Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my Dash board i have a chart and Straight table in that i need to merge two rows and i need to show as single row.
Exampl
ServiceType | volume1 | volume2 |
---|---|---|
Inquiry | 15522 | 4522 |
Service | 1271 | 6354 |
Other Service | 963 | 123 |
Unclassified | 75 | 12 |
need to merge Inquiry and Service as a single column Like "Cases" and Do the Sum of the two rows.
ServiceType | Volume1 | Volume2 |
---|---|---|
Cases | 16793 | 10876 |
Other Service | 963 | 123 |
Unclassified | 75 | 12 |
Cases = Inqiry and Service.
How can i do this...Please help .
Hi,
You can get it done by writing condition in dimension.
PFA
Warm Regards
Joshmi
or yoy can add a calculated field and use it as dimension
load
*,
if(match(ServiceType, 'Inquiry', 'Service'), 'Cases', ServiceType) as ServiceTypeGroup;
LOAD * INLINE [
ServiceType, Vol1, Vol2
Inquiry, 15522, 4522
Service, 1271, 6354
Other Service, 963, 123
Unclassified, 75, 12
];
Hi Joshmi,
Would you mind to share your solution?
I'm using Personal edition.