I have the table:
_time Ip_1 Ip_2 Ip_3
a 36 40 31
b 37 39 21
I want to take the percentage of each IP instead count, like:
a 0.33 0.37 0.28
The table above From the query:
base search | | stats dc(sid) AS distinct_search_count by provenance, mode, app, type, user, host, _time
| stats sum(distinct_search_count) as total_distinct_search_count by provenance, mode, app, type, user, host, _time
How can I add the percentage in the query?
| timechart minspan=10s partial=false Max(total_distinct_search_count) as search_count by host
... View more