topic Re: Need a Solution on how to use multiple columns in GROUP BY clause. in App Development

Need a Solution on how to use multiple columns in GROUP BY clause.

Mohanish1 — Wed, 08 Mar 2023 08:45:01 GMT

I want to group the data by the columns "Meeting_Number" and "Agenda_of_Meeting". I want the count of unique meetings which in this case must be 9.

Expected Output :

1	testing
1	Labour
1	Holiday
1	work
1	Hiring
1	Promotion
1	Loss
1	Profit
2	testing

Data :

Meeting Number	Agenda
1	testing
1	testing
1	testing
1	testing
1	testing
1	testing
1	testing
1	testing
1	Labour
1	Labour
1	Labour
1	Labour
1	Labour
1	Labour
1	Labour
1	Labour
1	Holiday
1	Holiday
1	Holiday
1	Holiday
1	Holiday
1	Holiday
1	Holiday
1	Holiday
1	work
1	work
1	work
1	work
1	work
1	work
1	work
1	work
1	Hiring
1	Hiring
1	Hiring
1	Hiring
1	Hiring
1	Hiring
1	Hiring
1	Hiring
1	Promotion
1	Promotion
1	Promotion
1	Promotion
1	Promotion
1	Promotion
1	Promotion
1	Promotion
1	Loss
1	Loss
1	Loss
1	Loss
1	Loss
1	Loss
1	Loss
1	Loss
1	Profit
1	Profit
1	Profit
1	Profit
1	Profit
1	Profit
1	Profit
1	Profit
2	testing
2	testing
2	testing
2	testing
2	testing
2	testing
2	testing

Query Used :

Agenda_Count_For_Meeting_More_Than_120_Mins:
LOAD

"Meeting Number" as Meeting_Number,
Agenda as Agenda_of_Meeting,

"Duration in (min)" as Duration_of_Meeting
Resident Board_Meetings Where "Duration in (min)" >= 120 Group By Meeting_Number,Agenda_of_Meeting;

Error :

The following error occurred:

Aggregation expressions required by GROUP BY clause.

The error occurred here:

Agenda_Count_For_Meeting_More_Than_120_Minutes: LOAD "Date of meeting" as Date_of_Meeting, "Meeting Number" as Meeting_Number, Agenda as Agenda_of_Meeting, "Agenda Status" as Agenda_Status, "Date when Agenda was Notified" as Date_Agenda_Notified, "Duration in (min)" as Duration_of_Meeting, "Member CAT" as Meeting_Category, Attendence as Attendance_in_Meeting, Name as Name_of_Officials, PAN as PAN_of_Officials, Voting as Voting_by_Officials Resident Board_Meetings Where "Duration in (min)" >= 120 Group By Meeting_Number,Agenda_of_Meeting

Re: Need a Solution on how to use multiple columns in GROUP BY clause.

PrashantSangle — Wed, 08 Mar 2023 08:57:15 GMT

just do it in front end

take straight table

dimension > Agenda_of_Meeting

Expression > count (distinct Meeting_Number)

Regards,

Prashant Sangle

Re: Need a Solution on how to use multiple columns in GROUP BY clause.

BrunPierre — Wed, 08 Mar 2023 12:22:06 GMT

Hi,

Count({<Duration_of_Meeting= {">=120"}> } DISTINCT Meeting_Number)

But , if it has to be done in the backend, maybe like this.

Agenda_Count_For_Meeting_More_Than_120_Minutes:
LOAD Max("Date of meeting") as Date_of_Meeting,
Count(DISTINCT "Meeting Number") as Meeting_Number,
Agenda as Agenda_of_Meeting,
Only("Agenda Status") as Agenda_Status,
Only("Date when Agenda was Notified") as Date_Agenda_Notified,
Only("Duration in (min)") as Duration_of_Meeting,
Only("Member CAT") as Meeting_Category,
Only(Attendence) as Attendance_in_Meeting,
Only(Name) as Name_of_Officials,
Only(PAN) as PAN_of_Officials,
Only(Voting) as Voting_by_Officials

Resident Board_Meetings
Where "Duration in (min)" >= 120
Group By Agenda;

Re: Need a Solution on how to use multiple columns in GROUP BY clause.

marcus_sommer — Wed, 08 Mar 2023 12:05:17 GMT

You need to apply the origin field-names within the group by and not the renamed ones.

Re: Need a Solution on how to use multiple columns in GROUP BY clause.

Mohanish1 — Thu, 09 Mar 2023 12:00:00 GMT

Thank you!!

The backend solution worked.