@bora9, I have updated a screenshot with code snippet for rex command. Make sure you have escaped also double quotes inside regular expression should be prefixed with backslash
Try the following in Splunk Search and see if it working. If it does, edit the dashboard Panel and Add the following Query from UI Edit option instead of Simple XML source code.
| makeresults
| eval _raw="{
\"system_id\":\"00092384\",
\"total_devices\":1,
\"intervals\":[
{
\"end_at\":\"2018-03-01T00:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T00:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T00:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T01:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T01:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T01:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T01:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T02:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T02:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T02:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T02:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T03:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T03:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T03:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T03:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T04:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T04:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T04:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T04:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T05:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T05:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T05:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T05:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T06:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T06:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T06:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":0
},
{
\"end_at\":\"2018-03-01T06:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":10
},
{
\"end_at\":\"2018-03-01T07:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":142
},
{
\"end_at\":\"2018-03-01T07:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":273
},
{
\"end_at\":\"2018-03-01T07:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":356
},
{
\"end_at\":\"2018-03-01T07:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":428
},
{
\"end_at\":\"2018-03-01T08:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":483
},
{
\"end_at\":\"2018-03-01T08:15:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":525
},
{
\"end_at\":\"2018-03-01T08:30:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":566
},
{
\"end_at\":\"2018-03-01T08:45:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":593
},
{
\"end_at\":\"2018-03-01T09:00:00-07:00\",
\"devices_reporting\":1,
\"wh_del\":621
}
],
\"meta\":{
\"status\":\"normal\",
\"last_report_at\":\"2018-03-01T09:03:29-07:00\",
\"last_energy_at\":\"2018-03-01T09:02:51-07:00\",
\"operational_at\":\"2017-09-14T16:39:46-06:00\"
}
}"
| rex "\"end_at\":\"(?<end_at>[^\"]+)\"\,\s+\"devices_reporting\":(?<devices_reporting>[^\,]+)\,\s+\"wh_del\":(?<wh_del>\d+)\s+\}" max_match=0
| fields - _time _raw
| eval data=mvzip(end_at,wh_del)
| fields data
| mvexpand data
| eval data=split(data,",")
| eval _time=strptime(mvindex(data,0),"%Y-%m-%dT%H:%M:%S"), Production=mvindex(data,1)
| fields - data
| timechart sum(Production) as Total span="1h"
... View more