Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

line chart with data pairing

Hi

 

Does anyone knows if it is possible to have data pairing on a line chart?

For example, with the data set as follows:

DateProductIDDefectiveAccepted
1/3/20231901000
1/3/202322001200
1/3/202331001500
1/3/20234301500
2/3/202031501300
2/3/2020321502300
2/3/202033801600
2/3/2020343501800
3/3/202312301900
3/3/202321401400
3/3/202333201500
3/3/20234401200

 

I was trying to create a line chart with 4 sets of lines (one solid, one dotted) to represent each productid, with 2 lines each; one for defective and one for accepted.

With the date in the x-axis field, and productid in the Legend field, I am unable to add more than 1 column in the y-axis field; hence am unable to create the 8 lines I was hoping to.

Was hoping to get some help here in this channel.

Any guidence is greatly appreciated!

Thank you!

 

Need Help
  • joaoribeiro's avatar
    joaoribeiro
    3 years ago

    Hi Anonymous ,

     

    Great to know it helped! If it solved your problem, please mark it as solution ✔️

     

    Regarding your question, please use the field in the following way:

    • Category: Date
    • Value 1: Accepted
    • Value 2: Defective
    • Legend: ProductID

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

    Thanks!
    Best regards,
    Joao Ribeiro

4 Replies

  • joaoribeiro's avatar
    joaoribeiro
    Impactful Individual
    3 years ago

    Hi Anonymous ,

     

    With the native line chart you can use the small multiples to open the chart per ProductID, as shown below:

     

    Besides that, you have the "Advanced Line Chart" in the AppSource. Please find below how the free version looks like:

     

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

    Thanks!

    Best regards,
    Joao Ribeiro

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks joaoribeiro This is really helpful. May I know what are the fields that should be input to achieve the lines you have on the advanced line chart? Thanks again!

       

      • joaoribeiro's avatar
        joaoribeiro
        Impactful Individual
        3 years ago

        Hi Anonymous ,

         

        Great to know it helped! If it solved your problem, please mark it as solution ✔️

         

        Regarding your question, please use the field in the following way:

        • Category: Date
        • Value 1: Accepted
        • Value 2: Defective
        • Legend: ProductID

         

        Hope this answer solves your problem!
        If you need any additional help please @ me in your reply.
        If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

        Thanks!
        Best regards,
        Joao Ribeiro

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    many thanks!