【Kibana】The line graph problem

[ydbdyds (cxy)]

I had a problem drawing with Kibana
，Every day I generate a document that looks like the following data structure

{
    "reports":[
        {
            "url":"test1",
            "method":"get",
            "val1":40,
            "val2":20
        },
        {
            "url":"test2",
            "method":"get",
            "val1":10,
            "val2":15
        },
        {
            "url":"test3",
            "method":"get",
            "val1":12,
            "val2":23
        }
    ],
    "reportCreateTime":"2022-12-01"
}

How do I draw a line graph to trend test1,test2,test3？
If I need to adjust my data structure, what should I do?

[warkolm (Mark Walkom)]

Welcome to our community!

You ideally want to have each of the reports you have there in their own document/event with a timestamp attached to them. eg;

{
  "reportCreateTime":"2022-12-01"
  "url":"test1",
  "method":"get",
  "val1":40,
  "val2":20
}

{
  "reportCreateTime":"2022-12-01"
  "url":"test2",
  "method":"get",
  "val1":10,
  "val2":15
}

[ydbdyds (cxy)]

thx~~