Forum Discussion

schreima's avatar
schreima
New Member
3 years ago
Solved

chart with 2 x-axis

Hi there,

 

I'm having the following table as basis:

 

Dateamount of on-handDate End of Leadtimeamount end of leadtime
05.05.231012.05.238
06.05.23913.05.2313
07.05.23914.05.2313
08.05.23915.05.2313
09.05.23816.05.2312
10.05.23817.05.2312
11.05.231318.05.2312
12.05.231319.05.2311

 

I would like to plot 2 line charts in one visual with their corresponding x-axis - so for line 1:  x-axis 1 =05.05.23, y-axis: 10, x-axis 2: 12.05.23, y-axis: 8, where x-axis are running synchron (meaning on 12.05. I can see on hand = 13, amount end of leadtime = 8

 

Do you have any idea how to realize that?

 

Thank you very much

Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    3 years ago

    I think you want to create a date table with 2 relationships to the 2 dates in your table(one will be active, one inactive).

    Create a measure for the SUM of end of leadtime using USERELATIONSHIP.

    Put the date from the date table on the x-axis of a line chart. Put Sum of amount on-hand in the y-axis. Put the measure on the secondary y-axis.

    I think that's what you want.

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    I think you want to create a date table with 2 relationships to the 2 dates in your table(one will be active, one inactive).

    Create a measure for the SUM of end of leadtime using USERELATIONSHIP.

    Put the date from the date table on the x-axis of a line chart. Put Sum of amount on-hand in the y-axis. Put the measure on the secondary y-axis.

    I think that's what you want.