I want to do a unique count per fieldA(serialNumber) by FieldB(CommandID) and sum this total per fieldC(farmID).
Which I can do in Kibana, but then I want to be able to collapse the rows to just show the FieldC(farmID) value.
the below picture might illustrate it better.
I have got the value in kibana(using visualisations) as the pic shows.
Any idea how to collapse the rows?
Or How would I be able to plt this value 92, over time at a per farm level in kibana or grafana
grafana pic(noter value is 93 it should be 92)
posted here also as is a kibana/grafana related topic.