Hello,
Could someone please explain to me the difference between params.<name>
and params._all.<name>.values
in TSVB table visualization when using the Math aggregation? Based on the written definition I thought that params.<name>
is a reference to the value in each bucket whereas params._all.<name>.values
is an array made up of the values in all buckets.
For example if I have table of counts like this (split by sport type):
Sport, count
-------------------
soccer, 10
basketball, 5
football, 12
I'd expect params.<name>
to return the specific value of each bucket (which it does) and first(params._all.<name>.values)
to return "10" (first element in an array of [10, 5, 12]). Currently there is no difference between the two results as both return the count for each bucket. What am I missing?
My ultimate goal is to try and find a way to compare values between buckets... for example find and set all counts to the largest count max(params._all.<name>.values)
and in this case all buckets should show 12. However, it doesn't seem to be possible.
Thanks.