Ok Marcus, it seems to work.
The problem is that i have to select the ReceptionDate in a filter to receive one result.
Could i obtain the Total Orders of all dates that are equal?
When ReceptionDate is 01/02/2016 and IssueDate is 01/02/2016 are 50 Orders,
When ReceptionDate is 02/02/2016 and IssueDate is 02/02/2016 are 20 Orders,
When ReceptionDate is 03/02/2016 and IssueDate is 03/02/2016 are 30 Orders.
I need to obtain 100 orders in my indicator, and with your expressions i have obtained 50 if i select 01/02/2016, 20 if i select 02/02/2016 and 30 if i select 03/02/2016.
Thanks for all!
Without knowing your datamodel it's difficult to say what to do to get a certain result. The first expression:
will only work for a certain selected date then $-sign expansion within the set analysis will be only evaluated once globally for the whole chart and then applied for each row.
The second expression:
instead worked on a row-level and might work in your case but it's depending on your datamodel.