community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Breaking down an aggregate

Asteroid

Hello,

 

I have data like this:

 

DateMetricCount
01/01/2018View14
02/01/2018View4
03/01/2018View1


which is an aggregated count of Metric by Day. However I actually want to transform this data to show a line for each Metric. i.e. in record # 1, the Metric has a count of 14 so I want to see that row of data 14 times. 

 

Any suggestions how I could do this in Alteryx?

Highlighted
Asteroid

All you need to use is 'Generate Rows' transformation with the 'Condition Expression' set as RowCount <= [Count] as shown below -

 

Alteryx Designer x64 - forum_generate_rows_answer.png

 

You can then use select to chose only the columns you need

Labels