I am looking at my data at a Shipment level: Gross Starts, Running Paid Revenue, and Running Paid Revenue per Gross Start. However, the calculation for Running Paid Revenue Per Start is not working.
If you look at the initial shipment in the first example, you have 75 Gross Starts, a total revenue of $740.01 and a Paid Revenue Per Start of $9.87 – quick math shows that this works out. Then I look to shipment 2 and the total revenue is now $1,913.72. When you divide this by 75 – which was the intent – you get $25.52, not $26.40. So I then assumed that it was dividing by the Gross Starts from shipment 2, which is 71. When you divide $1913.72 by 71 you get $26.95, which is also not what is showing.
Can anyone help me create a calculation of running paid revenue / total gross starts?
*I have tried to create a fixed formula for Paid Revenue using the level of detail but it breaks the running paid rev/stat calculation
What you're trying to do sounds reasonable but would be much easier to answer with a packaged workbook with data that we could play with. If you have sensitive data, I would check out Anonymize your Tableau Package Data for Sharing.