Logi Info v23.1 Enhancements
This topic introduces the significant features of Logi Info in this release:
-
What's Fixed?
AG - Update Dashboard Panel Title
The Dashboard Panel Title now has the ability to update automatically according to edits that affect the Visualization Title. This feature is supported by the new application-level constant, rdUpdatePanelTitleWithChartCaption. By default, this constant is set to True.
When True, chart panels update the title upon selecting Save in the Edit Panel pop-up, as shown in the demo below:
If set to False, chart panels require manual updates to the title.
For more information, see Configuring InfoGo Constants, Managing Dashboard Panels, and Editing Visualizations.
AG/SSRM Value Quick Filter
When applying a filter, the list of available values now incorporates a "Quick Filter". The Value input field allows you to enter the value you want to apply to the filter, providing a simple and efficient way to access a specific value without searching through the list. As you begin typing, the list of available values narrows, as shown below:
To utilize this feature:
-
Change Filter Value Selection of columns to “List“ in Data Manager >Metadata Columns.
-
Add the following in the InfoGo Analysis Grid template modifier file (TMF):<InsertBeforeElement XPath="//Target[@Report='rdAfPickDistinct']" > <NewElement> <LinkParams rdAFValuesFilter="True" /> </NewElement> </InsertBeforeElement>
Upon selecting a Value from the list, the process of adding the filter remains the same.
For more information, see Analysis Grid - Filtering Rows and InfoGo - Filtering Rows.
AG/SSRM - Chart Drillthrough
Group Drillthrough is an existing feature in Data Tables and Charts that provides flexible interaction between data rows and columns that are members of a group. This release extends drillthrough capabilities to the Analysis Grid in SSRM. Once implemented, selecting a section of the chart, such as region, links to a detailed report of the data representing that region. Accompanying this feature is the new application-level constant, rdAGChartGroupDrillthrough. The default value is False. Setting this constant to True enables the drillthrough feature in the Analysis Grid.
The video below demonstrates the feature functionality upon configuring rdAGChartGroupDrillthrough:
There is no "Back" button in the table after using group drillthrough on an Analysis Chart in the Analysis Grid.
The following AG charts support this feature: Bar, Line, Curved Line, Pie, and Heatmap. Scatter Plot and Gauges are not supported.
For more information, see Configuring InfoGo Constants, Analysis Grid - Creating Charts and Gauges, and InfoGo - Creating Charts and Gauges.
AG/SSRM - Scheduling on Rapid Excel Export
You can now select the "Rapid" option for Excel output when scheduling an Analysis Grid report. When the constant rdShowExportDataPreference is set to True, selecting Excel as the Format in the Scheduler UI prompts a new option, "Export Data Preference". Choices include Formatted and Rapid. The default option is Formatted.
Upon selecting Rapid, the Analysis Grid table exports as Rapid Excel.
This feature is not available for exporting scheduled Dashboards or Author Reports.
For more information, see Analysis Grid Developers - Exporting Data and InfoGo - Reporting Scheduling Details.
AG/SSRM - midpointRounding Parameter
The Round function now includes a new parameter, midpointRounding. As a whole, the Round function controls the rounding process by specifying the strategy that mathematical rounding methods should use when rounding a number. The addition of this parameter allows you to return the round half-up result. This enhancement applies to both .NET and Java environments.
The midpointRounding value can be set to either 0 (default) or 1. If you do not set this parameter, the system returns round results with 0.
To utilize this function, select the Round(expression [, numdecimalplaces, midpointRounding]) option from the Formula drop-down:
Then, assign a name to your formula and input your values in the Formula text box.
Upon selecting Add, Info calculates the formula according to the parameters and updates the Data Table, as shown below:
Below is a list of the available values for the midpointRounding parameter:
| Value | Description | Comment |
|---|---|---|
| 0 | The strategy of rounding to the nearest number. When a number is halfway between two others, it's rounded toward the nearest even number. | Default value. |
| 1 | The strategy of rounding to the nearest number. When a number is halfway between two others, it's rounded toward the nearest even number. | |
| 2 | The strategy of directed rounding toward zero, with the result closest to and no greater in magnitude than the infinitely precise result. | Not supported by Logi Info |
| 3 | The strategy of directed rounding toward zero, with the result closest to and no greater in magnitude than the infinitely precise result. | |
| 4 | The strategy of directed rounding toward zero, with the result closest to and no greater in magnitude than the infinitely precise result. |
You cannot use midpointRounding when the Round formula uses an Active SQL AG/Table/Crosstab.
For more information, see Functions.
Store Log Files in Database
You can now store log information in a database, as opposed to the traditional logging system. This enhancement enables you to send a database query to observe specific log information and run statistics on the events or log behaviors. The attribute “LogsInDatabase“ controls whether the log is written to the database or file system. When set to True (case sensitive), the log records to the task database; otherwise, it will be written to the file system (current scheduler behavior).
To enable this capability, access the LogiXML Scheduler Service folder on your machine and open the _settings.lgx file.
In _settings.gx, change the existing attributes in WebRequest to LogsinDatabase="True", as shown below:
Upon adding this attribute, a table will be created in the existing available database. The default table name of the task log is “TaskHistory”. You are unable to change this name when using default databases Derby and VistaDB. For other databases, you can customize the table name using the attribute “Setting/Connection/@xxxHistory“, similar to setting the task table name.
To change the table name, go to the Connection element (shown in screenshot above) in the _settings log and add your own history table name. For example, "MySQLHistory" or "OracleHistory". Then, restart the scheduler.
Each database has a minimum number of columns; however, you can expand and add more tables/columns. If you already created one table (like "MySQLHistory"), the system will use that. If there is no table in the DB, the task log table generates automatically when the scheduler service starts.
For more information, see Communicating with the Scheduler.
Add Tooltip Outside Chart
This release introduces a new attribute, Toolitp Outside, for Chart Canvas and Gauge elements. Tooltip Outside controls whether the tooltip renders outside the chart's area. By default, this attribute is empty, or False. To enable this feature, set the attribute to True. This feature is beneficial when working with small charts, and can be used in conjunction with Tooltip Split to optimize space.
Tooltip Outside can be applied to the following chart types: ChartCanvas, Gauge.Angular, Gauge.Arc, Gauge.BalloonBar, Gauge.BulletBar, and Gauge.Number.
Gauge.Bar and Gauge.Angular do not include this capability.
Below is an example of a tooltip before this attribute is applied:
Below is an example of the chart after Tooltip Outside was applied:
For more information, see The Chart Canvas Element and Adding Tooltips.
Formatted Column with Rapid Excel Export
The Excel Format attribute now includes "Yes/No", "On/Off", and "True/False" values to enable formatting on the boolean column when exporting via Rapid Excel. Previously, when using rapid Excel export, any formatted column would result in an error prompt and resolve as a number in the Excel file, as shown below:
By default, the Excel Format attribute is empty, or False. To enable On/Off compatibility, set the value to On/Off:
To support Yes/No or True/False column formatting, set the value accordingly.
Below is an example of the exported file after the Excel format was applied:
This feature was already available for native Excel exports, this release extends the scope to include rapid Excel, as well. To review a detailed list of the differences between the native Excel and rapid Excel export, see Exporting To Native Excel.
For more information, see Rapid Excel Export.
PDF Export - Repeat Table Headers
You now have the option to display repeat table headers when exporting multiple tables to PDF. Currently, the table headers only display on the first page of results, causing you to scroll to the top of the results to identify the difference between datasets. Now, you can configure your application to display repeat table headers with PDF exports using the new constant, rdPdfMultiTableRepeatHeader. The default value for this constant is Empty/False. To enable, set this constant to True.
Once configured, the PDF will display the table headers on each page of the export, as shown below:
For more information, see Configuring InfoGo Constants.
Log4J Log Message Mapping
Th Log4J Log Message Mapping enhancement provides additional structure to the Debugger Trace Report, enabling you to better visualize the log information so that you can identify system issues quickly. In the previous version, the Event column displayed repeating columns with the same name, as shown below:
Now, similar Events are grouped using the new application level constant, rdLogFillLevelMessage. By default, the value for this constant is empty, or False.
Set this value to True to simplify the log information:
Below is an example of the resulting Debugger Trace Report:
For more information, see Configuring InfoGo Constants.
Chart Canvas Legend Filter Configuration
You now have the ability to disable Chart Canvas legend filtering while maintaining the display of a legend. Legend filtering allows you to show or hide corresponding chart content by selecting an item on the legend. The ChartCanvas element's new attribute, Disable Legend Filtering, allows you to disable this function on a chart-by-chart basis. The default value for this attribute is empty (False), the legend can be filtered. To disable, set this attribute to True. When set to True, the legend item and its corresponding data is always shown, unless you utilize the "Hide All" feature.
The demo below shows two charts: one with Disable Legend Filtering set to Default/False, and one with the attribute set to True:
For more information, please see The Chart Canvas Element and Legend Filtering.
Legend Show All Button Customization
The ChartCanvas Legend element includes three new attributes that allow you to customize the appearance of the of the Show All button.
-
Show All Inverted Caption: Sets fill color for default (disabled) Show All button state; the state when all series are visible. The default value is Show All.
-
Show All Inverted Marker Color: Sets text for inverted (enabled) Show All button state; the state when one or more series is hidden.
-
Show All Marker Color: Sets fill color for inverted (enabled) Show All button state; the state when one or more series is hidden.
The Show All Caption button must be enabled to set up these attributes.
In the example below, the Show All Inverted Caption attribute is set to "Show All", the Show All Inverted Marker Color is blue and the Show All Inverted Caption color is red:
For more information, see Legend Attributes.
High Chart Enhancements
Logi Info v23.1 leverages enhanced functionality of the latest high chart library, adding new elements, attributes, and modules to expose out-of-the-box options to customize charts' behavior. The enhancements listed below minimize the need to write custom code, reducing development effort and improving the maintainability of your custom analytics applications.
Chart Color Axis
Chart Canvas now offers a color axis for series charts. You have the option to display the axis as scalar or based on data classes. Scalar axes are represented by a gradient, ranging between Min Color and Max Color, as shown below:
On the other hand, Chart Color axes based on data classes are divided into separate classes based on their values.
To utilize this feature, add the Chart Color Axis child element to your Chart Canvas:
Series.Whiskers is the only series chart that does not support this feature.
The Chart Color Axis element includes the following attributes:
The ID is optional, but beneficial when using numerous color axes for a series (more details below). If the Max/Min Value attributes are not set, the extreme value of the color axis will be calculated automatically. If the Max Color/Min Color attributes are not set, the default color will be obtained according to the current theme. For Heatmaps, the attributes "Max Color" and "Min Color" will be ignored and replaced with "High Value Color" and "Low Value Color".
To support this feature, the Chart Canvas element also includes two new attributes, Linked to Color Axis ID and Color-Axis Data Column. The Linked to Color Axis ID attribute specifies the ID of a Y-Axis element that this series should be linked to when using multiple Y-axes. If you are using the Chart Color Axis element in a mult-series chart, by default, the series will link to the first color axis. To link the series to a special color axis, set the ID attribute of the Chart Color Axis element to the corresponding series' Linked to Color Axis ID attribute, as demonstrated below:
The Color-Axis Data Column specifies the name of a datalayer column whose values will be plotted along the x-axis. See example configuration below:
-
For Heatmaps, the "Color-Axis Data Column" of the series is ignored and replaced with "Heat Map Color Data Column" of the Heatmap series.
-
For other chart types, the series' Chart Color-Axis Data Column attribute must be the output column of the datalayer. If this value is not set, the column of "y" or "low" will be used.
For more information, see Chart Color Axis and The Chart Canvas Child Elements. Additionally, any Series.x - Attributes topic (e.g. Series.Bar - Attributes) or Series.x - Using Multiple Series topic (e.g. Series.Bar - Using Multiple Series) also include information regarding this enhancement.
Annotations Support
The annotations module allows you to annotate a chart freely using custom labels and shapes. Without the annotations module, the only way to render shapes or labels in any place on a chart was through Renderer API. Now, you can use the various Annotations elements to tie custom labels and shapes to points, axis coordinates, and pixel coordinates.
The table below details the new elements that support this feature:
| Element | Description | Child Element of | Notes |
|---|---|---|---|
| Series Annotation |
Enhance and customize the charts and annotate it with labels and shapes. They can be placed at various points of interest |
Series charts | Can refer to different datalayers or data sources. For more information, see any Series.x - Using the Series Annotation Element (e.g. Series.Bar - Using the Series Annotation Element) |
| Chart Annotation |
Enhance and customize the charts and annotate it with labels and shapes. They can be placed at various points of interest |
Canvas charts | Defined on a global level, cannot refer to different data sources. For more information, see The Chart Canvas Child Elements and Chart Annotation. |
|
Annotation |
Enhance and customize the charts and annotate it with labels and shapes. They can be placed at various points of interest |
Arc or legacy charts | Can be used with GaugeAngular, GaugeArc, GaugeBalloonBar, GaugeBulletBar, and GaugeNumber. For more information, see Gallery of Classic Chart and Gauge Elements and Working with Gauges. |
| AnnotationLabel.Point | Create an annotation label and position on the chart by linking it to an existing point | Series Annotation, Annotation | Cannot specify the value, it always refers to the value of the point. Use the Caption and Condition attributes to refer to different datalayers. |
| AnnotationLabel.Mock | Create an annotation label and position it on the chart by linking it to a created mock point | Chart Annotation, Series Annotation, and Annotation | Can specify the coordinate, relative position, and axis. |
The video below demonstrates the process for configuring a Series Annotation element with an AnnotationLabel.Point child element:
The video below demonstrates an AnnotationLabel.Mock child element being added to the same Series Annotation element:
Data Label Class Name
Data Label elements now include a "Class Name" attribute that applies unique styles to each series' or point's data label. Class Name empowers you to change the look and feel of your data label, without manually customizing the Data Label element; simply define different classes and reference them at runtime. The default value for the Class Name attribute is undefined.
To apply a class to the Gauge.Arc element, use the attribute "Label Class Name". Similarly, use the attribute "Balloon Label Class Name" to apply unique styling to your Gauge.BalloonBar's data labels. For more information, see Gallery of Classic Chart and Gauge Elements and Working with Gauges.
To utilize this feature, define a CSS file as the stylesheet reference in the report.
Define as many styles as you want by assigning different names in the stylesheet. The example below has three different styles: abc, abb, and aba.
Then, access your Gauge.Arc element and enter the class in the Class Name field. Or, choose a class using the class selector, as shown below:
The example below depicts the data label with the "abc" style applied:
Exported results also support this feature. Upon selecting Get Image, Export to PDF, Word, or Excel, your styles will persist in the destination.
The following series charts do not support this feature: Pie, Pyramid, Whiskers, Funnel, and Heatmap.
For more information, see any Series.x - Using the Data Labels Element topic (e.g. Series.Bar - Using the Data Labels Element).
Chart Custom Symbol
This enhancement allows developers to specify custom symbols for chart markers. Marker Points show the location of data points along line and area-style charts. The Marker Points element enables customization of Marker Point appearance, with its Symbol attribute specifying the symbol that identifies each data point on the chart. Prior to this enhancement, you could only choose from a predefined list of options for the Symbol attribute, which included Circle, Square, Diamond, Triangle, and Triangle-down. Now, you can use the new Chart Canvas child element, Chart Custom Symbol, to define your own symbol and utilize it in the Symbol attribute of the Marker Points element.
The Chart Custom Symbol element includes two attributes, SymbolKey and SymbolPath. Use the SymbolKey attribute to give your custom symbol a unique name, like "MySymbol". The SymbolPath attribute is a string representing the Scalable Vector Graphics (SVG) path, written with separate commands and parameters with commas. Parameters can be numerical values, or expressions with the variables x(x coordinator of plot area), y(y coordinator of plot area), w(graphic’s width), and h(graphics’s height). An example of a Symbol path could be: M, x, y, L, x+w, y+h, V, y+h*0.5, H ,x, L ,x, y.
The video below demonstrates the steps for defining a symbol key and path to pass a definition, linking the custom symbol to the Marker Point element, as well as the finished product:
The following series charts support this feature: Area, Bubble, Line, Scatter, Spline, and Area Spline.
For more information, see Chart Custom Symbol and The Chart Canvas Child Elements. Any Series.x - Using the Marker Points Element topic, such as Series.Bubble - Using the Marker Points Element, also includes information regarding this enhancement.
What's Fixed?
For more information on bug fixes, please see this page.
Comments
0 comments
Please sign in to leave a comment.