chartsserieslooker-studio
Google Datastudio multiple repartitions and types chart
I'm using Google Datastudio and I'm blocked on something weird.
I want to make a chart with globally series and detailed series.
But to do that I have 2 different repartitions and I don't know how to do that.
This is a sample of my data set:
| Type | Detail | Country | Value | Date |
|---|---|---|---|---|
| type1 | uk | 60 000 | 2018-12-04 | |
| type2 | detail-1 | uk | 15 000 | 2018-12-04 |
| type2 | detail-2 | uk | 11 000 | 2018-12-04 |
| type2 | detail-3 | uk | 4 500 | 2018-12-04 |
| type1 | usa | 78 000 | 2018-12-04 | |
| type2 | detail-1 | usa | 40 000 | 2018-12-04 |
| type2 | detail-2 | usa | 17 000 | 2018-12-04 |
| type2 | detail-3 | usa | 11 5000 | 2018-12-04 |
I want a series base on "Type" and another on "Detail", then I should use filter for different countries.
How can I do that? I spent a lot of time on this simple problem, but I can't achieve this.
My data comes from SQL Cloud for MySQL
It would be something like this :
Solution
Based on your data you need to create and use a 3rd dimension
case when Detail is null then Type else Detail end
or if Detail actually = '' then
case when Detail = '' then Type else Detail end
or to be sure
case when Detail is null or Detail = '' then Type else Detail end
- Why does an empty preprocessor command still evaluate to something?
- How to implement variable sized array within C struct
- Character array typecasting to integer
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- How to get the sign, mantissa and exponent of a floating point number
- Why do MCU libraries use logic operations instead of bitfield structs?
- What kind of implementation can I use for a static associative array on a vintage system with very limited resources?
- Determine libraries to link against for a windows library function?
- Passing macro values to arm linker that places variable at a specific location
- running a program with wildcards as arguments
- How to perform addition of two vectors of 8-bit integers with a single addition in C/C++
- GNU RISC-V Embedded GCC throws "x ISA extension `xw' must be set with the versions" error
- Counting pulses using a swiss flow meter with an Arduino, how is it done?
- How to create a folder in C (need to run on both Linux and Windows)
- Is there any way to compute the width of an integer type at compile-time?
- How can I initialize all members of an array to the same value?
- Is C notably faster than C++
- How to get the Windows SDK version number a program is compiling with at compile time
- Confused by difference between expression inside if and expression outside if
- Equivalent of atoi for unsigned integers
- k&r: Exercise 1-18. Program takes input but doesnt produce any output?
- Using in C thrd_sleep() to either wait for time or interrupt by signal. Example?
- How can I compute `exp(x)/2` when `x` is large?
- c programming: answer always equates to 0
- Is it possible to access a parameter of a function from another function in C?
- Will this expression evaluate to true or false (1 or 0) in C?
- What Is the Return Value of strcspn() When Str1 Does not Contain Str2?
- Mapping a numeric range onto another
- Signalled and non-signalled state of event
- Why is faster to do a branch than a lookup?