I have a Json like this:
and the Status can differ from three types: Registered, Disconnected and Dropped.
Based on this chart, I need to build a new one with the following mathematical equation: number of Registered - number of Disconnected - number of Dropped.
Could somebody please help me?
I've already tried to use the stats and eval function, but I probably did something really wrong.
Thank you in advance (:
I've already tried it. I'm using the following query:
eval License=(Registered - Disconnected - Dropped) | chart max(LicenseNum) by DateTime, License
But I keep getting as result just "Registered - Disconnected"