topic Re: addtotals result move to the top row in Dashboards & Visualizations

addtotals result move to the top row

viktoriiants — Sat, 30 Mar 2024 00:15:53 GMT

The query produces multiple pages of results. How do I move the total to the top (first) row for convenience?

search query | eval dayOfWeek=strftime(_time, "%A"), date=strftime(_time, "%Y-%m-%d") | eval dayNum=case(dayOfWeek=="Sunday", 1, dayOfWeek=="Monday", 2, dayOfWeek=="Tuesday", 3, dayOfWeek=="Wednesday", 4, dayOfWeek=="Thursday", 5, dayOfWeek=="Friday", 6, dayOfWeek=="Saturday", 7) | stats count as "Session count" by dayOfWeek, date | addtotals col=t row=f label="Month total" |sort date desc

Re: addtotals result move to the top row

meetmshah — Sat, 30 Mar 2024 06:04:44 GMT

Hello @viktoriiants, How about sorting it by 'Session count' before date desc?

Re: addtotals result move to the top row

meetmshah — Wed, 03 Apr 2024 08:22:49 GMT

Hello, Just checking through if the issue was resolved or you have any further questions?

Re: addtotals result move to the top row

danspav — Thu, 04 Apr 2024 04:48:08 GMT

Hi @viktoriiants.,

How about something like this:

Here we're creating a new temporary field to sort on, where we set it to 1 for our total row, and 0 for all other rows. Then we sort by this column and the date column. Finally, we remove the "sort" column.

Re: addtotals result move to the top row

viktoriiants — Mon, 08 Apr 2024 23:59:34 GMT

Thank you! It did help

Re: addtotals result move to the top row

viktoriiants — Tue, 09 Apr 2024 00:00:29 GMT

Thank you