title: Mark out the highest difference (%) from previous period as one KPI in Data Studio
body: <p>We've got a lot of products on our website that we track via Google Analytics and put into Data Studio for better visual.</p>
  <p>Every week can be a lot different then the previous one depending on the marketing/new releases etc.</p>
  <p>One of the requests from the marketing department was to be able to see what product has performed best/worst compared to it's own performance last week. We only want the top 1 best/worst product (that will be shown in different tables/scorecard).</p>
  <p>I feels like this is a simple task but somehow we don't manage to get it right.</p>
  <p>Example:
  This week we had a product that performed 542 % better than last week, but it's only like a 0,05% of our total revenue that week and it was only 2 sales. So the size of the sales is not important but the comparison change is, because we need to be able to catch losers/winners when we are in a fast changing industry.</p>
  <p>All the involving metrics is:
  <code>Revenue</code>, <code>Avg. Order Price</code>, <code>Transactions</code></p>
  <p>If we would do it in a custom metric field it would be like:
  <em>This period <code>Revenue</code> / Last period <code>Revenue</code></em>, but not been able to make a calculation like that.</p>
  <p>And we can't sort on the period on period change</p>
  <p>We of course want to know which product that is performing bad/good, so we need a name combined with the change %</p>
  <p>Example under, got advised to give a Google Sheets and Data Studio by moderator, <strong>we don't use Google sheets in real data visual</strong>:
  <a href="https://i.stack.imgur.com/LuO4N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LuO4N.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/UDIvN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UDIvN.png" alt="enter image description here" /></a></p>
  <p><a href="https://docs.google.com/spreadsheets/d/1ztOD_8fbnltyhmlmXj4UBPCu65GyMy-rZ-nAOnFk9Xg/edit?usp=sharing" rel="nofollow noreferrer">Link to Google Sheets</a>
  <a href="https://datastudio.google.com/reporting/8fdc8013-e516-457d-8745-ce9ae9dcd4b0" rel="nofollow noreferrer">Link to Data Studio</a></p>
  <p>In this example I would like to have Alcohol shown in a separate table/scorecard and pointing out that Alcohol has had a 100% increase in sales.</p>