Today, I have to create a chart from log in json format. The log is something like that:
Expired token in next 3 days {"data":[{"date":"2014-06-25","Site1":100,"Site2":23,"Site3":133},{"date":"2014-06-26","Site1":200,"Site2":223,"Site3":232},{"date":"2014-06-24","Site1":150,"Site2":342,"Site3":422}]}
Output should be a chart (column chart) which contains information about date and number of expired token for each site
The log will show the list of expire token from 3 sites for next 3 days. The json format can be changed to whatever for suitable.
Anyone please help to give me any suggestion.
Hi ndkhoiits,
take a look at the docs about the spath command example 3, this will show you how to use spath
on JSON logs.
cheers, MuS
based on your provided data:
{"data":
[
{"date":"2014-06-25","Name":"Site1":"Count":"100"},
{"date":"2014-06-25","Name":"Site2":"Count":"23"},
{"date":"2014-06-25","Name":"Site3":"Count":"133"}
]
}
Would you like to give me a clear explanation or a sample
still no need for mvzip because you have per date a Site1, Site2 and Site3 entry. Personally I would add a Name=Site[1|2|3]
key=value pair and a count=value
per date in the JSON, much easier to handle
This example is my real world data
your sites names are Site1, Site2 and Site3 in the example JSON, so no need for mvzip... or are those site names all equal and this example is your real world data?
Thanks for your answer, however in my requirement there are 3 sites which need to be included in the report, so I don't know how to use mvzip in this case
The chart can be something like that
https://docs.google.com/file/d/0B_zzVMkc4PNJN1p3LU1fMGZ4cWs