Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Nested Output Using Averages But Averaging Totaling on List

knobsdog
8 - Asteroid

I have data in row/column format that's nested.  I need to get an Average Task Duration of each Group, Channel and Task Segment.  I've tried several different separate and join options in workflows but every single one brings them back nested but the Group level is just summing or averaging each shown value.  For example if I had Group 1 Channels 1,2,3 with Task Segments A,B,C the group level is showing 3 instead of 1 whether I pick average or sum using Summarize or Crosstab tools.

 

What I Have

GroupChannelTask SegmentAvg_Task Duration

1RedCircle3.42
1RedSquare12.03
1RedTriangle1.64
1RedRectangle1.57
1BlueCircle3.27
1BlueSquare7
1BlueTriangle2.28
1BlueRectangle2.66
1GreenCircle1
1GreenSquare1
1GreenTriangle0.01
2YellowCircle5.18
2YellowSquare13.97
2YellowTriangle3
2YellowRectangle1.86
2OrangeCircle3.43
2OrangeSquare10.89
2OrangeTriangle1.93
2OrangeRectangle3.05

 

 

WHAT I NEED:

 CircleRectangleSquareTriangleGrand Total
12.562.126.681.313.26
  Blue3.272.667.002.283.80
  Green1.000.001.000.010.67
  Red3.421.5712.031.644.67
24.312.4612.432.475.41
  Orange3.433.0510.891.934.83
  Yellow5.181.8613.973.006.00
Grand Total3.262.298.981.774.17
9 REPLIES 9
JagdeeshN
12 - Quasar
12 - Quasar

Hi @knobsdog ,

 

Please find attached a sample workflow which does the transformation you were looking for.

 

Do let me know if this works.

 

Best,

Jagdeesh Narayanan

knobsdog
8 - Asteroid

I'll take a look, thank you for your quick response.

knobsdog
8 - Asteroid

I had to adjust a couple things but your solution got me 95% there.  So thankful for your help, I really appreciate it.

JagdeeshN
12 - Quasar
12 - Quasar

@knobsdog 

 

Awesome!. Glad I could help.

knobsdog
8 - Asteroid


Thanks again.

JagdeeshN
12 - Quasar
12 - Quasar

@knobsdog 

 

Please check if the solution in the below thread helps your usecase:-

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Bolding-specific-text/td-p/334281

 

Best,

Jagdeesh Narayanan

knobsdog
8 - Asteroid

I spoke too soon.  I figured out how to write a formula in the Basic Table tool that will bold and increase the font size based on the text in the column.

 

Thank you again for your help.

JagdeeshN
12 - Quasar
12 - Quasar

@knobsdog 

 

Awesome.  Can you share a sample formula here if you don't mind?.

 

I ask as that can be helpful to others.

 

Best,

Jagdeesh Narayanan

knobsdog
8 - Asteroid

Good idea here's the steps:

 

In the Basic Table Tool:

Under Per Column Configuration Section at the bottom

 

1. Select field you want to adjust the font,
2. Click Column Rules > Create
3. Check Formula button
4. Click 3 dot menu and type formula: [_CurrentField_] IN ("1","2"..."n")
5. Below Formula box check Font box and pick bold, italic, font, etc
6. Check Font Size and pick font size
7. Click Close button

Labels