We re Sorry Data Studio Is Not Available Right Now Please Try Again Later

‍Introduction

Accept you e'er wanted to add a warning text or a simple traffic light signal to your KPI reports in Data Studio, where Revenue, Conversion Rates, etc. are above or below the target?

What most adding a dark-green checkmark at the meridian-right corner of the dashboard if everything is within the expected range?

Something similar this:

Notice that in the above example, the signals change equally revenue decreases below $5k.

If you've ever tried to output a cord of text, or god forbid an emoji, based on a numerical comparison such every bit the scenarios listed to a higher place, you know that it'southward almost impossible to attain using the standard features of Google Data Studio.

Performing the same, based on operations on text values is possible with a simple Case office such as:

Instance

WHEN Country IN ("Us","CANADA") Then "N America"

WHEN State IN ("Germany","French republic") And so "Europe"

ELSE "Others"

Terminate

But it is not possible when using logical operations on metrics, for example, the CASE function below will result in an error:

Basically, if the logical performance subsequently the WHEN clause is done on a number, then the returned value of the THEN clause should exist numeric too, same with strings.

On the other hand, the current provisional formatting characteristic in Data Studio is limited to the font and background color of scorecards and tables only.

In this article, I'm going to introduce a community component that we've recently released, which allows y'all to show different pieces of content based on numerical ranges or fifty-fifty evidence or hide the component based on different metric ranges.

Use Instance Examples

Being able to render a string value based on a unproblematic numeric operation can be very useful, helping you better communicate insight with the audience of your reports.

Some examples of means this feature can be used to improve reports are:

Adding automatic insights to the reports based on expected performance

Check confronting a metric and output different content in a text box based on whether the metric meets or exceeds target or performs worse than expected.

Drawing attending to specific KPIs using a traffic light signal

Show an amber, a green, or a cerise icon if a metric falls within specific ranges

Irresolute chart titles based on different criteria

Add together a dynamic nautical chart title that changes according to the values of the metric represented in the chart.

Utilise visuals to show operation against goals/targets.

Apply visual signals like X or Checkmark, thumbs up/down, happy neutral sad face to bespeak the performance of a metric confronting a target.

Quickly drawing viewers' attention to the areas of the report which require activeness.

Add optional elements such as text or icons to the report which are hidden by default and are only shown once a metric meets some criteria

Installation & configuration of the component

To install and use the Conditional Content community component, you first need to add information technology to your report through Community Visualizations bill of fare:

To practise that, outset, click on Community Visualizations Icon and then click +Explore More.

Choose the first option "Build Your Own Visualization"

Enter the component's Manifest Path and click Submit

Click Conditional Content by Siavak.com to add together it to your written report.

Then place the component on the report canvas and head over to the Style tab to add the content and configure the component. Here you lot can:

Choose the default content to be displayed when the metric doesn't fall within any of the ranges. You tin choose the font and add together inline CSS to style your text just like you would configure the Google Fonts component.

Add a information source and a metric to be used for the criteria divers in the adjacent stride.

Define up to five numeric ranges based on which the component volition evidence different content by first enabling the range, then entering the minimum and maximum values for the metrics range, and finally inbound the content to exist displayed alongside its color.

Special characters are supported in the content field (e.g., ●, ■, ♥, ▲, ▼, etc.). To become a list of these, on windows click start, type charmap, and hit enter. On a Mac, information technology should be accessible past pressing Command+Selection+T.

Emojis are supported too and can be re-create & pasted from an emoji website like getemoji.com

Plus, you tin can add together {{metric}} wherever in the content to be dynamically replaced with the actual value of the metric. E.k., "Revenue was {{metric}} last week, which is peachy news!"

Some notes:

Ranges: The numerical ranges are inclusive of the minimum number and exclusive of the max, so setting information technology to 100 to 200 will match 100 to 199.9999 simply not 200.

Hiding the Component: You can go out the content blank for any of the ranges to hide the component. It actually becomes transparent, so it still masks the interaction with the charts below it if there's an overlap.

Range Overlaps: Ranges can overlap, although information technology's not recommended. When they practice, the highest range gets the highest priority in case of conflicting values. For example, the 5th range gets priority over the 1st range.

Community Visualization Admission: For the component to work, the Community Visualization admission at the information source level should be turned on. To practice that, simply click to edit the data source and plough on Community Visualization Admission:

Can you call back of other use cases for this component or ideas to improve it past calculation new features? Let me know below in the comments section!

olivarespaingst.blogspot.com

Source: https://blog.siavak.com/posts/conditional-content-component-google-data-studio