How can I display 2 Dimensions on X axis (bar chart)

[idan_shamir-163]

Hi, I am trying to create a graph with dimensions: date & name in the X axis, with some measures that are stacked.

I’d expect the visualisation to group multiple names that belong to the same date & display the date only once. But that doesn’t happen & as a result part of my x labels is trimmed if the label is too long.

what I get:

what I’d like to have:

Is there any way to do that in one graph? I don’t want to have the names as pivot cause then I will have multiple graphs.

[Vimal1]

Hi Idan, 

This is possible with changing some custom settings in the visualization. go to visualization settings and give a custom X axis name.

under X axis tab, enter the custom axis name, in your case “ the date”

then you have to hide the date from the visualization. 

Then you’ll get you expected result. I hope this helps. 

once you click hide from visualization, the date doesn’t show up in our bar chart

[idan_shamir-163]

@Vimal1 thanks for the detailed answer.

Unfortunately, this is not what I was looking for.

I am looking for a solution that would work programatically on multiple dates, and with changing data, so I can’t name the entire x axis with one specific date.

Thanks.

[kai2991]

I'm looking for something like this as well. Did you find any solution?

[nehagilson-pc]

I had the same issue and using Pivot in the data section automatically helped.
In the data section pivot the column by which you want to group the visualization.