Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a graph which shows the % of productivity of team members and individual members for a particular month.
In the chart my dimension is month.
Expressions :
1 ) Productivity :
((Subfield(Interval(ProductionTime,'hh:mm:ss'),':',1)*60*60+
Subfield(Interval(ProductionTime,'hh:mm:ss'),':',2)*60+
Subfield(Interval(ProductionTime,'hh:mm:ss'),':',3))/(60*60))*100/(PresentDays*8)
2) Attendance :
(PresentDays*100 )/ ( [Working Days])
The graph is showing values correctly when I click on individual name, but when I click on team name it is not showing the data in chart.
Table Structure :
Table 1 : Team , IndividualName , Month
Table 2 : IndividualName, IndMonth, ProductionTime, PresentDays
I would like to get the sum of data related to each team for that month when I click on Team.
Got the solution. Just providing Sum(...) will be enough.