Hi all,
I recently started using SAC for my data-analyses/vizzes.
Currently having problems with my aggregations since i have multiple records per ID.
Example dataset:
Work-ID Profit FTE City A 2000 1 Toronto A 3000 1 Toronto B 2000 0.8 Boston B 4000 0.8 Boston C 1000 1 New yorkI need to calculate:
Total profit and total profit per ID,
A = 5000
B = 6000
C = 1000
Total = 12000
Which works fine.
However i also need to calculate:
FTE per city and FTE total:
Toronto = 1
Boston = 0.8
New york = 1
Total = 2.08
But instead i get:
Toronto = 2
Boston = 1.6
Newyork = 1
Total = 4.6
Is it possible to create a calculation specific for FTE where they return FTE value only for unique ID's?
Thanks.