Count in a certain date

[natisham]

Hello,

Im trying to count Engine hours over 40 hours by week. So I just need it to read

Header 1	Header 2
Engine Hours over 40	7
Engine Hours under 2	5

It would count Machine Names with over 40 Engine hours per week.

Currently I have :

Count({$<[Engine on (h)]={"<2"}>}[Engine on (h)])       but it is giving me the total and not counting the number of weeks it ran under 2 hours.

Please help.

[Anil_Babu_Samineni]

Better if you provide 5 rows data set and expected result set

Count({$<[Header 1] = {"=SubField([Header 1], ' ', -1) <= 2"}>} [Header 1])

[zebhashmi]

Count({$<[Engine on (h)]={"<2"}>}[Engine on (h)])

Your formula is perfectly fine use it in KPI

[sunny_talwar]

Is Header1 your field Engine on (h)?

[natisham]

Yes Engine on (h) is my header. When I use Count({$<[Engine on (h)]={"<2"}>}[Engine on (h)]) i am getting a total of the hours instead of how many times it went over 40 in a week span

[natisham]

Sorry meant under 2 instead of over 40

[sunny_talwar]

Does Engine on (h) include numeric values? Can you share a screenshot of your Engine on (h) field?

[natisham]

They are all Numeric values

[sunny_talwar]

Screenshot?

[natisham]

I have the table below (customer name has been changed):

The Numeric numbers are per weeks for Engine on (h)