Bar Graph

• Left Panel

• Center Panel

• Right Panel

Left Panel

• Chart Source

• Metrics and Columns

Chart Source

Chart Source lets you control how a chart is powered. You can edit the dataset, swap it with another, or view the underlying SQL query for analysis.

• Edit Dataset

• Swap Dataset

• View in SQL Lab

Figure: Chart Source

Edit Dataset

Lets you make changes to the underlying dataset definition used by the chart.
It is accessible only for Admins, for other users this option is grayed.

Swap Dataset

Allows you to replace the dataset currently powering the chart with another dataset. For more information, refer to Field Description.

Note

Warning! Changing the dataset may break the chart if the chart relies on columns or metadata that does not exist in the target dataset.

Figure: Swap Dataset

Field Description

View in SQL Lab

Opens the raw SQL query that powers the dataset/chart in a SQL editor.

Figure: View SQL in Lab

Lets you to perform the below actions:

• Inspect the actual query running behind the visualization

• Modify or extend the SQL for more complex logic

• Validate the query results before applying them back into the dataset or chart

Useful for power users who need transparency and control over the exact query execution.

Metrics and Columns

Enables you to drag and drop the Metrics and Columns to the center panel of Edit Report Dashboard.
Hover on the SQL icon to view the SQL Expression.

Figure: Columns and Metrics

Center Panel

• Data

• Customize

Data

Data section displays 5 items for Bar Chart which are described in the below sections:

Figure: Data

1. Chart Selection – choose the visualization type for displaying data.
   Click View all charts to view and select the required visualization type.

   

   Figure: Visualization Type
   

2. Query:  view or modify the data query powering the chart.
   For more information, refer to the Field Description.

   

   Figure: Query

   Field	Description
   Y-axis	Dimension to use on y-axis.
   Time Grain	Select a time grain for the visualization. The grain is the time interval represented by a single point on the chart.
   Y-Axis Sort By	The selected sort by decides which measure to sort the base axis by.
   Y-Axis Sort Ascending	Whether to sort ascending or descending on the base axis.
   Metrics	Select one or many metrics to display. you can use an aggregation function on a column or write custom SQL to create a metric.
   Dimensions	Dimensions contain qualitative values such as names, dates or geographical data. Use dimensions to categorize, segment and reveal the details in your data. Dimensions affect the level of detail in the view.
   Contribution Mode	Calculates contribution per series or row.
   Filters	Drag and drop filters from Columns and Metrics.
   Series Limit	Limits the number of series that get displayed. A joined subquery (or an extra phase where subqueries are not supported) is applied to limit the number of series that get fetched and rendered. This feature is useful when grouping by high cardinality columns though does increase the query complexity and cost.
   Sort query by	Orders the query result that generate the source data for this chart. If a series or row limit is reached, this determines what data are truncated. If undefined, defaults to the first metric (where appropriate).
   Row limit	Limits the number of the rows that are computed in the query that is the source of the data used for this chart.
   Truncate Metric	Select whether to Truncate Metric
   Show empty columns	Select to show empty columns.

3. Advance Analytics: This section contains options that allow for advanced analytical post processing of query results.

   Field	Description
   Rolling Function	Defines a rolling window function to apply works along with the [periods] text box.
   Timeshift	Overlay one or more timeseries from a relative time period. Expects relative time deltas in natural language (Example: 24 Hours, 7 Days, 52 Weeks, 365 Days) Free text is supported.
   Calculation Type	How to display time shifts. As individual lines as the difference between the main time series and each time shift as the percentage change; or as the ratio between series and time shifts.
   Resample Rule	Select the Resample Rule from the dropdown. Figure: Resample In pandas, the resample rule (also called a frequency string or offset alias) is a string code that tells pandas how to group your time-series data when using the resample method.
   Resample Method	Select the Fill Method. Figure: Resample Fill Method The pandas resample method is a powerful function in the pandas library used to change the frequency of time-series data. It works by grouping data based on time intervals (such as daily, monthly, weekly, etc.) and then applying an aggregation function (such as sum, mean, count, etc.) to each group.

4. Annotations and Layers: Configure basics of Annotations and Layers.
   

   Figure: Annotations and Layers
   

5. Predictive Analytics:
   Refer to the following table for Field Description.

   Field	Description
   Enable Forecast	Enable Forecasting
   Forecast Periods	How many periods into the future do we want to predict.
   Confidence Interval	Width of the confidence interval should be between 0 and 1.
   Yearly Seasonality	Should yearly seasonality be applied. An integer value will specify Fourier order of seasonality.
   Weekly Seasonality	Should weekly seasonality be applied. An integer value will specify Fourier order of seasonality.
   Daily Seasonality	Should daily seasonality be applied. An integer value will specify Fourier order of seasonality.

Customize

Click on the customize section  to view the configuration and other options.

• Chart Orientation

• Chart Title

• Chart Options

Figure: Customize

Chart Orientation

Enables you to design the chart in a Vertical or Horizontal format,

Figure: Chart Orientation

Chart Title

Allows you to design the X axis and Y axis. For more information, refer to the Field Description.

Figure: Chart Title

Field Description

Chart Options

Enables you to design the following:

• Series Order

• Legend

• X Axis

• Tooltip

• Y Axis

Series Order

To configure series order, refer to the following:

Legend

To configure Legend, refer to the following:

X Axis

Configure X Axis elements:

Tooltip

Configure Tooltip as required, for more information refer to the below:

Y Axis

Configure Y axis for the Bar Graph

Right Panel

Displays the Bar Graph. Based on the configuration.

Figure: Bar Graph