I am not seeing results for count on each of the fields for the 2 different searches below: The first one shows the (lets say 3 storefront names ) with no counts. If I just run a | stats count by Storefront it returns with the correct number of counts. The fields are created in statistics with no counts or names of the the netscalers, site, or user. The second search does not return any statistical results. Hoping to see the count of connections to the Storefront and its correlating NetScaler in a Sankey diagram. | stats count by Storefront | rename Storefront as source | appendpipe [ stats count by Netscaler | rename Netscaler as source, count as count_Netscaler ] | appendpipe [ stats count by site | rename site as source, count as count_site ] | appendpipe [ stats count by UserName | rename UserName as source, count as count_UserName ] | fields source, count_Netscaler, count_site, count_UserName | search source=* | stats count by Storefront | rename Storefront as source | appendpipe [ stats count by Netscaler | rename Netscaler as source, Storefront as target ] | appendpipe [ stats count by site | rename site as source, Netscaler as target ] | appendpipe [ stats count by UserName | rename UserName as source, site as target ] | search source=* AND target=* | stats sum(count) as count by source, target | fields source, target, count
... View more