What are the different chart-type and metric-type reports in TRIRIGA?


In TRIRIGA, I can see only 4 main types of chart reports: (1) pie, (2) bar, (3) lined, and (4) stacked bar, and these are two-dimensional. Are there any other chart type reports apart from these? And how can we report on multi-dimensional (more than two-dimensional) chart reports?

TRIRIGA ships with the following chart types in the table below. TRIRIGA also integrates with the BIRT and Crystal Reports engines, which have very robust reporting options. Note that as of the TRIRIGA 3.5.0 platform, anything that says “linear gauge”, will render as a circular gauge.

Name/Description Type
3D Doughnut Pie
3D Pie Pie
Bubble Bubble
Circular Bar Gauge Circular Gauge
Circular Gauge Circular Gauge
Doughnut Pie
Horizontal Grouped Bar (%) Bar (%)
Horizontal Grouped Bar Bar
Horizontal Linear Bar Gauge Linear Gauge
Horizontal Linear Tank Gauge Linear Gauge
Horizontal Stacked Bar Bar
Line/Vertical Grouped Bar Combo Line-Bar Combo
Line/Vertical Stacked Bar Combo Line-Bar Combo
Line Line
Pie Pie
Pyramid Pyramid
Spline Line
Vertical Grouped Bar (%) Bar (%)
Vertical Grouped Bar Bar
Vertical Linear Bar Gauge Linear Gauge
Vertical Linear Tank Gauge Linear Gauge
Vertical Stacked Bar Bar
Circular Bar Gauge (%) Circular Gauge (%)
Circular Gauge (%) Circular Gauge (%)
Horizontal Linear Bar Gauge (%) Linear Gauge (%)
Horizontal Linear Tank Gauge (%) Linear Gauge (%)
Vertical Linear Bar Gauge (%) Linear Gauge (%)
Vertical Linear Tank Gauge (%) Linear Gauge (%)

[Admin: The “Metric” type offers more options in addition to the “Chart” type. This post is related to the 04.17.17 post and 03.04.16 post about displaying a stacked bar chart, and the 04.05.17 post about displaying a mix of bars and stacked bars.]

Continue reading

IV97411: Adjusting task status on Gantt not working uniformly


Adjusting the task status on a Gantt chart with Ctrl/Cmd+click is not working uniformly across client operating systems.

We needed to disable the Ctrl+left/right-click and Shift+left/right-click, which are not working consistently across browsers and Mac, and reintroduce the right-click > “Set Percentage Complete” to the right-click menu. We also needed to update the “Percent Complete” message to be shorter, and update the message minimum width to be wider.

Moving forward, we removed the ability to set the percentage complete by using Ctrl+click, which does not work correctly on all browsers on all operating systems, replacing it with the ability to “Set Percentage Complete” by using the right-click context menu when right-clicking a Gantt task.

[Admin: To see other related posts, use the Gantt tag.]

Continue reading

IV97310: Pie chart labels are cut off in smallest portal section


The pie chart labels should actually be hidden, and not appear at all for the smallest portal section. Users should rely on tooltips for the smallest portal section. The reason labels were always meant to be hidden is because they make many pie charts unusable in the smallest portal section, due to labels bunching together in the small space. The smallest portal section should always hide the pie chart labels.

The hiding of the pie labels for the smallest portal section broke when AnyChart was upgraded in TRIRIGA 3.5.0. Moving forward, we resolved a metric report and chart report issue, where pie chart labels were chopped off in the smallest portal section. This fix hides pie chart labels when the TRIRIGA component that displays the chart falls below a height of 280px and a width of 280px, such as the smallest portal section. Pie labels become unusable when pie charts get too small. So users should rely on pie chart tooltips for the chart details, when the labels are hidden.

[Admin: This post is related to the 04.14.16 post about changing the AnyChart label settings. To see other related posts, search “Pie Chart“.]

Continue reading

Why doesn’t the new Gantt chart show all of the tasks from query?


We are having some issues with the new Gantt chart, in that it is not displaying all of our tasks. We are using the same query on the Gantt chart as in the associated Tasks section below. However, while all of our tasks are displayed in the Tasks query section, they are not all displayed on the Gantt. Is there some other criteria that the Gantt is using in the background to determine which records it displays?

[Admin: The same question is also posted in the TRIRIGA Around the World Facebook group. To see other related posts, use the Gantt tag.]

Continue reading

Is there a way to modify columns of popup report in metric report?


I am wondering if it is possible to modify the columns of the popup report, when we click on the graph of a metric report. It would seem the popup report doesn’t exist “physically” in the TRIRIGA database, rather it seems hard-coded and created on-the-fly when we click on the graph, reusing the existing graph data. Could anyone verify this assumption?

You are able to control the display columns on the report that is opened when clicking on the chart, just as you would a normal (i.e. non-chart) report in TRIRIGA. So from your chart details on the General tab > Options sub-tab, then on the Columns tab > Display Columns sub-tab, you can select fields, order, and change the default label to how you would like it presented when clicking into the chart.

[Admin: To see other related posts, use the Metric tag.]

Continue reading

IV95291: Pie chart shows incorrect data with one filter of one record


This issue happens when you create a simple chart report, of “Pie Chart” type, which displays all employees grouped by status. This in itself works fine. However, the user then adds a filter on Status = “Active User”. Now, instead of displaying a pie chart with a full 100% view of all “Active User” employee records, the chart says “No data to display”. If a second status is added to filter the chart, it displays as expected.

An issue with chart displaying data when filtered to a single record set. The issue is that the chart type reports GraphDataSource “hasData” method had a check of the “currentItem” value when the data size is equal to 1. However, “currentItem” is always null at the point when “hasData” is called, causing the method to return false.

The “currentItem” check is an artifact from before the AnyChart 7 upgrade. The fix is to modify the “hasData” check to go directly at the data when the data size is 1, instead of using “currentItem”. Moving forward, we resolved a chart type report issue, where charts having only one data result indicated that no data was found.

Continue reading

How do you display a stacked bar chart in TRIRIGA?


Does anyone have any extra documentation on chart queries? The user guide is terrible. It just says to pick a chart. I know the bar charts follow the first thing you “Group By”. But I am not sure what to do with stacked bar charts, and I’m thinking that’s the view my customer needs. I’m curious what the setup on the query needs to be for the stacked bar option.

You need to use the “Metric” option for the type, instead of “Chart”. Also, if you are on TRIRIGA 3.5.1, there is an existing issue with stacked bar charts, where sometimes the bars display incorrectly.

[Admin: This post is related to the 04.05.17 post about displaying a mix of bars and stacked bars, and the 03.04.16 post about displaying a stacked bar chart.]

Continue reading