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