Share
Report
349I have about seven collections which I'd like to roll up to get a status count.
This works great:
AddColumns(GroupBy(Collection1, "ActiveStatus", "ByActiveStatus"),"Reference","Collection1","StatusCount",Sum(ByActiveStatus,Value(1)))
But i would like to do a union of that collection plus the other seven collections without having to patch to another collection, and display the results in a gallery.
AddColumns(GroupBy(Collection2, "ActiveStatus", "ByActiveStatus"),"Reference","Collection2","StatusCount",Sum(ByActiveStatus,Value(1)))
AddColumns(GroupBy(Collection3, "ActiveStatus", "ByActiveStatus"),"Reference","Collection3","StatusCount",Sum(ByActiveStatus,Value(1)))
In SQL it would be something like
Select A, Count(*)
Union
Select B, Count(*),
Union
Select C, Count(*)
All responses (
Answers (
