Error code count?

Hello All,

We’re in the industrial automation and we are using grafana to monitor some of the industrial machine’s
like production onfo article number error code’ machine speed and so on.

now are we logging error codes in an table view, these we send from an PLC to InfluxDB as a STRING
but we would like to “count” wich error code has been there the most times (or a top 10 or something) in an bagraph.

For examples, past 24h the machine has stopped 8 times on an emergency stop 6 times for Lunch break and 1 time on an Broken bearring (just some examples)

is there a possibility for this?

Best regards, Nick Bakker

Hi,

Yes it is possible as long as you have your time series table fit (timestamps lust be included), the use influxdb data source, the you can visualize occurence of each error on grafana.

Good Luck

I have them now like this,

but i would like to see it like this…

I have just 1 “STRING” coming in what changes at machine state…

Best regards, Nick Bakker

Hi,

Can you use csv to influxdb to have this in your table and test ?

Good Luck

Hey,

I dont understand, i have 1 field what is the First Failure. That is showed as a string, what i want is to “count” those in grafana to show a pareto at wich failure shows the most.

Best regards, Nick Bakker

Your string must be split into separate fields to do the count