Widget is a small block that performs a specific function. A large variety of Widgets provided to you by vData to give insight about the Database, to let you monitor and analyze Database and Server Performance.
You can quite easily create widgets (or search from Preset widgets) like Server response time, CPU Status, Daily Users, Processes, RAM Status, Latest Articles, and No. of Articles etc. for status monitoring. You can also monitor thread status- Open thread, connected, running, and thread cache.
To Create a Widget, Click on “Add Widget” button displaying on the Dashboard of vData.
vData allows you to either create a “Predefined Widget” or create a “Custom Widget” by executing the complex functions, queries and filters to retrieve your desired data.
- Title: Title (Name) of the Widget.
- Search Widget: Ajax based Search and Select a widget from Predefined widget list ( in Predefined Widget Tab ).
- Write Your Query: Fetch your desired data to display on the widget by writing your custom Database Query ( in Custom Widget Tab ).
- Database Table: You can also select a table to fetch the data from the dropdown list. Some additional fields will be displayed once you select the Table.
- Ordering: Set the Ordering of the Widget in which these will be displayed on Dashboard.
- Columns: Set the width of the widget in terms of number of Columns on the Dashboard. Possible maximum number of columns on Dashboard can be set in the configuration section.
- Rows: Set the height of the widget in terms of number of Rows. Minimum Height of a Row can be set in the configuration section.
- Display As: Set the Display type of your Widget whether you want to display your widget information as a Chart, as Listing or as a Single Value.
- Data Range Limit: Maximum number of data value points to render on Chart.
- Chart Type: Select a Chart type to display your data on Widget. vData provides a variety of charts designed to address your data visualization needs.
- Add Extra Condition: Put Extra conditions and apply filters to fetch Precise Information from Tables.
Click on “Add Extra Condition” button and popup of query builder will display.
You can add new rules and groups, delete a rule and group, see the outcome of Query Builder conditions on clicking “Write SQL” button. You can also reset the Query Builder conditions. Click on “Add Extra Condition” button to append the generated extra condition with your main query to fetch your desired data from Database table.
- Limit the Value: Set the Limit value for the Query to fetch the data from table.
- Order By Column: Set the column on which you want to put order by clause and the order either Ascending or Descending.
Depending upon the Chart Type, Additional Dynamic Fields under “Formatting Section” will be added on this form to gather the appropriate Data for generating the Chart.
- Formatting Section:
- Colors for Series: Set the different color for different Series Name by choosing color from the color picker.
- Legend Position: Choose the position where you want to display the Series Legend on the Chart. It can be one of the following:
- 'At BottomSide' - Below the chart.
- 'At LeftSide' - To the left of the chart.
- 'Inside ChartArea' - Inside the chart, by the top left corner.
- 'Outside ChartArea' – Outside the chart.
- 'Not Show' - No legend is displayed.
- 'At RightSide' - To the right of the chart.
- 'At Top' - Above the chart.
- Horizontal Axis Label: Set the Horizontal Label to display on the Chart.
- Vertical Axis Label: Set the Vertical Label to display on the Chart.
- Show series in Stacks: Set this option to show the Series in Stack atop one another instead, so that the data values at each x-value are summed.
- Show Connect Steps: Set this option to connect the steps to form a stepped line.
- Enable Interactivity: Set this option to set the Interactivity whether the chart throws user-based events or reacts to user interaction.
- Line Curve: Set this option if you want to show the lines on the Chart in Curve manner instead of straight lines.
- 3D Pie Chart: Set this option to display a three-dimensional (3D) chart.
- Donut Chart: Choose option to set Pie Hole. It should be set to a number between 0 and 1, corresponding to the ratio of radii between the hole and the chart. Numbers between 0.4 and 0.6 will look best on most charts. Values equal to or greater than 1 will be ignored, and a value of 0 will completely shut your pieHole.
- Region: Choose the area to display on the Geo Chart. (Surrounding areas will be displayed as well
- Chart Display Style: Choose Which type of Geo Chart this is. The Data Table format must match the value specified. The following values are supported:
- 'Regions' - Color the regions on the Geo Chart.
- 'Markers' - Place markers on the regions.
- 'Text' - Label the regions with text from the Data Table.