I have the following search:<base search>| fields host registrations| stats latest(registrations) by hostThis produces the following table:host latest(registrations)Pc1 51
Pc3 18How would I add the values of latest(registrations) to provide a single value for all 3 hosts? For example, I would like only the sum of the latest registrations (98) to display in a single value panel.
| fields host registrations
| stats latest(registrations) as latest_reg by host
| stats sum(latest_reg) as total_latest_reg
View solution in original post
Thank you!! This worked for me.