Maria Db Table
Time | Person | Score
1 | A | 110
1 | B | 110
1 | A | 10
1 | C | 20
1 | A | 210
1 | D | 50
I would like to have timestamp in X-axis and each Person’s Score in Y-Axis .(multiple lines)
How to achieve multiple metric using MariaDb.
I have tried Templating Variables for Person.
$Person SELECT DISTINCT
SELECT UNIX_TIMESTAMP(Timestamp) as time_sec, Score as value, $Person as metric FROM
Table1 where Person IN ($Person)
if I choose multiple persons, the metric does not scale up with multiple values.
Kindly suggest an approch
Thanks & Regards.