Hi I want to create a report regarding to proportion and time.
There are a field which aggregates the time people spend and fill out.
I want to know which department spends how much time with this field.
Also, there is a limitation as for this field.
So, I need to subtract this. (I'm thinking of using the 'Configure' part, but need to return the percentage.)
For example, there is a custom field, Time Spend (u_time_spend), which is integer type.
There are 5 groups using this field. (I call them Group A, B, C, D, E for the convenience)
The total limitation of Time Spend is 100.
In this situation, I want to extract reports like following:
I can create the report by using with SUM aggregation, but cannot do the next, the REST thing.
Please help me out.
Thank you.
