Exclude Weekends from Dashboard/Tiles

Help Insights
1

Hey all,
We don’t regularly run our bots on the weekend so I’m trying to exclude Saturdays and Sundays from our Robot Utilisation dashboard.

Is there a known way to remove or filter out specified days of the week in Insights?

I’ve been trying to find a way to format date results to include the day of the week so I can exclude weekends that way but have had no luck.

Thanks,
Julian

2

Hi @Julian_Lewis

Set the time trigger in orchestartor and configure like below,

The image shows a scheduling configuration screen in UiPath Orchestrator, where a task named "Log" is set to run weekly from Monday to Friday at 12:00 AM in the UTC timezone with an unattended production runtime. (Captioned by AI)
The image shows a scheduling configuration screen in UiPath Orchestrator, where a task named "Log" is set to run weekly from Monday to Friday at 12:00 AM in the UTC timezone with an unattended production runtime. (Captioned by AI)1270×603 40.4 KB

If you found helpful, feel free to tick as a solution.
Happy Automation

3

Hi @Julian_Lewis

At which time do you want to trigger the bot in week days. You can use the cron expression to trigger whenever you want.

4

Thanks for the quick responses @mkankatala and @prashant1603765.

We are happy with the triggers and enable our weekend triggers if we have unprocessed volumes at COB Friday.

What we are trying to do is exclude weekend data from tiles/dashboards in Insights so the robot utilisation calculations are only based on Monday-Friday.

5

@Julian_Lewis

Sure! Here are simple UiPath steps to exclude weekends in Insights dashboard:

  1. Open UiPath Insights.

  2. Edit your dashboard or tile.

  3. Add a filter:

    • Click “Add Filter”.
    • Select your date field (e.g., StartTime).
    • Use Day of Week function:
      DayOfWeek([StartTime])

  4. Set filter condition:

    • Filter where:

      DayOfWeek([StartTime]) is between 2 and 6

    • This keeps Monday (2) to Friday (6) only.

  5. Apply and save the dashboard.

This will remove Saturday and Sunday data from your visualizations.

Happy Automation

6

Hey @Julian_Lewis hope this can help you.

The image shows a UIPath Orchestrator settings page for configuring calendars of non-working days, featuring a calendar for April 2025 and options to input or upload CSV files. (Captioned by AI)
The image shows a UIPath Orchestrator settings page for configuring calendars of non-working days, featuring a calendar for April 2025 and options to input or upload CSV files. (Captioned by AI)1365×677 56.4 KB

cheers

7

@prashant1603765 I might be missing something but I can’t find the “DayOfWeek” function in Insights.

Are you able to provide a screenshot of what you’ve described?

8

Is there a way for Insights to reference a calendar? I’m looking to only exclude weekend data from a specific dashboard in Insights, not stop running RPA jobs on weekends

9

Hey @Julian_Lewis hope this link help you

and also kindly visit this youtube link this might be useful for you as well.

cheers

10

Hi @singh_sumit, I’m wanting to reference our existing calendar from an Insights dashboard, not create or change the calendar.

Do you know if it’s possible to do this?

11

Hey @Julian_Lewis if you want to exclude weekend .then you could try this in your project

1 option -
select the Frequency (Monthly Day week) and select all days except - Saturday and sunday.

The image shows a "Create Time Trigger" configuration screen with fields for naming, selecting process, job priority, runtime type, timezone, frequency, specific weekdays, and non-working days restrictions. (Captioned by AI)
The image shows a "Create Time Trigger" configuration screen with fields for naming, selecting process, job priority, runtime type, timezone, frequency, specific weekdays, and non-working days restrictions. (Captioned by AI)1180×585 39.7 KB

2 option -
in your process select the frequency as Advanced and write the cron expression for exclude Saturday and sunday.

The image shows a time trigger configuration screen for an automation process, featuring settings such as name, process, job priority, runtime type, timezone, frequency with advanced options, custom cron expression, and non-working days restrictions. (Captioned by AI)
The image shows a time trigger configuration screen for an automation process, featuring settings such as name, process, job priority, runtime type, timezone, frequency with advanced options, custom cron expression, and non-working days restrictions. (Captioned by AI)1249×601 46.5 KB

3 option - go to tenant -setting-non working days

The image shows a screenshot of the UiPath Orchestrator settings interface, specifically the section for configuring non-working days in a calendar named "calender1" with April 2025 being displayed. (Captioned by AI)
The image shows a screenshot of the UiPath Orchestrator settings interface, specifically the section for configuring non-working days in a calendar named "calender1" with April 2025 being displayed. (Captioned by AI)1365×677 56.4 KB

select date and save that calender

The image shows a UIPath Orchestrator interface where users can configure calendars for non-working days, featuring a calendar view of April 2025 and options to upload CSV files or manually select dates. (Captioned by AI)
The image shows a UIPath Orchestrator interface where users can configure calendars for non-working days, featuring a calendar view of April 2025 and options to upload CSV files or manually select dates. (Captioned by AI)1365×677 56.4 KB

then go to your process select the Frequency Advanced and then select the calender you create.

The image shows the "Create Time Trigger" page in UiPath Orchestrator, with fields for configuring a sample automation job including process, job priority, runtime type, timezone, frequency, and a custom cron expression. (Captioned by AI)
The image shows the "Create Time Trigger" page in UiPath Orchestrator, with fields for configuring a sample automation job including process, job priority, runtime type, timezone, frequency, and a custom cron expression. (Captioned by AI)1365×641 51.5 KB

cheers

12

Hi @singh_sumit,

I’m not trying to stop processing on weekends.

What I’m trying to do is change an Insights Dashboards to only show data from weekdays.

We have found a solution but it has some limitations:

Solution
Step 1: Add a filter for the date related field you wish to filter. In this example it is “Jobs - End Time”.
Step 2: For “Control” select “Advanced”.
Step 3: In the “Configure Default Value” dropdown select “matches (advanced)”.
Step 4: Enter the days of the week you wish to return separated by commas. In this example we want Monday through Friday, so we will enter this:
monday,tuesday,wednesday,thursday,friday

The image shows a filter configuration screen titled "Weekdays Only," with advanced settings to match job end dates form Monday, Tuesday, Wednesday, Thursday and Friday, allowing multiple filter values. (Captioned by AI)
The image shows a filter configuration screen titled "Weekdays Only," with advanced settings to match job end dates form Monday, Tuesday, Wednesday, Thursday and Friday, allowing multiple filter values. (Captioned by AI)653×598 25 KB

Result
The results only include weekdays, but is limited to only show that most recent of each week day.

Before apply “Weekdays Only” filter it will show every day, including weekends, from the past 14 days.

The image displays a bar chart titled "Robot Utilisation" over the last 14 days including all days of the week, illustrating the average hours robots spent processing compared to not processing each day. (Captioned by AI)
The image displays a bar chart titled "Robot Utilisation" over the last 14 days including all days of the week, illustrating the average hours robots spent processing compared to not processing each day. (Captioned by AI)1178×483 36.4 KB

With “Weekdays Only” filter applied it now only shows the most recent example of each weekday, not every weekday in the last 14 days.

The image shows a bar chart depicting robot utilization filtered to show results from weekdays over the last 14-days, but due to the limitations of the arrangement, only the most recent Monday, Tuesday, Wednesday, Thursday and Friday are being returned.
The image shows a bar chart depicting robot utilization filtered to show results from weekdays over the last 14-days, but due to the limitations of the arrangement, only the most recent Monday, Tuesday, Wednesday, Thursday and Friday are being returned.1045×365 22.4 KB

If anybody know how to improve this solution so it includes results beyond past week please let me know.