Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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;
just do it in front end
take straight table
dimension > Agenda_of_Meeting
Expression > count (distinct Meeting_Number)
Regards,
Prashant Sangle
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;
You need to apply the origin field-names within the group by and not the renamed ones.
Thank you!!
The backend solution worked.