Hello I have the following example: | makeresults count=3
| streamstats count
| eval C=(random() % 9) + 1
| eval S1=(random() % 5) + 1
| eval S2=(random() % S1) + 1
| eval Connects=(random() % 5) + 1
| eval Consumer = "Consumer" . C
| eval Service = "Service" . S2
| chart count(Consumer) over Consumer by Service
| addtotals labelfield=Consumer fieldname=Total
| addcoltotals labelfield=Consumer label=Sum This gives something similar to the following: Consumer Service1 Service2 Service3 Total Consumer1 0 0 1 1 Consumer2 2 1 0 3 Consumer5 0 1 0 1 Sum 2 2 1 5 Can someone please help me to add a new column with the percentage of "Total" based on the "Sum". for example: Consumer Service1 Service2 Service3 Total % Consumer1 0 0 1 1 20% Consumer2 2 1 0 3 60% Consumer5 0 1 0 1 40% Sum 2 2 1 5 Please note, the service columns are variable. The request is not urgent. Thank you and many greetings Res
... View more