If I understand correctly, you have data in an excel file, and you want to chart something just from that data in Splunk.
Are you able to export the tables as CSV files?
You can then define a lookup from the csv file, and then use the search command inputlookup to read in the data, which you can then pipe to stats, chart or timechart. For example:
| inputlookup my_lookup_name | chart count by field
If I understand correctly, you have data in an excel file, and you want to chart something just from that data in Splunk.
Are you able to export the tables as CSV files?
You can then define a lookup from the csv file, and then use the search command inputlookup to read in the data, which you can then pipe to stats, chart or timechart. For example:
| inputlookup my_lookup_name | chart count by field
Nevertheless it was a confusion with "inputlookup" command as it turned out that
1) the command should be strictly in the beginning of the search
2) should start with "|"
3) and the rest of the search should be appended.
All this was not obvius from its description in the search commands reference (maybe just for me).
So my working string looks like this:
| inputlookup my_lookup_csv_file
| append [search source="my_source"
...... ]
Thanks again!
Dart, thank you a lot! You showed me the right direction of solving the problem. Now I see vast horizons of how to use this new knowledge..:) I've already tried "inputlookup" and "lookup" and got exactly what I needed!
I used splunk manager interface instead of editing config files to create lookup tables: http://docs.splunk.com/Documentation/Splunk/4.3.3/User/CreateAndConfigureFieldLookups