I have problem.
I have a table of log times per user. the user is connect to a branch.
for every branch i calulated the distinct values of days that the users loged in divided by the number of working days in a month with gives me a number of usage for each branch. The grandTotal of the pivot table by avarge will give me the avarage of usage for all branch.
how can I calculate in one indicator the grandtotal in one function.
branch logon days num of working days usage
AAA 10 25 0.4
BBB 5 25 0.2
CCC 20 25 0.8
avarage caculation is (0.4+0.8+0.2)/3 = 0.466
The problem is that the function SUM(count([days in logtime])) does not work.
Would love for some assistance.
Please sign in to leave a comment.