Charts with multiple columns on X axis

Dheeraj_1996

I want to create a chart in DOMO with multiple columns on X axis in the below way? How can this be done?

I tried to add multiple columns on the X axis but it doesn't take.

MichelleH

@Dheeraj_1996 I agree with using the chart types the others have suggested. Here is a KB article with more details on how to structure your data: https://domo-support.domo.com/s/article/360043429153?language=en_US

You may also want to consider the nested bar chart, which will calculate the total without having to restructure your data: https://domo-support.domo.com/s/article/360042924794?language=en_US

Juliann_Potter

@Dheeraj_1996 you can do this with a line and grouped bar, but you need to manipulate the dataset to that total, low, medium, high, critical are all a label in a single series column and the data is all in a second value column in the dataset. Then the X-axis would be your Total ticket, by MS team, by TT, Closed, Open Tickets. Here's an example of one I did like this, but my x-axis was month.

trafalger

Have you tried the grouped bar + line chart type? Your data does need to be structured a certain way to get that to work

EDIT: I meant grouped, like @Juliann_Potter recommended.

Juliann_Potter

MichelleH

@Dheeraj_1996 I agree with using the chart types the others have suggested. Here is a KB article with more details on how to structure your data: https://domo-support.domo.com/s/article/360043429153?language=en_US

You may also want to consider the nested bar chart, which will calculate the total without having to restructure your data: https://domo-support.domo.com/s/article/360042924794?language=en_US