Set analysis

[Luffy20]

Country	Total Emission	Fuel	Fuel_Quarter	Fuel_Month
Australia	14.5101	Petrol	Q2	May
Australia	14.5101	Petrol	Q3	Sep
Australia	14.5101	Petrol	Q2	Jun
Australia	14.5101	Petrol	Q2	Apr
Australia	14.5101	Petrol	Q1	Mar
Australia	14.5101	Petrol	Q3	Aug
Australia	14.5101	Petrol	Q3	Jul
Australia	14.5101	Petrol	Q1	Jan
Australia	14.5101	Petrol	Q1	Feb
Australia	14.5101	Diesel	Q1	Jan
Australia	14.5101	Diesel	Q1	Feb
Australia	14.5101	Diesel	Q1	Mar
Australia	14.5101	Diesel	Q2	Apr
Australia	14.5101	Diesel	Q2	May
Australia	14.5101	Diesel	Q2	Jun
Australia	14.5101	Diesel	Q3	Jul
Australia	14.5101	Diesel	Q3	Aug
Australia	14.5101	Diesel	Q3	Sep
Australia	14.5101	Diesel	Q4	Oct
Australia	14.5101	Petrol	Q4	Oct
Australia	14.5101	Diesel	Q4	Nov
Australia	14.5101	Petrol	Q4	Nov
Australia	14.5101	Diesel	Q4	Dec
Australia	14.5101	Petrol	Q4	Dec

I am doing Sum(Total emission) then i am getting output of 348 which is incorrect and  it is 6 times of my correct output(i should get the output as 58.0)

Can you help me with this

[jochem_zw]

sum([Total Emission])/(Count(Distinct Fuel_Month)/count(Distinct Fuel))

?

[Luffy20]

 No it was not working ,this is giving output as 14.5 but it should give 58.5(14.5*4)

[Luffy20]

Sorry , it was working but Fuel_Quarter filter is not working for the given expression

Sum(Total_Fuel_Emission)/(count(distinct(Fuel_Month))/count(distinct(Fuel)))

[jochem_zw · Accepted solution]

with selection on Quarter

no selection