Calculate Duration in JSON input

[scttwoods (Scott Woods)]

I have a data table of individual events with rows split by an event id. I am able to find the min and max of my timestamp field. What I want to do is have a column whose values are the difference between the max and mix times. This requires, as I understand it, aggregation in the json input. Reading through the documentation I could not find an example of applying aggregations in the JSON Input field.

I appreciate any insight you all can provide.

[LizaD (Liza Dayoub)]

Hi @scttwoods,

This appears similar to discuss post: JSON Input arithmetic
Try visualization time series TSVB using math aggregations. Also cc: @Marius_Dragomir to help further.

Thanks,
Liza

[scttwoods (Scott Woods)]

Unfortunately a time series visual builder that is suggested, is not the correct tool as far as I can see. I want to split by a time independent field to calculate duration using my timestamp field.

[LizaD (Liza Dayoub)]

Hi @scttwoods,

Okay let me also add @timroes who is more familiar and hopefully we can get you an answer.

Thanks,
Liza

[scttwoods (Scott Woods)]

Is there any update on my issue?