Hi to all,
i’m trying to do a report (graph) that show the data basing on project_name (y-axis) and row_num (x-axis) group by project_name,procedura,data_caricamento
I’m not able to populate the graph, i have not understanded lucene sintax, can someone explain me how I can write the lucene query to do this kind of report (I think simple) ?
I have this json from elastic :
{"_id":"bl1_lGsBg2P3c5kHub37","_type":"doc","_index":"log_test-n-2019.06.26","procedura":"test SAVA","message":"SAVA|test SAVA|[END] Aggiornamento COD_DEALER_REASON_TEST|1|1000|25/03/2012 02:50:52","esito":"1","tags":["logn","beats_input_codec_plain_applied"],"@timestamp":["2019-06-26T15:55:22.576Z"],"log_procedura":"[END] Aggiornamento COD_DEALER_REASON_TEST","host":{"name":"localhost.localdomain"},"data_caricamento":"25/03/2012 02:50:52","row_number":"1000","input":{"type":"log"},"fields":{"log_type":"access"},"agent":{"id":"9546f89a-5dde-49c2-bedf-3858a825a907","hostname":"localhost.localdomain","type":"filebeat","ephemeral_id":"65ef6bbb-1bb1-4a56-acc9-b008e6f38846","version":"7.1.1"},"log":{"offset":2232,"file":{"path":"/var/log/new_log_path/input_1/tl_1.log"}},"@version":"1","ecs":{"version":"1.0.0"},"project_name":"SAVA"}
Thanks in advance