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.