Hi everyone hope you are all well,
I am trying to create a query from the below data which will count the unique error name + trade id , to do the count I want to only consider the error name and id fields ( this will define unique ). can this be done?data is below
tier error name Name report date File no Group name location ID
1 Error 1 Database error 15-Nov 1 Group 5 main 1
1 Error 1 Database error 15-Nov 1 Group 4 main 1
1 Error 1 Database error 15-Nov 1 Group 1 Local 1
1 Error 1 Database error 15-Nov 1 Group 3 main 1
1 Error 2 Database error 15-Nov 1 Group 1 Local 1
1 Error 2 Database error 15-Nov 1 Group 3 main 1
1 Error 2 Database error 15-Nov 1 Group 5 main 1
1 Error 3 Database error 15-Nov 1 Group 2 Local 1
1 Error 3 Database error 15-Nov 1 Group 1 Local 2
1 Error 3 Database error 15-Nov 1 Group 5 main 2
1 Error 4 Database error 15-Nov 1 Group 5 main 2
1 Error 4 Database error 15-Nov 1 Group 2 Local 2
1 Error 4 Database error 15-Nov 1 Group 1 Local 2
1 Error 5 Database error 15-Nov 1 Group 4 main 2
1 Error 5 Database error 15-Nov 1 Group 3 main 2
1 Error 6 Database error 15-Nov 1 Group 1 Local 2
1 Error 6 Database error 15-Nov 1 Group 3 main 2
The query i am trying to create should bring back the below
I have color codes what should be group, the total count should be 7, can this be done?
thank you for any help