I'm struggling with figuring how best to visually look at the trending the following.
I have the following data in rows
date, entity_type, row_count, duration_of_execution
I would like to visually look at how the row_count vs duration_of_execution are trending on a daily basis, entity_type wise. I expect the relation between row_count
and duration_of_execution
to be increasing. For example, if the row_count
increases substantially, I expect an increase in duration_of_execution
. However, would like to investigate if that is not the case.
What is the best way to represent this visually? Ideally, if there is an anomaly I would want to drill down to a particular day and entity. If I think more, I would like this chart to be visible for a larger audience to glance at it high-level and for me to investigate further if I observe an anomaly.
I'm open to any technology but importantly looking for ideas on what type of chart and formula to correlate the row_count
vs duration_of_execution
on a daily basis.