I am using Grafana 8.3.4 and MySQL 8 as datasource. I have two fields insert_timestamp and email. I am using Status History plugin and running the following query
email as value
GROUP BY $__timeGroup(insert_timestamp,‘15m’)
When I choose Table View, I get the data in the below format
But when I turn off the Table View, I get the data in the below format
- How do I have continuous time-series in X-Axis?
- How can I have Grafana dynamically set unique color codes for same email ids?
For eg: All email ids of firstname.lastname@example.org should be in Red.
Since there can be N number of unique emails, is there a way to color-code each of them automatically?