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
samratpbi's avatar
samratpbi
Icon for Super User rankSuper User
2 years ago

Hi, you already have the measure it seems. Simply use dates in x-axis instead of time to show day wise average. Similarly use month in x-axis for month wise average. 

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