Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

can we have a metric that return null not zero

Explorer ✭ ✭ ☆
# 1
Explorer ✭ ✭ ☆

is there any way in DS to return null instead of 0, in my particular case it make a big difference, as i want to draw a line based on a metric, and it is important not to show 0 value.

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Mimoune D
July

can we have a metric that return null not zero

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You can create calculate metric defined as Metric * Metric / Metric. Data Studio treats NaNs as Nulls, and division by 0 works here

View solution in original post

can we have a metric that return null not zero

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Same thought. I have time series graph which have nulls in the data nut Studio is interpreting null as 0, so the "break in data" function doesn't work.

Marked as Best Answer.
Solution
Accepted by topic author Mimoune D
July

can we have a metric that return null not zero

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You can create calculate metric defined as Metric * Metric / Metric. Data Studio treats NaNs as Nulls, and division by 0 works here

can we have a metric that return null not zero

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

very clever workaround !! thanks