Forum Discussion
How To Differentiate 2 Different Items On Line Chart With Same Date?
Hey all,
I am plotting out a series of averages for part numbers. However, some of them have the exact same date and time. When I plot this on a line chart with Date as the X-axis as Categorical type, it combines both instances in the same plot point.
Thank you.
And if you place the date and "order #" on the x-axis and then click on "Expand all down one level in the hierachy".
11 Replies
- Hi powerboss ,Is this the case with you? When the values of x-axis and y-axis are the same, the points of the line graph will coincide, which is caused by the principle.If not, please upload your data and screenshot.(Please mask any sensitive data before uploading)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 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 #".
