Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I'm not clear on your logic. I count "7h" as appearing 10 times?
-Rob
Pedon, that's right, 10 times