Total Sum/Level of Detail in Google Data Studio
In Google Data Studio I have a small table including a dimension and a metric
| Channel | User |
|---|---|
| A | 1.000 |
| B | 2.500 |
| C | 500 |
Is there a way to calculate the total sum across the dimension (like an LOD) which is shown as an additional column next to the user? The solution should look like this
| Channel | User | Total Users |
|---|---|---|
| A | 1.000 | 4.000 |
| B | 2.500 | 4.000 |
| C | 500 | 4.000 |
Solution
It can be achieved by using a self Data Blend
1) Data Blending
Data Source 1
- Dimension:
Channel - Metric:
Users
Data Source 2
- Metric:
Users; Rename toTotal Users
2) Table
- Data Source: Blended Data Source
- Dimension:
Channel - Metric 1:
Users - Metric 2:
Total Users
Editable Google Data Studio Report and a GIF to elaborate:
- Using OFFSET to get the value from a previous row so that I can calculate the difference
- Apply pandas dictionary with gt/lt conditions as keys
- CAST AS DECIMAL returns text, why?
- R dbplyr percentages not calculated correctly from live connection to Microsoft SQL Server
- How to calculate the Exponential Moving Average (EMA) through record iterations in pandas dataframe
- Excel VBA: how to check for calculated column?
- SQL QUERY with custom columns from SUM
- How to create a new column using complex fomulas and variable outputs (i.e., recoding variables) in a Pandas DataFrame similarly to R's `case_when`?
- How to sum pandas columns across the same record for columns which begins with the same word
- Columns in another table with the same width
- Calculated column by combining 2 other columns where column A is ref column has duplicate distinct values
- I want DAX calculated column in Power BI with following requirements
- PerformanceWarning: DataFrame is highly fragmented when creating new columns
- What's the best way to calculate the weekday?
- Add a column and fill with the value calculated using values from other columns
- Using column group subtotal in calculated field formula
- SQL Issue: calculated query column won't recognize day interval in DateDiff?
- MySQL: Select and calculate values from next row
- DAX - Making a calculated column that has another table's value, based on several factors
- Can a Power BI calculated column reflect user input?
- How to subtract the means of specific columns from other preceding columns?
- DAX query: calculating incremental growth of a value by date
- CountRows in Power BI
- Dynamic calculation for columns in pandas
- Get Percentiles per group in PowerBI
- Calculating based on rows conditions (in pandas)
- Create pandas dataframe column containing list of previous values
- AVERAGEIFS/SUMIFS formula is not sorting ASC or DESC
- Create a New Column Based on the Value of two Columns in Pandas with conditionals
- How do I create a SQLite trigger to automatically calculate columns after INSERT?