This field is used to display various types of charts to visualize data without syncing to a PowerBI report. All charts require a TSQL Stored procedure to return data that will be displayed on the chart.
Charts can have a search component attached to it to provide greater flexibility in terms of displaying data. Learn more about available search components here or learn how to create your own search components here.
There are four basic chart types that can be created:
Here is an example of the Field Definition:
Below are the fields and their purpose:
- Chart Type – A dropdown list that contains a list of charts that can be used.
- Axis Type – A dropdown list that determines if the axis of the chart are numerical or categorical.
- Category Axis Type – Only available when Axis Type is Categorical. Determines what type of data will be on the axis.
- X Axis Type – Only available when the Axis Type is Numerical. Determines what type of data will be on the X Axis.
- Y Axis Type – Only available when the Axis Type is Numerical. Determines what type of data will be on the Y Axis.
- Title – The title that will be displayed above the chart.
- Legend Position – Determines where the legend will be displayed in relation to the chart.
- Stored Procedure – The TSQL Stored Procedure that will be called to return the data for the chart.
- Search Component – The name of a search component to be used. This field is optional.
- Enable Chart Tooltips – Determines if tooltips will be enabled on the chart. Tooltips are displayed when you hover over a data point on the chart and specific detailed information about that point will be displayed.
IMPORTANT NOTE: Currently only Categorical chart types are implemented. Numerical chart types will be implemented in a future update.