My org wants to know which countries were represented at an event. A simple way to do this is to "group by" country. Does CiviReport have a concept of grouping by a column?
Add a comment
|
3 Answers
Reports for Contributions have grouping and quite a few in the 'Extended Reports' extension (which I guess most would use) as well. The 'Report Plus' extension has grouping also. So CiviCRM certainly has the concept of grouping. In addition the new 'Search Kit' can do grouping - and many other things, it's a really significant addition to CiviCRM.
answered Oct 7, 2021 at 18:47
-
1The question mentions CiviReport, but I think Search Kit would be the best way to get a list of countries represented at an event. Oct 13, 2021 at 3:04
-
i think it is great that you are offering these examples so thought adding the screenshot would help protect the example beyond the next 'flush' (or am i wrong? will they stick around?)– petednz - fuzion ♦Oct 14, 2021 at 18:44
-
Good idea to include the screenshot, but actually it's all in the (very long!) URL so won't be flushed.– Aidan ♦Oct 14, 2021 at 20:05
-
The "group by" in your question is presumably the sql construct. CiviReport makes heavy use of sql to build it's results and has a 'group by' concept that is essentially an abstraction of that sql concept, though somewhat more flexible.
But of course, it's always more complicated than you think, so the "group by" thing in CiviReport isn't always available, it's only there when it's been setup by whoever writes the civireport "template".
If you are working with a report that doesn't have group by option already visible to you in the UI, it's probably not hard to add it. Look in the developer tab to provide the specific/template you're using for your report and you can probably get some more specific help.
