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?
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 | +------------+--------+--------+
