group results

  • 1
  • Question
  • Updated 3 years ago
  • Answered
If I have a 1000 items and most are the same. How do I only show 1 unique line item.  So, instead of 1000 items it will show 23 unique lines?

https://drive.google.com/file/d/0B409lhd9sYDcZm91Qnhka2RnZmM/view
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
You need to make an aggregate model. 

Check out this tutorial:  http://help.skuidify.com/m/models-conditions-filters/l/102652-aggregate-models-make-dynamic-reports-...

You will not be able to group on your concatenated formula field - but you will be able to group by zip code. 

All fields you want to show on your table will have to be in the grouping section.  

Finally:  If all your fields on the table are on the parent (and grandparent) objects,  why not make your model on the parent objects?