Help

Re: Combine same data in lookup field into one then list the quantity of each data

384 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Facilities_Depa
4 - Data Explorer
4 - Data Explorer

Hello,

I’m trying to see if it’s possible to list the quantity of each item from a lookup field.
Screenshot 2022-04-08 150240

For example, I’m trying to create a field that will list how many tickets per priority (I can obviously do this through a chart but I’m trying to get the data here for page designer)

and how many tickets are plumbing related.

So i’m trying to get a field that display something like this:

  • 2 Plumbings tickets
  • 1 Sealer ticket
  • 1 Other / Request
  • 1 Kitchen appliance

Same for priority:

  • 1 Urgent ticket
  • 2 high priority tickets
  • 1 medium ticket
  • 1 low ticket
1 Reply 1

You cannot do this directly in the lookup. You can create a conditional rollup for each select option that counts the number of times that particular option appears. Set the rollup condition to include only records where the select is a particular choice. Use the rollup formula COUNTALL(values)

Then you could have a different formula field that combines the values of those rollup fields.

CONCATENATE(
    "- " & {rollup for urgent} & " urgent ticket(s)\n",
    "- " & {rollup for high priority} & " high priority ticket(s)\n",
    "- " & {rollup for medium} & " medium ticket(s)\n",
    "- " & {rollup for low} & " low ticket(s)"
)