How do I separate date and dimension (company) to make a line chart?

JC_U
New Member

I have the following data 

date, organization, some_percentage 

2022-05-23, company_a, 0.78

2022-05-23, company_b, 0.80

2022-05-23, company_c, 0.67

2022-05-24, company_a, 0.79

2022-05-24, company_b, 0.805

2022-05-24, company_c, 0.68

I want a line chart with the X axis as the date (just one date), and left Y axis as the percentage. I want the company names to be on a legend with different colors so that for each date, I see the companies changing percentages over time. In other words, I want to see just one ‘2022-05-23’ on the x axis, and each company’s percentage for that date, and then ‘2022-05-24’ I want to see each company’s percentage and so on...

What is currently happening: On the X axis, I get a date AND org (ie. ‘2022-05-23 company_b’, ‘2022-05-23 company_a’, and so on). 

Solved Solved
0 2 140
1 ACCEPTED SOLUTION

Click PIVOT on the company/organization name. This will create separate lines for each

7acafb31-0218-4953-920b-e0627b1c96e2.png

View solution in original post

2 REPLIES 2

Click PIVOT on the company/organization name. This will create separate lines for each

7acafb31-0218-4953-920b-e0627b1c96e2.png

JC_U
New Member

@Dawid I figured it out before you replied but I am happy we came to the same resolution! Thank you for answering. ??

Top Labels in this Space
Top Solution Authors