I have a boolean field in my index.
I apply the static conversion to 0,1
I just want to create a simple graph with Timestamp on ths x-axis and 0 or 1 (or empty) on the y axis. However, when I go to lens to try to create the graph I am getting:
"This field does not work with the selected function."
For the function I select "Last Value".
I have the same when I try average or most of the others except Count which works.
However the documentation here:
states that
Aggregations like the terms aggregation use 1 and 0 for the key , and the strings "true" and "false" for the key_as_string . Boolean fields when used in scripts, return true and false
so why I am not able to select average? else I have no way to visualize this data.
As an alternative is there some way for me to use max or min on a boolean by somehow convertint it to 1, 0.
again I tried to apply a static mapping to 0 and 1, but it is not working. I still get "This field does not work with the selected function."