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

Negative Value Time Series

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a graph I've made tracking data that goes below 0. I'm trying to show this in a time series report but instead of showing the below 0's it just flat lines at 0 and we lose all benefit of the visualization. Is there a way to fix this? I tried ot make the y axis go below 0 yet it still did nothing. 

Negative Value Time Series

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I'm not sure, but I'm curious about the answer.

Negative Value Time Series

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I'm hoping someone will give me some insight sooner rather than later. We're doing some POC's with different report writers. Looking into Redash, Looker, Data Studio and a few others. I'd be surprised if there isn't a way to do this, but I guess we'll wait to see if someone comes up with a solution. 

Negative Value Time Series

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi, i have the same issue, my timeserie is only showing positive values, did you come up with some kind of solution?

Negative Value Time Series

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Actually i found the answer here:

https://www.en.advertisercommunity.com/t5/Data-Studio/Negative-values-on-scatter-chart/td-p/827792

 

Select the diagram i Edit mode. Pick "Style". Almost at the bottom. Look at the header "Left Y-axel". Erase the zero value from "Axel Min".

Negative Value Time Series

Explorer ✭ ✭ ☆
# 6
Explorer ✭ ✭ ☆

Thanks! Work's perfectly Smiley Happy