Chart & Graph differences

[#1]

Dear Community,

I'm trying to create a combo graph with a bar and line graph but something strange is happening. If I display my information as a chart I get the below table:

But when I put this into a graph I get this:

The expression causing me issues is below:

=sum(aggr(max(if(DateClosed>=addmonths(vStartDate,-11) AND DateClosed<=vEndDate,LineQty)),ShipmentId))

If you hover over that line it shows different data points but they aren't correlating to the dimension

=MonthName(floor(DateClosed))

Any ideas?

[sunny_talwar]

Would you be able to share a sample?

[marcus_sommer]

Your aggr included not the dimension from chart. This wouldn't work in your case because it's a calculated dimension - suggestion here is to create all needed period-fields within a master-calendar: How to use - Master-Calendar and Date-Values - further noticeable is that you used floor for your DateClosed which indicates that it is timestamp, to compare dates with timestamps is possible but unnecessary error-prone.

- Marcus