I am trying to build Net Revenue metric. Net Revenue = Gross Revenue - Margin*Gallons where Gross revenue and gallons are not connected in LDM directly. Can I build a table with columns Date, Gross Revenue, Gallons utilizing MAQL? So that amounts are joined together based on the date?
I could add Gallons to Gross Revenue at the data transformation step but would like to know if there is a way to construct such table w/o altering data sources.