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; } } }

Suppressing duplicate values on charts

rafaruiz123

Hi,
 
I have a set of records with ids and an average of time.
 
Average of time was built with the expression builder to calculate difference between dates to see how long it took and then creating another aggregation which averages them out.
 
The problem is that all my ids have the same number on the average and my Id are duplicates because there is history with these records.
 
I want to show the Id only 1 time on chart and show the average of age for that Id but I get the id multiple times. In the table you can do a suppress duplicate values but I cant find it on the CHARTs.
 
Example
 
Id Average
 
100 11
100 11
100 11
103 11
103 11
 
 
 
Any thoughts?
 
Thank you so much,
RR

Find more posts tagged with

Comments

Clement Wong

Without reviewing your design or running a sample that replicates this, I would suggest that you enable Grouping in the Edit Chart dialog > Select Data > Category (X) Series > right most icon > check Grouping and change Function from Sum to Average.

rafaruiz123

If a am using data from a table, that grouping function is greyed out.
What should I do In that case?
 
Thank you for your post and time.

pricher

Hi,
 
If you use data from a table, the grouping function in the chart is disabled because it expects to use the grouping defined at the table level. In the attached example, the table has a group level defined on CUSTOMERNUMBER and an aggregation defined as the AVG of QUANTITY by CUSTOMERNUMBER. The chart uses the table (MyTable) as a data source. The Category (X-Axis) is defined as the grouping level from the table, and the Value (Y) Series is the Aggregation.
 
Hope this helps,
 
P.

rafaruiz123

Pierre, I took your example and implemented the average you used It is much simpler and used the group on the x axis.
 
It works great. Very happy, thank you very much.