'How can I make single control field to control multiple columns in Google Data Studio?

I like to make a single control field, such as dropdown-list, to control multiple columns with the same value. As the sample link(1) below in Google Sheet. My raw data, consist of the type of anesthesia, the name of the nurse during surgery.

This sheet "RR" consist of raw data, then I make a new table using some functions, to look like sheet "LogBook".

If I choose name of the nurse for example "Wayan", then it will count each part of surgery and type of anesthesia that Wayan had been involved, and it will count the type of surgery also.

When I use Google Data Studio, I can only make single control field for example "Nurse in pre surgery", "Nurse in intra surgery", or "Nurse in post surgery". Or if I select all of the control fields, then it become "AND", that's not what I want. I want to make a single control like "Name of the nurse", then google data studio, will show like the one in Google Sheet.

The table in Google Data Studio, show same value for all columns, which is wrong. The data in Google Sheets is the right one (which is using COUNTIF function).

Inputs:

Images:
This is the raw data in Google Sheet "RR":

This is how the data should be shown in Google Data Studio:

But Google Data Studio does not allow me to use 1 control field, to control multiple columns:

If I select same value in all of control fields, then it become "AND" relation, which is wrong:

controlsgoogle-data-studio


Solution 1:[1]

One approach is to CONCAT the three fields (Nurse in Pre Surgery, Nurse in Intra Surgery and Nurse in Post Surgery) to create a single new field with CSV (Comma Separated Values). The CSV Filter Control Community Visualisation (click on the 4 icon on the toolbar and select 5 to view all) can then be used to filter by nurse:

Data Tab

  • Column to filter on: 
    CONCAT(Nurse in Pre Surgery, ", ", Nurse in Intra Surgery, ", ", Nurse in Post Surgery)
  • Cross-filtering: Select (?) (selection will ensure that filtering will be applied to other charts)

Style Tab

  • OR instead of AND behaviour: Select (?) (tick so that data for multiple nurses can be viewed, when selected)

Editable Google Data Studio Report (Embedded Google Sheets Data Source) and a GIF to elaborate:

8

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Nimantha

Related Questions