-
1. Re: How to put % of Pane into Calculated Field
Deepak RaiDec 7, 2018 10:28 AM (in response to Larry Vo)
-
Percent of Pane.twbx 52.3 KB
-
-
2. Re: How to put % of Pane into Calculated Field
Jennifer VonHagel Dec 7, 2018 10:31 AM (in response to Larry Vo)Hi Larry, you can create an explicit Table calculation in which you can specify the Pane.
Create this calculation, then click "Default Table Calculation" so we can define the Window across which the denominator is summed (the pane). In Compute Using, choose Advanced:
In the view as you have it set, State is not taken into consideration, so I'll leave it out here. Set the calculation to Address Job and Person. Click Ok.
Back on the main screen, set the calculation to be "At the level" of Person and "Restarting every" Job.
Now if we put this calculation on the view - it computes correctly:
And we can use it to calculate Actual Time * Scheduled Time %:
Workbook is attached.
Best,
Jennifer
-
Percent of Pane_v10.3.twbx 32.0 KB
-
-
3. Re: How to put % of Pane into Calculated Field
Larry Vo Dec 7, 2018 2:21 PM (in response to Jennifer VonHagel)Jennifer,
This is perfect!
So I wanted to add up those newly calculated duration times and sum it up by person, would that be possible?
-
4. Re: How to put % of Pane into Calculated Field
Jennifer VonHagel Dec 7, 2018 3:13 PM (in response to Larry Vo)Hmm, I think to do that you would need to use Level of Detail (LOD) calculations rather than Table Calculations.
Check these out. Calcs with FX in the title are the new calcs and use FIXED (LOD). The old Calcs have TC in the title for Table Calculation.
All you need here is the final calculation: 3. FX ActTime * Sch %. The first two calculations are there just to show the inner results of the 3rd calc. But the first two calcs don't work well on their own - they need both Job and Person to be present in the table. The 3rd calc is ok without Job in the Table. You can remove Job from the table to get the total minutes by person. Depending on other fields in your data and the complexity of the view in which you use this calculation, the fixed calcs may need to be adjusted.
Workbook is attached.
-
Percent of Pane_v10.3.twbx 56.6 KB
-