Report Component

    • Position (x, y, width, height, z Index)

    Components can be repositioned and resized on the report. If you'd like to stack/overlap components, z index field can be used to control the stacking order.

    • Border

    • Content background color

    Poli supports three types of components.

      • Table

      • Pie

    Pie chart requires the query to return at least two columns.

    • Bar
    • Line

    Line chart requires the query to return at least two columns. One for X-axis (Key). The other for Y-axis (Value).

    • Area

    Slicer provides a list of values to select. It requires the query to return one column only.

    • Single value
    • Create a filter and define a query parameter. The query parameter serves as a placeholder for a real value in the query string.
    • Create a chart and use the query parameter from the fitler in the SQL query.
    • Enter/Select the value in the filter and click apply filter button to see the chart data change accordingly.For example:

    Create a Slicer filter and define username as query parameter.

    Create a Table chart and use the :username in the IN clause.

    More dynamic query examples:

    Nested parameters are not supported. For example:

    • Drill through is used to navigate from one component in a Report to another Report. To use it in Poli, you need to have at least two reports.

    • Create a pie chart in Report 1. Go to Drill Through tab. Choose the source column and destination report.

    • Click the Cup piece on the pie chart.

    • Report 2 is being displayed and product=Cup is passed along to Report 2. If there are any chart components on Report 2 that use :product query parameter in the query will become reactive.

    Reports can be edited by Admin/Developer users, associated with a Group and viewed by all users. Check User Management for more details.