Data Studio
6.4K members online now
6.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 1
Explorer ✭ ✭ ✭

Hello everyone, I have a question regarding the presentation of report data on a dashboard - I am displaying on-site search data on a report alongside failed searches. Failed searches are identified by the prefix 'failedsearch|'. I have applied a filter to the 'top failed searches' grid which filters out only terms that have this prefix, which works fine, but I would like to know if it is possible to clean the results on the dashboard to hide/remove the 'failedsearch|' text?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ben P
November 2016

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Yep, just create a custom dimension with the formula REPLACE(column name, 'failedsearch|', '')

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Ben P
November 2016

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Yep, just create a custom dimension with the formula REPLACE(column name, 'failedsearch|', '')

 

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 3
Explorer ✭ ✭ ✭

Excellent, thank you @Ad A!