I have a set of data that i would like to make some rows for the empty quarter. I had attached an example input and output for reference.
Solved! Go to Solution.
Did you try the generate rows tool?
I created a record for each value between the min/max of the 2nd column in your data. Then appended the ones that didn't already have data and set them to 0
Definitely need to leverage the GENERATE ROWS tool
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |