What would solve your case is to create this dummy as separate table. Create table something like that
'Average' as Factory,
30 as Rank
avg (TotalUptime) as TotalUptime
resident <your table>
Than if you use it in your table than it should look like your requirement.
Hope that hepls
Dear Mr David,
Thank you for your time! I've tested the codes given and i found it very helpful
but maybe it will need one more filtering (Date)
Let me show you if we have data for two dates
The average include for both day. Means Total uptime for rank 1,2 and 3 for both date will be divided by 6.
I need to have average per day
Do you have any idea for this problem?