line chart with data pairing

[Anonymous]

Hi

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

For example, with the data set as follows:

Date	ProductID	Defective	Accepted
1/3/2023	1	90	1000
1/3/2023	2	200	1200
1/3/2023	3	100	1500
1/3/2023	4	30	1500
2/3/20203	1	50	1300
2/3/20203	2	150	2300
2/3/20203	3	80	1600
2/3/20203	4	350	1800
3/3/2023	1	230	1900
3/3/2023	2	140	1400
3/3/2023	3	320	1500
3/3/2023	4	40	1200

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!

[Anonymous]

many thanks!

[joaoribeiro]

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]

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 · Accepted solution]

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