Forum Discussion

V24's avatar
V24
Icon for Helper I rankHelper I
2 years ago

Filtering visuals on a daily/ monthly basis

I have 5 columns: Process Name, no of robots, avg time for robots, date, time(aggregated for 3 hours). I have a stacked column chart with time on x-axis like this: 2:00:00,5:00:00,8:00:00,11:00:00 et...
Need Help
V24's avatar
V24
Icon for Helper I rankHelper I
2 years ago

Hi the timestamps have to be in the x-axis. Essentially I want to show what was the average handling time at 2:00:00 on a daily basis (ie taking the average of  robot handling time at 2:00:00 for  all days and for all the timestamps) similarly for months.

V24's avatar
V24
Icon for Helper I rankHelper I
2 years ago

For the months 2:00:00, 5:00:00 etc will be on the x-acis the avg time is calculated as follows: average of the total time take by robots on a monthly basis for 2:00:00,5:00:00 etc