Forum Discussion
Solved
chart with 2 x-axis
Hi there, I'm having the following table as basis: Date amount of on-hand Date End of Leadtime amount end of leadtime 05.05.23 10 12.05.23 8 06.05.23 9 13.05.23 13 07.05....
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.
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.