Hours repeated at the end of the month

[gleybson_calyx]

Hi everyone, I need a set analysis that returns me what is in bold in this table below.
I'm creating a 3 KPI's and I need to display this information.
1st KPI has that returns me that throughout the month the value of 7h was repeated 8 times

data	valor	hora
02/01/2019	16	15h		7h 8x
03/01/2019	13	17h		8h 5x
04/01/2019	14	14h		9h 4x
05/01/2019	13	7h 8h 10h
07/01/2019	13	9h 11h 13h 17h
08/01/2019	14	13h
09/01/2019	13	7h 18h
10/01/2019	13	14h
11/01/2019	17	12h
12/01/2019	17	9h
14/01/2019	13	7h 18h 19h
15/01/2019	14	7h 9h
16/01/2019	13	7h 10h
17/01/2019	14	7h
18/01/2019	14	8h
19/01/2019	14	8h
21/01/2019	13	8h
22/01/2019	15	10h
23/01/2019	11	7h 8h 9h
24/01/2019	14	7h
25/01/2019	15	16h 17h
26/01/2019	17	10h
28/01/2019	15	7h
29/01/2019	13	7h 9h
30/01/2019	13	17h
31/01/2019	11	8h 10h 11h 13h

[rwunderlich]

I'm not clear on your logic. I count "7h" as appearing 10 times?

-Rob

[gleybson_calyx]

Pedon, that's right, 10 times

[dwforest]

if you just need the 3, quick way without changing the source data (which would make counting any hour easier - see SubField function), use FindOneOf:
Sum(if(FindOneOf('7h', hora)>0,1,0))

[Alessandra · Accepted solution]

Gleyson follow the solution. To solve this problem I always working in parts, I think is more easy.

count(

Aggr(

if(

max(Total <Dia>{<[Tipo Operação] = {'Carga'}>}

aggr(

count({<[Tipo Operação] = {'Carga'}

         >}distinct Placa), HoraEntrada, Dia)) = max({<[Tipo Operação] = {'Carga'}>}

  aggr(

                        count({<[Tipo Operação] = {'Carga'}

                               >}distinct Placa), HoraEntrada, Dia)), HoraEntrada),Dia, HoraEntrada))