Solved

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

  • 26 May 2022
  • 2 replies
  • 32 views

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). 

 

icon

Best answer by Dawid 26 May 2022, 23:30

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +1

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

 

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