Sum of Product Revenue and quantity not the same in Looker Studio

Reports and working with data
8

Hi Jeff, I dont know if you have already fixed the issue. But here is the solution to everyone else having the revenue issue.

  1. Create the overview field in Looker like you always would.
    image
    You will notice a revenue gap between Looker and Piwik interface

  2. Change it to table
    image

  3. Go to metrics, and use “Order ID” counted as second metric
    image
    You will notice the revenue is diplayed correct.

  4. Change back to overview
    image