List unique values and their occurrences side by side

1

hi

trying to make a system where i can count how many ‘models’ of equipment i have.

i have managed to get a list of unique values but struggling to have it show me how many times each of those values occur.

image
image668×939 22.2 KB

you can see commented out some of the things i tried but those only ended up giving me all the same number and no text.

any help would be greatly appreciated.

thank you

1 Like
2

Almost there!

[Inventory Master].Model.Unique().forEach(
  currentValue.let(
    currentModel,
    format(
      "{1}: {2}",
      currentModel,
      [Inventory Master].filter(Model=currentModel).count()
    )
  )
).BulletedList()
4 Likes
3

worked perfect!

thank you so much.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.