how can i design this kind of chart in DOMO?

x axis is the month

left Y axis is the stacked bars. each stacked bar is 100%. blue one is for normal order. orange one is for sampling order. they are both in %. they are the percentage each order type takes and are calculated based on the corresponding order quantity of each type.

right Y axis is the lines. blue line is for normal order. orange one is for sampling order.

they are both in Number. they are not stacked.

from this chart, I can see the actual order quantity for each type of order, and the percentage of the order type.

there are 2 types of orders, normal and sampling.

can you pls help?

thanks

Tagged:

Best Answer

  • david_cunningham
    Answer βœ“

    @Lu_zhang - Domo has a line + 100% stacked bar card type. You can then specify the number of series that you want shown on the left scale to get your 2 lines + 2 bars.

    David Cunningham

    ** Was this post helpful? Click Agree πŸ˜€, Like πŸ‘οΈ, or Awesome ❀️ below **
    ** Did this solve your problem? Accept it as a solution! βœ”οΈ**

Answers

  • david_cunningham
    Answer βœ“

    @Lu_zhang - Domo has a line + 100% stacked bar card type. You can then specify the number of series that you want shown on the left scale to get your 2 lines + 2 bars.

    David Cunningham

    ** Was this post helpful? Click Agree πŸ˜€, Like πŸ‘οΈ, or Awesome ❀️ below **
    ** Did this solve your problem? Accept it as a solution! βœ”οΈ**

  • Lu_zhang
    Lu_zhang Member

    I had found line +100% stacked bar chart before posted this help. but still failed.

    I realize right now that each of the column doesn't have the series probably is the problem point, which you've already pointed out to me. thank you so much for reminding me at the beginning.

    when I first time read your below picture's words, I did not quite understand, now I find it.

    Thank you for your thoughtful sharing!

    @david_cunningham