Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show both dimensions on x axis in bar chart?


Hi,

I have bar chart with two dimensions and one expression. Is it possible to show both dimensions on x axis?

Dimension1: CustomerGroup

Dimension2: Stage

Expression: Count(Distinct(CustomerID))

At present it is showing only CustomerGroup on x axis, and Stage is displaying as legend. but I need both dimensions on x axis with legend as CustomerGroup.

Can anyone suggest me please.

Thanks.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

12 Replies
its_anandrjs

You can concat the dimension or add the calculated dimensions and make the bar chart like

Dimension1: CustomerGroup&'-'&Stage

Expression: Count(Distinct(CustomerID))

MK_QSL
MVP
MVP

Add one more expression by simply writing

1

Don't mention anything and let me know what is happening !!!

Not applicable
Author

Thanks. How can I get the value on data points?

Not applicable
Author

Thanks. Is there any way that we can bold the second dimension

I,e

for eg: I need  Accounts-Administrator

MK_QSL
MVP
MVP

Check enclosed file..

Not applicable
Author

When I am adding second dimension it is showing as 1. so I am not getting expected bars. how can I set this? please see attached.

MK_QSL
MVP
MVP

Kindly load your sample file

its_anandrjs

No unfortunately you can make the whole dimension bold like Accounts-Administrator.

Not applicable
Author

Please see attached.