creating weighted totals
Below is an excerpt from my data. I'm trying to do weighted averages on data by date. So if we have 1 job that runs at 50% of it's goal for 2 hours and another job that runs at 100% of it's goal for 6 hours then I get a overall of 87.5%.
I can see this happening several ways but I'm unsure how or if possible to do it in yellowfin.