Bar chart of Percent difference in the positive and negative direction

Hello everyone,

I'm hoping to get some help making a bar chart to display percent differences in both the positive and negative directions via LookerStudio. I'm coming from a Tableau background so I'd like to provide some data from it as a reference to see if it's possible on LookerStudio.

A copy of my data as well as a preview: Link

Test Data 1.png

I have: 1) Created the pivot table; 2) Edited my Metric - Running Calculation as Running Percentage Delta; 3) But now am unsure how to make a bar/ column chart to display it going in two directions

Test Data 2.png

As a reference; In Tableau it allows me to do the chart steps similarly but also gives me the bar chart I desire: 

  • With the % Difference calculated across then down, relative to the previous value
    • Ex. Becky: ($101 - $83) / $83 = 21.69%

Test Data 3.png

Test 4.png

 

0 0 328
0 REPLIES 0
Top Labels in this Space