0

I have created a script that tracks twitter followers over time, for many accounts, the data is saved to a table that looks something like this:

+------------+--------+-------+
|    DATE    |  USER  | COUNT |
+------------+--------+-------+
| 12/01/2018 | user A |  100  |
| 12/01/2018 | user B |   49  |
| 13/01/2018 | user A |  103  |
| 13/01/2018 | user B |   50  |
| 14/01/2018 | user A |  107  |
| 14/01/2018 | user B |   48  |
+------------+--------+-------+

The question is:
Is there a way to create a line chart from the given dataset?

pls

BTW, It's not possible to format the table like the following table, because the account names can change over time and the number of accounts may vary.

+------------+--------+--------+
|    DATE    | USER A | USER B |
+------------------------------+
| 12/01/2018 |    100 |     49 |
| 13/01/2018 |    103 |     50 |
| 14/01/2018 |    107 |     48 |
+------------+--------+--------+
  • line chart combo where it will show 1 line per all users like total? – user0 Jan 14 at 21:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.