Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Karpuz
Contributor II
Contributor II

Stacked area chart forms big downward spikes

Hi community,

I am trying to stack time series on each others. The problem is that it showes unwanted and in my opinion artificial spikes. Also, they only show up when i choose a continuous scale on the x-axis.

I would like to know how I can possibly get rid of them. I am Using Version February 2020

 

It lookes like that:

Karpuz_0-1617803667390.png

before I do the stacking, the areas look like this:

Karpuz_1-1617803702830.png

Karpuz_2-1617804071408.png

Many thanks

 

Labels (2)
2 Replies
Dalton_Ruer
Support
Support

Not sure why you are adding MONTHS to some for comparison and YEARS to others for comparison but that could be why some products tail off so much faster than others. 

Copy the table and then drag a Simple Table over it and say "Convert to" so that you can check the actual values to see if they are real or not. 

Continuous scale is good for showing data over time so that end user doesn't miss periods where the data source might be missing a chunk of values. 

Karpuz
Contributor II
Contributor II
Author

Thanks for your suggestion @Dalton_Ruer .
I found out that the graph is not correct. As soon as I zoom in, or remove the Product, the graph looks normal.
I downloaded the table data and tried it in a new app, but the spikes appear again. 

Maybe it is because of the version. (February 2020) I had a similar graph earlier and after we upgraded i suddenly found those spikes in my stacked area graph. If someone wants to try it, the table data is attached.

Cheers
Markus