![]() ![]() I read this as “give me a sum of unitWeight, holding claendarDate and username constant” and divide by “sum the hours Expression, holding calendarDate and username constant” SUM($hours Expression$,$calendarDate$,$username$) SUM($unitWeight$,$calendarDate$,$username$)/ This formula gave me daily CPH for a single employee: This explanation would be helpful for anyone else coming from the “Tableau world”:ĭundas uses commas to designate the fields to use when doing a “fixed” level of detail operation. Here’s how I understand it, with reference to how I learned it in Tableau. The new column will display which columns (A, B, C, D) has a value of greater than 0. The key was what you suggested in your reply to Rachel above. The objective is to create a new column using Tableau Prep's calculated field. I’ve got it working! Thanks for your help. However, if I back out the granularity of the table, showing only May 3rd instead of the two $timeIn$ periods on May 3rd, the reported hours are shown as an average of the two hours values during the day instead of a sum: So now I’m able to get the correct hours reporting in Dundas as long as I have $timeIn$ as an element in the display. Tableau’s fixed calculation allows me to remove the $timeIn$ field from the display and still have the hours calculation work correctly: The math works the same as as for May 2nd. On May 3rd there are two $timeIn$ periods. Using the fixed calculation gives me the correct hours worked in the day, 4.2. Simply adding the $hours$ would give 126. So for May 2nd, the $hours$ field contains the value 4.2 and is repeated across 30 rows (one row for each unit of work done, identified by $unitId$). The solution in Tableau was to do a “fixed calculation” like this. However, the hours worked appear multiple times in the data, once for each piece of work the emloyee did. ![]() The goal of the calculation is to accurately report the number of hours worked. The existing dashboard uses Tableau and does a fixed calculation to determine the hours an employee worked. I’m a new Dundas user and am working to duplicate an existing dashboard. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |