It's also useful to recreate custom grouping channels in Data Studio. Using the "CASE WHEN" and "REGEXP_MATCH" functions as well as the "AND", "OR", "NOT" operators, you can pretty much do anything :)
5 лет назад+1
Very useful! I have a question: I see that the "Avg. Order Value" metric values are added after the grouping. Is there a way to average them instead? Thanks!
HI! I want to do what you did in this vid for a range of numbers. Meaning group my data via the Domain Authority range of: 0-9, 10-19, 20-29, 30-39 etc.. up to 100. Based on this example.. my formula would be rather long. Then again, is there is a solution for this? Thanks, I'll keep at it meanwhile
How to set the default content of table is based on user input?.meaning the table is empty before the input control is fill and other user cannot see the detail until the input is match
I did a Case When for items in a Category but when I run the report I get a No Data Message in the score card. I just want to add up certain Category Items like you did for Days of the week and put them under a group but I also need the values to bee added up. I get a No Data message, what should I try?
You have placed fixed values for week names in your calculated field, but that data is based on the end user's Google account set language. So if I were to share this with a Norwegian client, he would have had 'Mandag' instead of 'Monday' because he had his Google Account language set to Norwegian. Does that mean I have to do a whole table of every possible language combination for all 7 days of the week?
Great tutorial! I was trying to find drop off rate between two filter (or segment ) data (certain urls). But i couldn’t firgure out how? Do you guys have any suggestionsz for me? Thanks!
Very useful tutorial! How do we calculate the 10 top increasing average positions and top 10 decreasing positions through search console data in Data Studio?
I'm very glad to have learned MySQL because most of it is compatible with calculated fields. Where I struggle is to create a median value (ex: median order value) Any tips on how to do it? Thanks for sharing
Help!!! I an trying to show growth of sales achievement year to year. My data is as China Sale Year 2018 = 20,123 China Sale Year 2019 = 22,345 Russia Sale Year 2018= 1500 Russia sale year 2019= 1670 Now i need to show the growth in percentage % , How i can do this calculation in Google Data Studio Matrics ?
How to use CASE statement when I need to do this. WHEN Avg(Field X) < 500 THEN "Low" WHEN Avg(Field X) < 1000 THEN "Medium" WHEN Avg(Field X) >= 1000 THEN "High" I used another calculated field for AVG(X) and used that field here, but it is preventing me to use text as a result saying "Only numeric literals are allowed if aggregated fields are used in CASE"
One that drives me crazy is the sort of misuse of calculated field....you have calculated dimensions and calculated facts or metrics. I think that differentiation would help a lot of new comers to distinguish between dealing with text formulas and arithmetic
That's because they did it incorrectly. You likely followed their instructions perfectly, but the way they did it will give you inaccurate data every time.
THANK YOU SO MUCH I'VE BEEN SEARCHING A TUTORIAL FOR THIS LIKE CRAZY THANK U THANK U THANK U
It's also useful to recreate custom grouping channels in Data Studio.
Using the "CASE WHEN" and "REGEXP_MATCH" functions as well as the "AND", "OR", "NOT" operators, you can pretty much do anything :)
Very useful! I have a question: I see that the "Avg. Order Value" metric values are added after the grouping. Is there a way to average them instead? Thanks!
Excellent!!!!
:)
HI! I want to do what you did in this vid for a range of numbers. Meaning group my data via the Domain Authority range of: 0-9, 10-19, 20-29, 30-39 etc.. up to 100. Based on this example.. my formula would be rather long. Then again, is there is a solution for this? Thanks, I'll keep at it meanwhile
Fentastic. it helped me a lot.
How to set the default content of table is based on user input?.meaning the table is empty before the input control is fill and other user cannot see the detail until the input is match
I did a Case When for items in a Category but when I run the report I get a No Data Message in the score card. I just want to add up certain Category Items like you did for Days of the week and put them under a group but I also need the values to bee added up. I get a No Data message, what should I try?
You have placed fixed values for week names in your calculated field, but that data is based on the end user's Google account set language. So if I were to share this with a Norwegian client, he would have had 'Mandag' instead of 'Monday' because he had his Google Account language set to Norwegian. Does that mean I have to do a whole table of every possible language combination for all 7 days of the week?
unfortunately yes.
there is a workaround this, just add weekday function and do the case function on the week day number like sunday is 1 and monday is 2
Good one
Great tutorial! I was trying to find drop off rate between two filter (or segment ) data (certain urls). But i couldn’t firgure out how? Do you guys have any suggestionsz for me? Thanks!
Very useful tutorial! How do we calculate the 10 top increasing average positions and top 10 decreasing positions through search console data in Data Studio?
I'm very glad to have learned MySQL because most of it is compatible with calculated fields. Where I struggle is to create a median value (ex: median order value) Any tips on how to do it? Thanks for sharing
Awesomeness
Can you use Case when Like? Like you can in SQL/Bigquery?
Help!!! I an trying to show growth of sales achievement year to year. My data is as
China Sale Year 2018 = 20,123
China Sale Year 2019 = 22,345
Russia Sale Year 2018= 1500
Russia sale year 2019= 1670
Now i need to show the growth in percentage % ,
How i can do this calculation in Google Data Studio Matrics ?
no need to post twice
Is it possible to use control like a dropdown im CASE?
no, not right now
How to use CASE statement when I need to do this.
WHEN Avg(Field X) < 500 THEN "Low"
WHEN Avg(Field X) < 1000 THEN "Medium"
WHEN Avg(Field X) >= 1000 THEN "High"
I used another calculated field for AVG(X) and used that field here, but it is preventing me to use text as a result saying "Only numeric literals are allowed if aggregated fields are used in CASE"
same problem! WHEN a VALUE is LOWER THAN > then "Low"
no answer at all yet? thanks buddy!
One that drives me crazy is the sort of misuse of calculated field....you have calculated dimensions and calculated facts or metrics. I think that differentiation would help a lot of new comers to distinguish between dealing with text formulas and arithmetic
Would this work?
CASE
WHEN Day of Week Name IN("Saturday","Sunday") THEN "Weekend"
ELSE "Weekday"
END
Really nice tutorial but when we converted tables to two rows the values got added rather than taking average of days
That's because they did it incorrectly. You likely followed their instructions perfectly, but the way they did it will give you inaccurate data every time.
ahmad volume is waaay toooo looooooooow
thanks for letting us know... will work on that next time
Thanks for the feedback Mohamed, I'll make sure to fix it next time.
This is like SQL