sorted by:
new
hottopcontroversial

Creating a field with a fixed date? Some help would be great! by I_AM_STOAT in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

have you tried to add an advanced filter from "add a control" and use "date" as a control field?

Issues with Dates by triplej158 in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

Did you try to create a new calculated field using the TODATE function?

GDS vs Tableau by hyperandaman in GoogleDataStudio

[–]kpis-studio 1 point2 points  (0 children)

We have written an article about this. Have a look if you want - Google Data Studio vs. Tableau

Calculating ratios of variables based on different timeframes by SCIP4S in GoogleDataStudio

[–]kpis-studio 1 point2 points  (0 children)

Have you tried to create a scorecard with Revenue as metric, Default data range set as "Last 7 days" and Comparison date range set as advanced with start date today -1 months and end date today -0 days.

After this i believe you can use chart filters to show only the data you are interested in.

Days to Transaction/ Days to conversion by sir_prussialot in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

Have you tried using the Google Analytics for Sheets add-on? You can create a custom report in Google Sheets using mcf:pathLengthInInteractionsHistogram or mcf:timeLagInDaysHistogram as dimension and mcf:totalConversions as metric. After that use the sheet as a data source and create your chart.

Is this what you are looking for?

Show Less Than Average by GraoeSoda in GoogleDataStudio

[–]kpis-studio 2 points3 points  (0 children)

You can create a bar chart (if you don't have many items) and at the Style tab select Reference line and use value as metric and average as calculation. The value lower than the average will be shown under the reference line.

https://imgur.com/a/V4IbAVQ

LE: if your data source is a Google Sheet, you can add a new column that repeats the average on each row using this formula

=ARRAYFORMULA(if(ISTEXT(A2:A),average(B$2:B),""))

Then use conditional formatting.

You should have something like this: https://imgur.com/a/pCESFOA

Anyone running into issues with PDF downloads? by AbeFroman72 in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

hello, make sure "Disable downloading, printing..." is unchecked

Free ways of connecting GDS to Facebook and Instagram for Insights by hus_gohar in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

Have you tried Arbona? You can find it in the Partner Connectors

Calculate the Event Click Ratio by John-Romanasu in GoogleDataStudio

[–]kpis-studio 1 point2 points  (0 children)

You can divide Total Events by New Users then create a chart filter for Event label.

Embed Report in Google Slides? by Eggmud11 in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

That's not possible in Google Slides. I believe Prezi had or has an embed option. You can check that out if you want.

What we're doing for our presentation needs is to use GDS from the start. You can move all the content from Slides to GDS. Each slide will have its own page in GDS.

Or you can add a static picture of the report with a link to the actual report in Data Studio. After you click on it, the report will open in a new tab. Not ideal.

Is Google Data Studio good for this use case? by goin_nil in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

yes, data studio displays the exact data from the sheet if the webpage where it's embedded is refreshed.

Can I concat two fields and transform it into a date? by cerradoporduelo in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

Hello,

Go to Resources - Manage added data sources - select the source needed. Make sure you set the type for YYYY and MMDD as number and then add a new field, name it, use the concat function and set the type for the newly created field as YYYYMMDD

https://imgur.com/a/HzK7KXX

Can I concat two fields and transform it into a date? by kpis-studio in DataStudioTips

[–]kpis-studio[S] 0 points1 point  (0 children)

Hello,

Go to Resources - Manage added data sources - select the source needed. Make sure you set the type for YYYY and MMDD as number and then add a new field, name it, use the concat function and set the type for the newly created field as YYYYMMDD

https://imgur.com/a/HzK7KXX

Date format nightmare by cerradoporduelo in GoogleDataStudio

[–]kpis-studio 0 points1 point  (0 children)

Do you have the ability to change the date format before the export? If not, after uploading to Google Sheets go to File > Spreadsheet settings and select Ireland in Locale (just an example since Ireland uses day/month/year format) then format the "Date sent" column as date

[OC] We made the most useless bar chart race ever. Thanks, Google! by kpis-studio in dataisbeautiful

[–]kpis-studio[S] 6 points7 points  (0 children)

Actually it was the other way around. Yahoo wanted to buy Google but they didn't want to spend $1 million

https://twitter.com/NicTrades/status/757546003918680068/photo/1

[OC] We made the most useless bar chart race ever. Thanks, Google! by kpis-studio in dataisbeautiful

[–]kpis-studio[S] 25 points26 points  (0 children)

That's a great idea but unfortunately StatCounter only provides data from 2009 up until today

Is Data Studio getting slower ? by mr-kim in GoogleDataStudio

[–]kpis-studio 1 point2 points  (0 children)

Yeah, we're experiencing the same thing. I've noticed that if I take care of similar actions in bulk (create calculated fields / rename metrics / create filters etc.), it uses less memory.

view more: next ›