[]
        
(Showing Draft Content)

3D Column E-Chart

3D Column E-Charts in Wyn Enterprise offer a dynamic and visually engaging way to represent complex data, enabling you to extract valuable insights. 3D Column E-Charts transcend the limitations of traditional column charts by incorporating depth and perspective, adding an extra dimension to your data visualization experience and helping in comprehending data hierarchies, patterns, and trends. Learn more about creating, customizing, and using a 3D Column E-Chart below.


In this help article, you will find the following information,

Create a 3D Column E-Chart

To create a 3D Column E-chart, navigate to the Resource or Document Portal and follow the below instructions,

  1. Click the + Create button and then click the Create Dashboard option.

    create a dashboard

  2. Select the Blank Dashboard option or select a template and click the Create button.

    select a dashboard template

  3. Navigate to the Custom Visualization tab from the Designer Toolbox and drag and drop the 3D Column Chart(Echarts) onto the design area.

    drag and drop chart scenario

Bind Dataset to 3D Column E-Chart

  1. With the 3D Column E-Chart selected, choose a dataset from the Choose Data dropdown in the Data Binding panel.

    Choose dataset from the dropdown

  2. Now, drag and drop the applicable dataset fields in the Values, Axis (Category), Legend (Series), and Tooltip data containers. You can also select a drill-down mode (Default, Pre-set Targets, or Pre-set Path) from the Mode dropdown under the Drill Down option. See the Drill Down help article for more information on drilling down in Wyn Enterprise.

    Drag and drop dataset fields

Format Data Attributes

You can perform various operations in a 3D Column E-Chart to format the data attributes and control the data display. Use the settings icon in the Data Field containers to format data attributes. The following operations are included in the 3D Column E-Chart scenario;

  • Aggregation Method: Use the Aggregation Method option to display a summarized value by aggregating multiple values of a data attribute. Aggregation Method supports Sum, Average, Max, Min, Count, and Distinct Count methods. See the Aggregation Method help article for more information.

  • Quick Functions: Use the Quick Functions option to highlight key indicators in your chart scenario by applying powerful calculations on measures. Quick Functions in Wyn Enterprise support Date Based Functions, Ranking Calculation, Percentile Calculation, Running Calculation, Moving Calculation, and Original Value. See the Quick Functions help article for more information.

  • Filter: Use the Filter option to display relevant data in your chart scenario. See the Filter Data help article for more information.

  • Rename: Use the Rename option to change the name of a data attribute to make it comprehensible and meaningful. See the Rename a Data Attribute help article for more information.

  • Remove: Use the Remove option to remove a data attribute from the chart scenario.

Analyze Data

Wyn dashboard scenarios support rich data analysis and exploration capabilities to help you analyze massive amounts of information and make data-driven decisions. The following analysis operations are available in the Action Bar corresponding to each scenario in the designer;

  • Filter: To filter out relevant data in your chart scenario. See the Filter Data help article, for information on using the filter options in a dashboard scenario.

  • Sort: To arrange the chart data in a more meaningful order. See the Sort help article for information on using the sort options in a dashboard scenario.

  • Conditional Visualization: To filter, compare, and rant the data in a dashboard scenario. See the Conditional Visualization help article for information on using various visualization options.

  • Data Binding: To modify the data binding of the dashboard scenario with new attributes use the Data Binding option. See the Modify Data Binding help article for more information.

  • Focus: To expand the chart scenario to full-screen size, use the Focus option.

Customize Appearance

Navigate to the Inspector Panel and modify the settings as per your requirements. The properties of the 3D Column E-Chart are listed and described below.

CHART STYLE

Property

Description

Maintain Color Assignments

To change the color assignments of the column bars, turn the flag to True and change the color of the data items from the Assign Colors popup using the Color Assignment property.

To use the default color palettes for the column bars, turn the flag to False and select a default color palette from the Palette property. By default, the value of the Main Color Assignment property is set as False.

Color Assignment

Color Assignment property is visible only when the Maintain Color Assignment property is set to True. This property is used to manage the colors of the data items of the column bars.

Palette

Palette property is visible only when the Maintain Color Assignment property is set to False. Palette is used to select the group of colors for the column bars.

Graph Opacity

Use the Graph Opacity property to set the opacity level of the e-chart. The value of the Graph Opacity property ranges from 0% to 100%.

Auto Gradient

To set an automatic color gradient in the chart, set the Auto Gradient property to True. By default, the value of this property is set as False.

Show Mark Point

To display the minimum and maximum values of the chart, set the Show Mark Point property to True. By default, this property is set to False.

Min Mark Point

To display the minimum value point, set the Min Mark Point property to True. By default, this property is set as False.

Max Mark Point

To display the maximum value point, set the Max Mark Point property to True. By default, this property is set as False.

Mark Point Color

Set the color of the mark point bubble using the *Mark Point Color property.

Mark Point Font

Set the family, size, color, weight, and style of the mark point font using the Mark Point Font property.

Canvas Position

Set the Left, Right, Top, and Bottom positions of the chart canvas using the Canvas Position property.

Shape

Select the Cube or Cylinder option from the dropdown to set the shape of the column bars.

Border Color

Select a border color for the column bars using this property.

Shape Background

To enable the background shape on the chart scenario set this property to True. By default, this property is set as False.

Shape Background Border Color

Select the border color of the background shape using this property.

Shape Background Color

Select the color of the background shape using this property.

Custom Echarts Option

Use the Custom Echarts Option to customize the chart using JavaScript code.

Custom Behavior

Use the Custom Behavior option to directly write JavaScript code and use setTimeout/setInterval/myChart (echart instance), etc., to customize the behavior of the chart, to dynamically change the chart content in real-time. Refer to section E-Charts Custom Behavior for more details.

ANIMATION

Property

Description

Entrance Animation

Select an option from the dropdown to set the animation style of the appearance of the chart scenario. After selecting an option (SlideInDown, SlideInLeft, SlideInRight, SlideInUp, SlideInDown, BackInDown, BackInLeft, or BackInRight) from the dropdown, set the delay and duration of the animation using the Delay(s) and Duration(s) properties respectively.

DATA VISUALIZATION

Property

Description

Automatic Carousel

To highlight the columns one at a time and display the tooltip, set the Automatic Carousel property to True. By default, this property is set to False.

Interval (seconds)


Include All Dimensions

To include the labels with Null values in the chart scenario, set this property to True.

Show Zoom Axis

To display the Zoom Axis on the chart scenario set the Show Zoom Axis property to True.

Zoom Axis Size

Set the size of the zoom axis ranging between 10 to 30 using the Zoom Axis Size property.

Zoom Axis Default Length

Set the default length of the zoom axis using the Zoom Axis Default Length property.

Zoom Axis Color

Select the color of the zoom axis using the Zoom Axis Color property.

INTERACTION

Property

Description

Scenario Name

Add a name to the chart scenario using this property.

Cross Filter

To reflect the filtered data throughout the dashboard, set this property to True. Cross filters provide a simplified and deeper analysis of what you want to observe.

Jump To

To create a shortcut to another dashboard scenario, report, or URL use this property. See the Jump To help article for more information.

Auto Refresh

Set None, Polling, or Real Time option from the dropdown to refresh the chart data. Dropdown options are described below,

None - Select None to disable auto-refresh of the chart data.

Polling - Select Polling to enable auto refresh and set an interval to refresh chart data in the Refresh Interval property.

Visible Menu Items

Select the filtering and sorting options you wish to display on the chart scenario from the dropdown.

Pin Annotation

To pin the annotation to the chart scenario, set this property to True. By default, this property is set as False.

Context Menu Actions

Select multiple Context Menu Options from the dropdown. Context Menu Options include - Keep, Exclude, Jump, and Add Data Monitoring.

Click Action

Select None, Show Tooltip, Keep, Exclude, or Jump option from the dropdown to perform an action on click.

Command


Single Selection

To allow a single selection of chart instances, set this property to True. By default, this property is set as False.

DATA LABELS

Property

Description

Show Data Labels

To display data labels set the Show Data Label property to True. By default, the value of the Show Data Label property is set to False.

Display Pattern

You can add a line break (, \n()) between Category, Series, and Value, by using the Display Pattern property for the data labels. If you hide some parts of the label, like the value, series, and category, the part will be removed from the pattern, and the related connector (the prefix , \n ()) will also be removed. The dropdown list has 3 display pattern options. By default, the display pattern selected is Category, Series(Value).

Value

To disable the display of the data label values set the Value property to True. By default, the value of the Value property is set to False.

Display Unit

Select a display unit option from the dropdown. The available options are Auto, None, Thousands, Millions, Billions, and Trillions.

Series Name

To display the name of the data label series set the Series Name property to True. By default, the property is set to False.

Category Name

To display the data label category names set the Category Name property to True. By default, the property is set to False.

Location

Select the Inside or Outside option from the dropdown to display the data labels inside or outside the column bars.

Display Mode

Select an option from the dropdown to set the display mode of the data labels. The available options are Auto and All.

Data Label Font Setting

Set the font family, font size, font color, font weight, and font style of the data labels using this property.

AXIS(CATEGORY)

Property

Description

Show Axis

To hide the Category (X) Axis, set this property to False. By default, this property is set as True.

Axis Position

Select the Zero, Bottom, or Top option from the dropdown to set the position of the Category (X) Axis.

Show Axis Line

To hide the Category (X) Axis line, set this property to False. By default, this property is set as True.

Axis Line Type

Select Solid or Dashed line type for the Category (X) Axis line from the dropdown.

Axis Line Color

Set the color of the Category (X) Axis line using this property.

Axis Line Width

Set the Category (X) Axis line width using this property.

Show Grid Lines

To show the grid line of the Category (X) Axis, set this property to True. By default, this property is set as False.

Grid Line Type

Select Solid or Dashed type of grid lines for the Category (X) Axis from the dropdown.

Grid Line Color

Set the color of the grid lines of the Category (X) Axis.

Grid Line Width

Set the width of the grid lines of the Category (X) Axis

Show Split Area

To highlight the split area on the chart, set the Show Split Area property to True. By default, the property is set to False.

Odd Area Color

Select a color to highlight the odd area.

Even Area Color

Select a color to highlight the even area.

Show Tick Labels

To hide the tick labels of the Category (X) Axis, set this property to False. By default, this property is set as True.

Label Direction

Select the Horizontal, Vertical, or Diagonal option from the dropdown to set the direction of the Category (X) Axis labels.

Label Overflow Setting

Select Hide, Ellipsis, or Wrap option from the dropdown for the overflowing text of the labels.

Show Tick Marks

To hide the tick marks of the Category (X) Axis, set this property to False. By default, this property is set as True.

Show Title

To show the title of the Category (X) Axis, set this property to True. By default, this property is set as False.

Title Offset

Set the offset distance of the title from the Category Axis using this property.

Axis Font Setting

Set the font family, size, color, weight, and style of the Category (X) Axis labels using the Axis Font Setting options.

VALUE AXIS

Property

Description

Show Axis

To hide the Value (Y) Axis, set this property to False. By default, this property is set as True.

Max Value

Set the maximum value of the Value (Y) Axis labels using the Max Value property.

Min Value

Set the minimum value of the Value (Y) Axis labels using the Min Value property.

Interval

Set the interval between two labels of the Value (Y) Axis using the Interval property.

Reversed

To reverse the appearance of the chart scenario, set this property to True. By default, this property is set as False.

Axis Position

Select the Left or Right option from the dropdown to set the position of the Value (Y) Axis.

Show Axis Line

To hide the Value (Y) Axis line, set this property to False. By default, this property is set as True.

Axis Line Type

Select Solid or Dashed line type from the dropdown for the Value (Y) Axis line.

Axis Line Color

Set the color of the Value (Y) Axis line using this property.

Axis Line Width

Set the Value (Y) Axis line width using this property.

Show Grid Lines

To show the Value (Y) Axis grid line, set this property to True. By default, this property is set as False.

Grid Line Type

Select Solid or Dashed type of grid lines for the Value (Y) Axis from the dropdown.

Grid Line Color

Set the color of the grid lines of the Value (Y) Axis.

Grid Line Width

Set the width of the grid lines of the Value (Y) Axis.

Show Split Area

To highlight the split area on the chart, set the Show Split Area property to True. By default, the property is set to False.

Odd Area Color

Select a color to highlight the odd area.

Even Area Color

Select a color to highlight the even area.

Show Tick Labels

To hide the tick labels of the Value (Y) Axis, set this property to False. By default, this property is set as True.

Format

Set a general, number, currency, percentage, or a custom format for the labels of the Value (Y) Axis.

Display Unit

Select Auto, None, Thousands, Millions, Billions, or Trillions option from the dropdown to set the display units of the Value (Y) Axis labels.

Label Direction

Select the Horizontal, Vertical, or Diagonal option from the dropdown to set the direction of the Value (Y) Axis labels.

Show Tick Marks

To hide the tick marks of the Value (Y) Axis, set this property to False. By default, this property is set as True.

Show Title

To show the title of the Value (Y) Axis, set this property to True. By default, this property is set as False.

Show unit's label


Title Offset

Set the offset distance of the title from the Value Axis using this property.

Axis Font Setting

Set the font family, size, color, weight, and style of the Value (Y) Axis labels using the Axis Font Setting options.