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

Merging two summarized outputs in a nested fashion.

knobsdog
8 - Asteroid

I have a list of data broken down by group and it's sub-channel which I've made generic with numbers for this purpose.  Each group and channel has it's time # in duration and I have created two workflows that show median duration for each group and each channel.  I need to bring them back together to show the group median and it's sub-channels with their median durations numbers under it.

 

Any idea how I can make it look like this?

 

GroupMedian Total Duration
CTO33.24
1933.24
FCPS43.80
536.99
744.10
955.78
1347.81
1742.35
2042.87
FCPS-S35.91
436.84
1035.11
MSO34.06
234.82
632.88
1634.06
1834.88
Other27.59
335.91
1127.59
S&L24.90
128.06
829.03
1515.89
ShSr41.10
1220.83
1442.59
4 REPLIES 4
Ladarthure
14 - Magnetar
14 - Magnetar

Hi @knobsdog,

 

I did a sample workflow, to achieve whatt you want, I used a multi row formula to be able to sort and created an order field and then unioned my data.

 

hope it helped!

knobsdog
8 - Asteroid

That does work however is there a way to bold the group name and total so it stands out and doesn't get mixed in with the channel names and totals?

Ladarthure
14 - Magnetar
14 - Magnetar

This would be about using the reporting tools, where you can set rules per row, you can look at the report table tools which allow plenty of customization depending on your needs. You can then export to excel or event pdf with a render tool!

knobsdog
8 - Asteroid

Makes sense, I'll explore that avenue.

Labels