Hi wang,
I try to sort count in ascending order after converting count as strings with
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") |sort + count
or sort count by lexigraphically order with
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") |sort + str(count) , This both query work fine!
But when i apply xyseries command in this both query, the , the results not change; The results is the same like query that follow:
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") | xyseries group sourcetype count
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") |sort + count| xyseries group sourcetype count
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") |sort + str(count)| xyseries group sourcetype count
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") | xyseries group sourcetype count |sort + count
index=_internal | stats count by group sourcetype | eval count=tostring(count,"commas") | xyseries group sourcetype counter |sort + str count
Please, Don't forget to vote me if my first answer satisfy you!
... View more