Part Sum Part Avg Calculation problem

Q&A
,
1

Hi All,

I have a dataset as follows:

image
image694×445 10.6 KB

The requirement is to visualize this data in hourly slots and see a trend of Avg Passenger per Hour, Avg Flights Per Hour with the ability to filter for a date range, journey direction and Terminal

  1. Data on an individual date: When we look at the data for a particular date the Avg per hour should basically compute a Sum of the value for Passenger and Flight count
    image
    image

  2. However, when we select a range of dates I want the average computed as follows
    image
    image

  3. I want to project the results on a bar chart by hour. I am trouble getting this mix of Sum and Average working.

Can the experts in the community help me with some guidance?

Regards,
Giri

2

Hi
This might be helpful to you.

3

Thanks. That was helpful