I have created a dbx query which has 6 columns in select statement as shown below(chart 1),now I want to have two of the column in y-axis which is first_response and closure_time and x-axis as MONTH as shown in below chart(chart 2) and the other 3 columns such as work_item_id,status and filed_against has to be a filter.
chart 1:
chart 2:
Can you try with settings in Visualization tab in Splunk Search as the screenshots?
Where series A, B are the two values in y-axis.
Instead, if you can find "Clustered Column" option in Visualization chart options in your current Splunk version, then can use it directly without settings as the above.