Forum Discussion

hmeltonPSL's avatar
hmeltonPSL
Helper II
2 years ago

Two datasets one bar chart

I have two queries from 2 different db tables.  I created bar charts for each.  Each bar chart has the same x axis,  I would like to merge the two bar charts togther into one chart. So the chart would be showing two different bar colors for each dataset.  Is this possible?  Thanks

 

Need Help

2 Replies

  • Anand24's avatar
    Anand24
    Super User
    2 years ago

    Hi hmeltonPSL ,
    Create a relationship between both tables on common field (Department in your case) and then pull both KPIs (# Requests and # Workorders) in a clustured bar chart visualization's X-axis.

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi hmeltonPSL 
    Create relationship between 2 table then take tornato chart to represent 2 coulmn in single chart or you can take stack  bar chart.

    Tornado Chart in above example.

     

    I hope I answered your question.