I am new to the ELK stack and trying to learn how to visualize some things. I have data coming in from one of our machine tools and I would like to make a simple counter that show the amount of time the machine has been running for a given time period my document looks like this.
@timestamp Nov 30, 2020 @ 18:51:11.217
timestamp Nov 30, 2020 @ 18:48:56.714
I know I can get a COUNT of the p1CuttingTime but how do I get the value of the Samples.AccumulatedTime.@@data that goes along with p1CuttingTime? Any help would be appreciated as well as pointers to any tutorials on working with Visualizations
As I understood you want to sum up
Samples.AccumulatedTime.@@data from your documents?
Then you should use sum aggregation for this.
For example, using Lens:
Samples.AccumulatedTime.@@data field into editor
- Pick "metric" chart type
- Pick a "sum" function
Thanks for the direction it has helped. However
Samples.AccumulatedTime.@@data holds other data as well for other values. So just displaying the SUM of it doesn't give me what I want. I need to display the SUM of
Samples.AccumulatedTime.name p1CuttingTime. Not sure how to do that.
@fastxl, can you sum up all
Samples.AccumulatedTime.@@data and then use Kibana's filter to include only documents with
I am talking about this filter bar:
Yes! That worked. I didn't realize that the filters would stay with the visualization. Thank you for the direction.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.