Hi, eugenek
Assuming that the field contening how value is q , with the following you can have what you are describing easily.
1- Count of value of field q that start with lowercase (apple):
.... q=* | where like(q, "apple%")|stats count(q) AS Count_apple
2- Count of value of field q that start with uppercase (Apple):
.... q=* | where like(q, "Apple%")|stats count(q) AS Count_Apple
3- count of the original mixed field( only for values of apple & Apple) :
.... q=* | where like(q, "Apple%") OR where like(q, "apple%") |stats count(q) AS mixed_count
... View more