topic Generating csv file from a submit button in dashboard in Dashboards & Visualizations

Generating csv file from a submit button in dashboard

av_ — Thu, 04 Apr 2024 18:00:56 GMT

Hi,

The requirement is that the user makes a dynamic selection (time range from time picker, environment from env dropdown and few more) and click submit button and as soon as hi clicks submit, a csv file should be generated as per the user input selection and later on the user should be able to reference that csv in the dashboard panel to create different visualisations.

Is that possible in Splunk?

Re: Generating csv file from a submit button in dashboard

ITWhisperer — Thu, 04 Apr 2024 18:04:37 GMT

The outputlookup command has a create_context option which can be set to user to create user-specific versions of the lookup (csv) file.

https://docs.splunk.com/Documentation/SplunkCloud/9.1.2312/SearchReference/Outputlookup

Re: Generating csv file from a submit button in dashboard

av_ — Thu, 04 Apr 2024 18:12:34 GMT

Thanks @ITWhisperer for the prompt reply.
I don’t understand how a csv file would be generated on the click of a submit button in a dashboard. Can you please elaborate more.

the user selections would be 1. Time range and click submit.
the panel will show the results for a query which runs for the selected time range.

now the question is how can I export it to a csv automatically. And later on use this csv for different visualisation in a dashboard panel

Re: Generating csv file from a submit button in dashboard

ITWhisperer — Thu, 04 Apr 2024 18:19:51 GMT

Which bit don't you understand? How to set up a submit button, or how to have a panel search execute if a token changes?

Your panel search could be a hidden panel whereby the search uses outputlookup as I suggested.