How to create agregated stat


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 = 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 to post a comment