Forum Discussion
How To Differentiate 2 Different Items On Line Chart With Same Date?
And if you place the date and "order #" on the x-axis and then click on "Expand all down one level in the hierachy".
So this is an example. The data point that is 33.80 is actually 2 different instances, however they are being combined because they have the exact same date. How do I fix this?
Hi powerboss ,
but if you don't filter or structure according to the instance, how should it be represented?
Could an aggregation of MAX, MIN, AVG instead of SUM be a solution?
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
I need it to plot the 2 instances separately, as they are 2 separate orders, even if they are on the same date. I don't know if this is possible.
As of now, the only way that I can differentiate each order separately is by making the X-axis "Order #".
Can you give more information, what you analyze and which values you show on the axis and in the legend?
We are looking at labor data for manufacturing orders. The y-axis is labor hours. The x-axis should be chronological. We want to see the trend over time. The only way I can separate out each manufacturing order is if I make the x-axis "order #", which sorts them numerically, which is kinnnnnnnnda chronological, but not perfect, as some orders completed faster than others.