How to create agregated stat

Hi


We use coupon codes on our website, and wometimes people do not spell them right. For instance, the code "Welcome" is spelled : welcome or WELCOME, or Welcome,,...

What I would like to do is to create one new stat that regroups several items. For example, create a new stat called "Welcome" that gives me all the used coupons associated, only in 1 line in my tab

WELCOME = 45

Welcome = 10

welcome = 5


I would have a new tab with only one line:

Welcome = 60


How can I do so ?

  • i think you shall create a regexp dimension in the google data studio that will convert all of those words into upper . the name of the funciton was UPPER(), so whatever you get will become WELCOME 


    1 person likes this
  • Hi,


    Thanks for the answer.

    Question: what is a regexp and how do I create that ? :-)

Login or Signup to post a comment