Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart that has a Dimension of Brochures.Class. The data contains either Class III, Class II, Class I and OTC Drug.
Currently the chart lists each Dimension and sums the number of Total to Review and Total Completed in a stacked bar chart.
How can I combine the Class III and Class II bars into a single bar summing up both (Call it Class II/III). And do the same for Class I and OTC Drug (Call it Class I/Other). So I basically end up with a two-bar chart showing the sum of two expressions.
QVD is attached.
Thanks
Jeff
Hi Jeff,
Please add below code in dimension as calculated dimesion:
=If(Wildmatch(Brochures.Class,'Class 2','Class 3'),'Class II/III',
If(Wildmatch(Brochures.Class,'Class 1','OTC Drug'),'Class I/Other'))
Thanks,
Arvind Patil
Hi Jeff,
Please add below code in dimension as calculated dimesion:
=If(Wildmatch(Brochures.Class,'Class 2','Class 3'),'Class II/III',
If(Wildmatch(Brochures.Class,'Class 1','OTC Drug'),'Class I/Other'))
Thanks,
Arvind Patil
Please find the attachment.
Thanks,
Arvind Patil
Like this?
Arvind,that worked perfectly.
Thanks
Jeff
Please note that if you have to compare without wildcards, using match() is a better choice in terms of performance. And also, be careful of the fact that wildmatch() is case insensitive whereas match() is case sensitive.
Thanks, I'll keep that in mind
Happy to help you!
Thanks,
Arvind Patil