How do I create Custom View that will display summary of data for each month?

Topic Labels: Scripting extentions
723 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, I’m looking to create a custom view from a table that will display a summary of data for each month.

Firstly, I want to select only rows from Table A where the Table B field has the value “Example Value”.

Then, I want to calculate certain sums based on subsets of the “Example Value” rows:

I want to calculate a “i.e Staff Hours” value for the given month, which is the sum of “hours” multiplied by 8 multiplied by the number of business days in that month.

I also want a “i.e Work Hours” field, which is found by taking the sum of hours for rows whose “i.e Work Status” field is not “i.e Full-Time Employee”.

I also want a “i.e Senior Staff Hours” field, which is calculated by summing hours for “Table A” where the “i.e Proficiency Level” of Table B is 4, then multiplying by 8, and then multiplying by the number of business days in that month.

Is there a way to do a custom view instead of making a script?

0 Replies 0