I am attempting to create a chart like page 2 of this spreadsheet enclosed. I chose the default measure as weekly_total. This variable has the following parameters
aggregate dataitem=lock expiration date
aggregate method=total
The primary axes is total_recvd and total_not_recvd
The x axis is lock_expiration_date
When I run the chart I created I get the error unable to build aggregate dataitem=weekly_total. referenced dataitem = lock_expiration_date not found in nesting level
I don't think using the aggregate data item as the default measure is necessary. You can use your received and not received measures as the series since they will aggregate by week anyway because you having week on the x-axis.