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
