Creating Average w/ StdDev Follow-Up Outcome

[Faronnj]

Good Afternoon Alteryx Community,

I have a question about what would be the easiest way to go about creating the following graph:

In Excel, this is what the data looks like prior to making the above graph:

	Pre	Post-3	12	24	36	60	>60
Avg	-14.07	-0.05	-0.17	0.05	-0.26	-0.33	-0.66
StdDev	3.456953	1.101568	0.970037	0.890037	1.10358	1.159852	1.345491
Avg + StdDev	-10.62	1.06	0.80	0.94	0.84	0.83	0.69
Avg - StdDev	-17.53	-1.15	-1.14	-0.84	-1.37	-1.49	-2.00

For my excel graphs, I usually had to create a line for the average then do a (Avg+StdDev) and (Avg-StdDev) functions for the 2 stddev lines.  Is this what I am looking to do with alteryx or is there a simpler method.

CURRENTLY, my workspace data following a summarize and transpose looks like:

Name	Value
Avg_Preop Sph	-14.0739
StdDev_Preop Sph	3.919695
Avg_Postop 1-3	-7.46E-03
StdDev_Postop 1-3	1.129805
Avg_>4-12	-0.16667
StdDev_>4-12	0.980302
Avg_>12-24	4.71E-02
StdDev_>12-24	0.896557
Avg_>24-36	-0.26163
StdDev_>24-36	1.11664
Avg_>36-60	-0.33152
StdDev_>36-60	1.172668
Avg_>60-84	-0.65833
StdDev_>60-84	1.368493
Avg_>84-108	-1
StdDev_>84-108	1.74553
Avg_>108	-1
StdDev_>108	0

I would greatly appreciate if you attach a workspace using my summarize/transpose data above so I can reference it since I have to make several of these graphs using this sort of follow-up data.  In advance, thank you very much for the workspace in advance, I know it is tedious but it is greatly helpful for reference/learning.  

Nick 

[RolandSchubert · Accepted solution]

Hi @Faronnj ,

you have to split the label column (using Text To Columns tool), the next step is pivoting Avg and StdDev to columns (using Cros Tab tool). Then you can calculate the upper and lower values (Avg + / - StdDev using Formula tool) and you are done. Interactive Chart tool can be used to create the line graph.

Hope this is helpful - I attached a sample workflow.

Best,

Roland

[Faronnj]

This is exactly what I was looking for and appreciate the explanation.  I was thinking it had to be done something like that and hadn't figured how exactly the cross tab settings work.  So you helped me with that too!  Thanks again!

[Faronnj]

@RolandSchubert Another quick question related, is there anyway to make the lines in a chart dashed instead of a solid line?  I cant seem to find a way besides just using the points.  Is there a better way to display average with stddev charts on alteryx?

Thanks you again for all your help,

Nick