Pivot table doesn't match line chart

[cbaqir]

In the example in this image, I would expect to see the line chart show one ticket submitted for 12/10 and one for  1/07, just like in the pivot table. What am I missing?

Dimension: =aggr(max( {$<COM_CAT={'ART - Agenda'}>}WeekStart(COM_CAT_START_DATE)),COM_CAT_START_DATE)

[sunny_talwar · Accepted solution]

May be you forgot to add this to your expression

=sum(if(aggr(count({$<COM_CAT={'ART - Agenda'}>}COM_CAT),DEFECT_ID,COM_CAT_START_DATE)>=1,1))

[MindaugasBacius]

I have simple cloned the Pivot table and instead of Pivot table changed to Line chart.

Also removed one of the expression and the result is:

[cbaqir]

I need both expressions.

[cbaqir]

How would I get the 100% to show on the 2nd occurrence since the first time it came through it wasn't a repeat?