1. Click on the "Menu bar" on the left corner of the second ribbon from the top
2. Click on “Visualize” from the vertical menu bar that pops up when you click the menu bar as shown below:
3. Then finally click on “Create Visualization” to create a new visualization
4. Select the “Horizontal/Vertical bar” icon from the menu as shown below:
Select Horizontal/Vertical Bar Chart
5. Select the “Data source” from where the data is to be obtained for building your visualization. (Example given below; data source: ‘index -*-log-*’ is selected for monitoring logs with having the details of Slowlog IP)
Source for Data
6. Once you choose the data source, you will land on the page where you can customize your graph as per your requirements. Below given is the right side of the landing screen, the left side of the screen will have the required graph as per the set configuration
7. Choose the aggregation on Y-axis from the drop-down list. Once selected move on to set other metrics for customizing the graph(Example: Select "count" of the slow logs from different IPs)
8. When Y-axis has the count aggregation in place, it's time to set the bucket. The bucket is set from the following list of dropdowns which expands when you click on the “(+)Plus” sign
9. “X-axis” from the drop-down list to set the other axis for the graph. Select the aggregation type from the list. (Example select the aggregation type as “Terms”)
10. Once the X-axis aggregation is configured, the next step is to configure the other details under the list, which are “Field, Order by, Order, and Size”. You can also add a custom label for the X-Axis at this point as shown below with other details pertaining to the configuration. (Example of the configuration to plot the IPs of the slowlog for mysql can be custom labelled as “IP’s”)
Labelling under Custom Label
11. Once we complete other configurations, click on the “Update” button to verify that we are on track with our final visualization of the IP’s.
12. Final graph of the output required will be displayed on the left side of the screen. The example is shown below with the configurations based on previous steps.
13. Once the graph is as per the configurations and labelings, click on the “Save” button at the top right corner of the page to save the visualization.
Sample Vertical Bar Chart on Kibana