nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add other aggregate fields to chart that are not present on y axis?

Arif shah

Hi,
 
On x axis, I have months and on y axis, I have sale. I wanted add the number of units sold to the tooltip (along with sale amount)
 
To do this, I open the the chart data binding, and added an aggregation field, and created aggregation for units sold. Then I added this to the tooltip of Y series values. I also added the aggregation for sale amount
 
What I have found is that If I put my mouse over a month bar, the tooltip shows units sold and sale amount for all months rather than for that specific month
 
My question is how is the aggregation grouped by months so that if I put the mouse on a bar, it only shows sale and units for that month only. I am not sure how the grouping works for aggregation
 
When I was creating the aggregation, the group was disabled and only list was selectable as can be seen in the below image
 
Arif

Find more posts tagged with

Comments

pricher

Hi,
 
The easiest way is to create your aggregations in a table, embed your chart in the table footer, and bind your chart to the data container. You will then be able to create tooltips that use aggregations created at the table level. See attached example.
 
Hope this helps,
 
P.

Arif shah

Hi,
 
Many thanks for the tip. two more question.
 
1) If I want to add the same aggregation (that is being used by the chart y series), do I still have to do it through table or can I add it by simply adding the field to the tooltip
 
For example, If my y series is using sum(budget), do I have to add row["budget"] to the tooltip because I cannot find any function for aggregation in tooltip. I actually want to edit the text of tooltip so I would like to show something like "The budget amount is: " row["budget"]. However this expression shows a value that is much less than what is being plotted on the bars
 
2) How do I format the number of the default tooltip data label...(I am not editing the tooltip text/expression of the Y values series)

pricher

1: You cannot add an aggregation at the tooltip level. That's why it is preferable to create your aggregations at the table level and reuse them in the chart.
 
2: To format the aggregation value in the tooltip, use the BIRT Formatter function, such as:
Formatter.format(row["Sales"],"#,##0.00")
 
P.

Arif shah

If I do not want to edit the tooltip and let the chart shows its default label, how do I format that label? I tried to edit the Y values series expression Formatter.format(row["Sales"],"$#,##0.00") the tooltip is still not showing the $
 
Arif

pricher

Strange... Formatter with the $ sign works well for me. Resending an updated rptdesign.
 
P.

Arif shah

Hi,
 
I have tried to create a group in a table and then in the footer I have dragged a chart. I have used the container dataset but the table group is not appearing in the list of chart. Can you please explain how to use the table/container group in the chart that is inside the table
 
Arif

Arif shah

Also, If I have a table with EmployeeName, Month and leaves count. I want the months on x axis, names on grouping/legends and leavescounts on y axis
 
I created two groups, One for employees and one for months and I want the leaves count to be grouped by both employees and months, how can I create this grouping so that I can use it in the chart?
 
Arif

pricher

Hi,
 
1. If you choose "Inherit Columns and Groups" in the Select Data tab of the chart wizard, the groups you have defined at the table level will appear. The example I had already posted is set up this way.
 
2. The type of chart you describe in your last post is better done by letting the chart engine create the groupings on Month (Category X Series) and Employee Name (Optional Y Series Grouping)
 
P.

Arif shah

If I do the grouping through chart and not use table grouping, It gives me the correct chart. On x axis, I have months, Option Y grouping has EmployeeName and on Y axis is the count of leaves. This gives me the correct chart. The problem is that I want to edit the tool tip and show EmployeeName, Month and Y value in the tooltip of a point. I cannot sumup the leaves in the tooltip unless I have a count of leaves grouped by Month, EmployeeName etc
 
Arif