Finding Lowest and Highest Average Ticket Price of the Day

[farru_scorpio]

Hello Experts,

I have attached one excel file the idea is to find our lowest and highest average ticket price of the day. Please see excel file for better understanding.

I will appreciate your quick help.

[dplr-rn · Accepted solution]

Maybe i am misunderstanding the issue. it seems straight forward.

Date as dimension and rest as expressions. see below output

DATE	Sum(FARE*COUNT)	Sum(COUNT)	Avg(FARE)	Min(FARE)	Max(FARE)
	11327	12	944	580	1,340
01/10/2019	2680	3	893	580	1,150
02/10/2019	4327	5	865	658	1,125
03/10/2019	4320	4	1,080	780	1,340

[farru_scorpio]

Thank you, appreciated. 🙂