Page Comparison

Name

Each item can be renamed by the user

X Axis

Includes "Arguments", "Top N", "Axis Options" in the same dropdown.

• Arguments
  The chosen values are grouped by the field chosen as argument. Most often, a date field is used as an argument (to show the overtime trend).

• Top N

  • Arguments can only show the top/bottom N results. N can be set by the user. In addition, an "others" option will be available - all the arguments which are not in the top N.

  • If more than one value was chosen, and the user selected "Top N", the value that will determine the top will be the value that was first selected by the user.

• Axis Options -

  • Title - The title of the axis.

  • Show Axis - If this option is selected, the axis will be shown as part of the graph.

Y1/2 Axis

Includes the sections: "Values", "Summary Type", Format Type", "Series Options", "Axis Options" in the same drop down.

• Values - multi-choice of fields from the report - only numeric fields will be available. Each chosen value will be a different line/bar/area in the graph.

• Summary Type - the aggregating mode of the values, which will be the same for all the selected values.

• Format type

• - The format for the display of numeric values (not relevant for textual values). Format options are:

  Number -

• Show the value as a number.

  Percent -

• Multiply the value by 100 and show as percent. example: if value is 0.8, show 80%.

  Currency –

• Show the value with

• the currency icon. example: if value is 0.8, show 0.8$

• . The currency will be displayed according to the currency defined for the organization, or the currency defined for the cluster (cluster definitions take precedence over organization definition).

  Temperature

  Volume

  Weight

  Velocity

  Distance

  Pressure

  • The units of measure change according to the settings of each individual user in the My Users section

  • For each format type, the user can define precision - any number between 0-

• • 10.

  • When the format type is selected, the value returned from the report mechanism is not converted. It is only the mark that is added.

     Format types will not be validated by field types; that is, if a field is numeric, you can add any format type to it.

• Series Options

  • Type – present the values according to the selected summary type. All values will have the same series type. The different types are:

    • Normal Bar

    • Full Stack Bar

    • Line

    • Area

  • Point labels - display labels with the values on the graph.

  • Show For Zeros- If this option is selected, labels will also be displayed if the value is zero.

• Axis Options -

  • Title - The title of the axis.

  • Show Axis - If this option is selected, the axis will be shown as part of the graph.

  • Auto Scale - This feature allows the Y-axis to begin at the lowest value in the graph, rather than always starting at 0, making it easier to identify trends. All types of series will support this feature, except “Full Stack Bar”, where values always range from 0-100%.

Filter

The “Filter” can be used to filter out records (rows from the report the

dashboard is based on), only for the specific data item. The filter will have predefined options based on the chosen field type:

• Numeric - equal to, not equal to, greater than, less than, between

• Textual - contains, not contains, starts with, end with.

The conditions can be concatenated by And, Or functions

Optional filters:

• Days Before Today - In reference to the day the report is executed, if the value in the filter is zero, only results for that day will be displayed (from 00:00).

• Days Before Report End - According to the range in which the report is conducted (for example, 1.10.2023 - 30.10.2023), if the filter value is zero, only the day before the final day (29.10.2023) will be displayed.

• Days After Report Start - Considering the range in which the report is performed (1.10.2023 - 30.10.2023), if the value in the filter is zero, only the results for the first day (1.10.2023) from 00:00 to 23:59 will be displayed.

Colors

Using the colors tool, you can select a different color for a different value to emphasize the difference between them.

Chart Options

• Delete/Duplicate

• Add Info

• Rotate - if this option is the selected, the graph will be rotated (x and y

• axis's change positions).

• Show legend - if this option is the selected, the graph's legend will be displayed

• .

• Filter Options - The 'Master Filter' feature enables dashboard elements, such as charts segments, to act as primary filters. This functionality allows users to filter the entire dashboard with a simple click on any chart part, enhancing interaction by enabling seamless drill-downs and deeper data exploration.
  
  This functionality is available in both the “Dashboard Designer” and the 'Analytics Mode' of the Panorama application.

https://galooli.atlassian.net/wiki/spaces/KP/pages/2906718294/Analytics+Mode#Master-Filter