Hi Mark
Thanks for pointing me in the direction of where clauses inside a count. I
found this which is working.
select count(case when queuedCountProcent > 50 then 1 else null end) as
count_queuedCountProcent,
count(case when queuedBytesProcent > 50 then 1 else null end) as
count_queuedB
Hi Mark
Many thanks for you replay. I have never used a "where" clauses inside a
count in a select statement so I tried it. But it doesn't work all 4 fields
has the same value which is equal to the total amount of records.
if it had worked it would have been very very nice.
Thanks
Jens M. Kofoed
Jens,
I think you should be able to use a query like:
SELECT
COUNT( (queuedBytes*100/backPressureBytesThreshold) > 60) AS
overSixtyPercentBytes,
COUNT( (queuedCount*100/backPressureObjectThreshold) > 60) AS
overSixtyPercentObjects,
COUNT( (queuedBytes*100/backPressureBytesThreshold) > 75) AS
Hi
I'm using the SiteToSiteStatusReportingTask to monitor NIFI flows and I
would like to calculate how many connections has BackPressure Enabled and a
bunch more calculations. The end results of all the statistics has to be in
one final flowfile so a final result can be sent to another system.
Fi