Hello, Here is my situation- I need to plot a line graph in kibana, which will have 2 lines. First Line(say line A) will represent 10 data points, Second line(say line B) should only represent 9 data points. To be exact with my question, I'm plotting some numerical values against a release id of …

Hi @vidhyadhara , this depends on the data structure and the aggregations you are using to build that chart. I managed to get to this kind of chart using the following: These are the documents: [ { "rel" : 1, "actual" : 5, "prediction" : 6 }, { …

Thank you so much for your quick response @flash1293 ... I wonder why this isn't working for me. I'm also using MAX aggregation. May be i'm doing something wrong in pushing data from python script. I'm pushing data which is present in a excel sheet(Refer the attachment for data) using the Python scr…

Maybe panda fills in a zero automatically for the missing value. Log your data frame and the resulting JSON to see what exactly is in there and make sure its not 0. Maybe this can help: https://stackoverflow.com/questions/48956575/turn-zero-values-to-empty-cells-in-pandas

No... That value went to zero because i gave the value as zero. I think we have a misunderstanding here, I filled that cell value with zero because if i don't fill up the cell value then that release ID will not be present at all. I think i can explain better with the screenshots of what i'm tellin…

For me it looks like the problem is on the python side - I’m not familiar with pandas so I’m not sure where to look. Could you check the index in discover to see what actually gets ingested in Elasticsearch?

This is what is being pushed to the elasticsearch. Thanks for reminding me to check the discover tab. 6th release id data is not being pushed at all. Thank you for that. I really appreciate you for helping me out. Okay forget about pandas and python, I want to push/ingest data to elasticsearch fro…

If it doesn't have to happen programmatically, you can use the "File Data Visualizer" which allows upload of CSV files directly in Kibana as a way of ingesting data: https://www.elastic.co/blog/importing-csv-and-log-data-into-elasticsearch-with-file-data-visualizer Otherwise, you can piece those th…

Another thought I just had - if you are using a specified mapping for the dar21 index, could you share it here (together with the input of e.bulk)? Maybe it's passing something in here which is rejected by Elasticsearch.

@flash1293 Thank you so much for your suggestions I'l surely look into them. I don't know anything about specified mapping and stuff so i think i'm not doing anything like that :laughing: . I've shared all the files i'm using now and I'l be happy to provide what ever further info. you need.

Hello @flash1293 , I just looked into "File Data Visualizer", but that is limited to files. I actually want to connect my database in future, So file data visualizer wont help me much. Since the data is not getting ingested at all(I mean the release ID 6), I think there is problem with my python scr…

Discuss the Elastic Stack

Exclude last value in a line graph of kibana

Elastic Stack Kibana

vidhyadhara (Vidhyadhara) March 27, 2020, 4:45pm 16

Here it is @flash1293.
Hope this is what you asked.

Topic		Replies	Views
Line graph Visualization Kibana	5	945	August 23, 2017
Kibana line chart null values Kibana	2	2346	July 6, 2017
Problem Plotting Zero values with Kibana Elasticsearch	3	1075	July 6, 2017
Kibana line chart issue Kibana	5	647	November 29, 2018
Kibana, Zero for null values Kibana	2	2976	July 19, 2018

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Exclude last value in a line graph of kibana

Related topics