How to aggregate calculated ratios?
I have some transit data that I want to analyze. At the view level I have data for each vehicle/day with the passengers transported that day and the amount of service time. I create a calculated field to compute passengers per hour (passengers/time), which works correctly, but I don't know how to aggregate that metric at the report level.
If I aggregate data for a single vehicle across multiple days I want to use SUM(passengers)/SUM(Time) to see the performance of that vehicle for that date range, but the only thing I can figure out how to do is sum the calculated field which works out to SUM(passengers/time) which is not correct.
How do you configure this kind of aggregation in Yellowfin?