Accounts are not showing in the source-> Account tab, We see that aggregation is getting success and we can see count also , However, Accounts are not loading in the source.
It looks to me like the result of your query doesn’t contain the attribute in the schema setup as the account name and account id. If that is the case, ISC cannot display those accounts properly.
Yes, it might be setup, but is it pointing to the correct attributes? I.e. is the name of those attributes the same as what would be returned from the query? The names are case sensitive!