Forum Discussion

powerboss's avatar
powerboss
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    And if you place the date and "order #" on the x-axis and then click on "Expand all down one level in the hierachy".

powerboss's avatar
powerboss
Frequent Visitor
6 years ago

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?

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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.

    • powerboss's avatar
      powerboss
      Frequent Visitor
      6 years ago

      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 #".

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Can you give more information, what you analyze and which values you show on the axis and in the legend?