I want to add one more column for Selected Date in my search and display a trend chart based on the Date Selected, please check below for more details.

[krsuraj11]

index="splunk" host=splunk* tag="Failure" "Subjects" | stats count as FailedSubjects
|appendcols [search index=" splunk " host=splunk* tag="Failure" "Assignmnets" | stats count as FailedAssignments]

Please help me adding one more column for selected date in search and also help me how can I make a weekly graph based on the search.

I want to make a trend chart.