I’m a new Dundas user and am working to duplicate an existing dashboard.

The existing dashboard uses Tableau and does a fixed calculation to determine the hours an employee worked. The goal of the calculation is to accurately report the number of hours worked. However, the hours worked appear multiple times in the data, once for each piece of work the emloyee did. The solution in Tableau was to do a “fixed calculation” like this: {fixed employeeID, Day, timeIn: avg(hours)}

The fixed calculation held each employeeID, day, and timeIn “fixed” and averages the hours reported for that timeIn. The average is used because there are multiple rows containing hours for that timeIn, but the hours reported are all the same so averaging them returns the desired hours value. The result is a single value for hours for that day that can be used in other calculations, such as work performed per paid hour.

How does one do this in Dundas?

Sample data would look like:

```
employeeID Day timeIn Work Hours
1 21JUN21 21JUN, 6am 1 4
1 21JUN21 21JUN, 6am 2 4
1 21JUN21 21JUN, 6am 3 4
1 21JUN21 21JUN, 12pm 4 3
1 21JUN21 21JUN, 12pm 5 3
1 21JUN21 21JUN, 12pm 6 3
```

So the employee with employeeID of “1” had timeIn (logged in) twice on 21 June, at 6am and 12pm. He/she worked 4 hours under the first login and did work “1,2,3” and 3 hours under the second login, doing work “4,5,6”. A “fixed calculation” would report the total worked time on 21 June as 7 hours.

I didn’t find a function in the Dundas functions list or scripting tutorial that seem helpful.