I am new to Splunk and working on Splunk DB Connect 2 app to query the MySQL DB tables to create report. I created the Identities, connections, and DB Inputs for MySQL DB. When I search:
| dbxquery query="select * from table" connection="myconnection"
I am getting the query output with the columns and rows in MySQL Table, but Pivot does not work. If I go to "statistics or visualization" and click Pivot and select fields and click OK, it shows "0" events and also count of Object shows as "0".
Can someone help me in creating Pivot/Chart based on the MY SQL Query? Am I missing anything else to create a Pivot.