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
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
duration_of_execution on a daily basis.