Average of 4 options over Time

[Bolexle]

I am trying to create an average count where I have specific date spreads.

For now I have 3 relevant columns:

1 column has 4 different string options, for example, fruits: [apples, oranges, pears, bananas]

another is a start of hour tracker for said data,

and another is a data pulled timer, where data is pulled every 5 minutes.

So for an example table, you could have:

Fruits	StartOfHour	DataPulledTime
apple	2019-06-03 10:00:00 AM	2019-06-03 10:00:00 AM
orange	2019-06-03 10:00:00 AM	2019-06-03 10:05:00 AM
orange	2019-06-03 10:00:00 AM	2019-06-03 10:10:00 AM
banana	2019-06-03 10:00:00 AM	2019-06-03 10:05:00 AM
banana	2019-06-03 10:00:00 AM	2019-06-03 10:10:00 AM
banana	2019-06-03 10:00:00 AM	2019-06-03 10:10:00 AM

What I want to make is a bar graph that shows in hourly chunks, the average number of fruits. So for this piece of data, the expected outcome for the 10am hourly chunk would be:

.083 apples (only 1 apple was eaten in 12 update cycles, meaning  you only have on average 1/12th of an apple)

.16 oranges (1 orange eaten for 2 of the 5 minute cycles, none for the rest, so the average is .16)

.25 bananas(1 banana eaten 1 cycle, 2 eaten 1, and none the rest.)

Anyone have a good idea on how to implement this?

[v-chuncz-msft · Accepted solution]

@Bolexle ,

You may just try the measure below.

Measure =
DIVIDE ( COUNTROWS ( Table1 ), 12 )