I have the following search. It returns the median duration for the weeks selected. I want to be able to show a week by week comparison in one chart. I am using a stacked bar chart, and would like each of the three weeks to display grouped by school name. school name 1 week 1 hour and minutes week 2 hours and minutes week 3 hours and minutes school name 2 week 1 hour and minutes week 2 hours and minutes week 3 hours and minutes index=summary_lms source=2q13Summary-student earliest=-3w@w0 latest=-1w@w [inputlookup oracle.csv | where like(DISTRICT_NAME,"$district$%") AND like(DISTRICT_STATE,"$state$") AND ACTIVE_STATUS=1 | lookup search_schid2uuid school_id OUTPUT sch_id | return 500 sch_id] | stats sum(problems) as problems sum(sections) as sections sum(duration) as duration by sch_id, stu_id | stats median(duration) as medianDuration median(problems) as median-problems median(sections) as median-sections dc(stu_id) as students by sch_id | eval hours=if(medianDuration/3600<1,0,round(medianDuration/3600)) | eval minutes=if(hours>0,(round(medianDuration/60)-(round(medianDuration/3600)60)),round(medianDuration/60)) |eval minutes=if(minutes<0,0,minutes) | eval seconds=if(minutes<60,(round(medianDuration/60)-(round((medianDuration/60).60))),round(medianDuration/60)) | lookup search_schid2uuid sch_id OUTPUT school_id | eval ACTIVE_STATUS=1 | lookup search_oracle school_id ACTIVE_STATUS OUTPUT SCHOOL_NAME DISTRICT_NAME DISTRICT_STATE | fields SCHOOL_NAME minutes hours ... View more