Forum Discussion

raq3's avatar
raq3
Frequent Visitor
3 years ago

Combine 3 variables in one graph

Hi everyone,

 

I have a data set with 3 pieces of information I need in one graph.

1 - Hours spent

2 - Job number 

3 - Cost Code

 

The problem is that in some job numbers, we have more than one cost code, which creates different graphs as you can see below.

 

I would like to have one graph with one job number and all cost codes separated by columns. Is that possible?

 

 

2 Replies

  • raq3 , You can have a visual with the axis as Job Number, Cost Code as legend and the sum of Hours spend as value.

     

    You can use Clustered column bar or stacked bar

    • raq3's avatar
      raq3
      Frequent Visitor

      Thank you amitchandak 

       

      Would it be possible to create a pie chart with that information?