topic How to stack time series data when the data repeats with different units (double stack?) in Discussions

How to stack time series data when the data repeats with different units (double stack?)

BSwid — Thu, 25 Oct 2018 20:56:23 GMT

In this case sales are first expressed in units and then dollars. This is a common output format from SAP.

Starting file and left. Goal on the right.

Re: How to stack time series data when the data repeats with different units (double stack?)

GM — Thu, 25 Oct 2018 21:41:20 GMT

You should be able to use the Stack option from the Tables menu. Then, after you have selected the columns that you want to Stack into the Stack Columns Box, you will check the Multiple series stack option, which is a check box under the box where you select the columns that you want to stack. I hope this helps. MG

Re: How to stack time series data when the data repeats with different units (double stack?)

BSwid — Fri, 26 Oct 2018 14:22:45 GMT

https://www.jmp.com/support/help/14/stack-columns.shtml Thank you. The key was to choose Contiguous. It did create two columns for the months. But I can write script to remove that.