Ideally you should have asked a new question for this. But here is the updated answer based on your new question (Please try out and upvote if this solves your issue): If you do not provide header_field to transpose function it gives them default names like "row 1", "row 2"... etc. So you can run your query to count by week day and then sort them descending by count. Since you can read results only by one row you would need to index=_internal sourcetype=splunkd log_level="ERROR" | stats count as CountByWeekDay by date_wday | sort - CountByWeekDay | eval CountByWeekDay= CountByWeekDay." (".date_wday.")" | fields - date_wday | transpose 7 You can then use $result.row 1$ , $result.row 2$ etc to access the values. You can also add depends="$result.row 1$" etc to your HTML panel to hide them when they are not set. Otherwise, you will have to handle null results in your query itself to show zeros as the count fo a particular day. Following could be one of the approaches (run anywhere search based on Splunks _internal index). I am appending zero count rows for each of the week day and then picking max of the result for the weekday. index=_internal sourcetype=splunkd log_level="ERROR" | stats count as CountByWeekDay by date_wday | append [| makeresults | eval date_wday="sunday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="monday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="tuesday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="wednesday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="thursday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="friday" | eval CountByWeekDay=0 | fields - _time] | append [| makeresults | eval date_wday="saturday" | eval CountByWeekDay=0 | fields - _time] | stats max(CountByWeekDay) as CountByWeekDay by date_wday | sort - CountByWeekDay | eval CountByWeekDay= CountByWeekDay." (".date_wday.")" | fields - date_wday | transpose 7 ... View more