Multiple queries on pivot report

jugarugabi — Wed, 27 Jan 2021 11:10:04 GMT

Hello,

I have the following search string:

index = app_events_dbdetect_actimize_event_us_uat sourcetype = txndata | rangemap field=Time_taken_AIS_tomcat 0s-to-0.05s=0-50 0.05s-to-0.10s=51-100 0.10s-to-0.15s=101-150 0.15s-to-0.20s=151-200 0.20s-to-0.30s=201-300 0.30s-to-0.50s=301-500 0.50s-to-1s=501-1000 1s-to-2s=1001-2000 2s-to-3s=2001-3000 3s-to-5s=3001-5000 5s-to-30s=5001-30000 >30s=30001-99999

Which is passed to a pivot table as a dataset.

The output is like this:

Now, there are some things that I want to know:

a) how can I sort the Column Values to be fraasdetppu1, fraasdetppu2, fraasdetppu10, fraasdetppu20...? It currently displays the information as fraasdetppu1, fraasdetppu10, fraasdetppu2, fraasdetppu21...

b) If the output has 0 values for 0s to 0.05s (for example), can I have it displayed here? I cannot seem to find where to get them displayed even if the "scored" items are 0 for the other ranges.

c) The grey line that has the totals shown for each server: can I add custom text under "scored" column?

d) Can a "Total" column be added right before the server names? It needs to sum up the count values of each server, for that specific "scoring" speed.

Thank you!

Re: Multiple queries on pivot report

jugarugabi — Wed, 27 Jan 2021 19:02:22 GMT

Tried with the search query:

but this didn't helped either.

topic Multiple queries on pivot report in Reporting

Multiple queries on pivot report

Re: Multiple queries on pivot report