Start a new topic

How to count the number of WFH days per user with Excel

Here's how you can count the number of WFH days per user with Excel.



Note: You must be a Waldo Organization Administrator (or an area owner, office owner or license administrator) and being license with the complete version of Waldo.
More information here: 
https://customer.hellowaldo.app/en/support/solutions/articles/8000101561


  1. Start Excel.

  2. Activate the Power Pivot for Excel add-in as described here: https://support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8

  3. Click on data then get data and select From OData Feed.


  4. Select "Basic", enter the following URL: https://odata.hellowaldo.app and click ok.



  5. Click Select multiple items, then CustomLocationReservations and Users.


  6. Select the Data tab, then RelationShips.


  7. Click New..., define the relationship as below and click OK.


  8. Right-click on CustomLocationReservations then select Load To...


  9. Select PivotTableReport and Existing worksheet.


  10. Define the PivotTable as below.
    (ensure you selected All)
  11. Filter with the HOME field.

  12. Here you go!

  13. Save your file and refresh data when you need.

Login or Signup to post a comment