I want to create a pie chart , but in my dbxquery output come in statistics tab, and nothing come in visualization tab.
For fix it what I need to do ?
my search string is :
| dbxquery query="SELECT username , sum(memorykb) as memorykb from ( SELECT NVL(a.username,'(oracle)') AS username, a.module, a.program, Trunc(b.value/1024) AS memory_kb FROM v$session a, v$sesstat b, v$statname c WHERE a.sid = b.sid AND b.statistic# = c.statistic# AND c.name = 'session pga memory' AND a.program IS NOT NULL) group by username " connection="SplunkReadOnly"
@arunkantsharma, since you are showing a pie chart visualization, you should ensure that dbxquery returns two fields First should be Label field for name of each slice. Second should be the value of each pie slice.
Following is the run anywhere search which you can try out as an example:
| top log_level