Remote Data Mining And Management Job In Data Science And Analytics

Solve simple issue with Google Data Studio

Find more Data Mining And Management remote jobs posted recently Worldwide

Hi there!

I need help to solve a basic issue with Google Data Studio and Im not able to solve it.

This is my situation:
1. I have a form which sends the result to a Google Spreadsheet
2. In the form there is a question with multiple choices and the results appear in one cell comma-separated.
3. I prepared a second tab in the Spreadsheet with all the possible choices.
4. Im using Google Data Studio to show the results in a simple table.
5. So I blended the data from the second tab with all the options and a second data source with the actual results.
6. Now I want to see in the first column of the table all the possible choices from the second tab and in the right column the total amount it appeared in all responses from the form, including the ones with multiple answers in one cell.

As you can see in provided Screenshot I already managed to show all the possible choices in the first column, but the result of the count is not counting the cells with multiple answers.

Im trying the formula with regexp_match to count.

I would prefer not to make any changes in the spreadsheet, because the response came in automatically and I dont want to update the Sheet everytime someone fills up the form.

Who can help me?
About the recuiter
Member since Mar 14, 2020
Subarta Das
from Tunapuna/Piarco, Trinidad and Tobago

Skills & Expertise Required

Google Data Studio

Candidate shortlisted and hiredHiring open till - Sep 17, 2020

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$13.91

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

INFOR LN / BAAN support - Hourly
To edit and create show notes for a 54 minute podcast recording - Hourly
Transfer Web Hosting - Fixed
Explainer video needed based on legal article - Hourly
VueJS expert frond end dev needed - Hourly
Developer needed for creating a web and mobile application... - Fixed
Fullstack developer python/React needed - Fixed
need to do a comprehensive report on analysis a website - Fixed
Project Manager, Business Planning - Hourly
Comprehensive Marketing Strategy - Hourly
Require a supply chain expert for advise on international purchase structure - Fixed
Develop Backup Solution for Server - Fixed

Similar Projects

ArcGIS Traffic Mapping

Creating traffic layers utilising telco data with numerous filters by time, location and travel pattern. Plotting of origin and destination coordinates and transit layers.

Google Tag Manager & Analytics Expert

We are a digital marketing agency who is looking someone to provide support with tagging and analytics services for our clients. This would be ongoing and we are looking for someone to partner with for a long period to help grow this side of the busi...read more

BI/ Anayltics / Dashboard/ Zoho

We are an growing Affiliate Marketing Agency and we need a dashboard for all our clients and for us as well. The dashboard has to have some KPIs and some Filter options. Preferred platform is Zoho Analytics, if theres no other choice than google data...read more

Google data studio Expert

Hi,

We are currently working with Google data studio connected to Google sheets, but the data is getting to big, so i wanna start a fresh one.

Google data studio just needs to be copied and connected to new google sheet, so we can...read more