Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to sum value in 30 days left from register date in each ID,
so i have data field "ID" and "RegisterDate" in table of customer, and i have transaction of each customers paid on during days. I use on this expression "Sum({<Date={"<=$(=AddMonths(RegDate,1))"}>}PayAmount)" , that expression return "0" ,but when i select in only 1 ID that can return in right sum value.
could you please help me for new expression for return result set on "No selection"
Expressions are evaluated only once per chart and not once per row,
basically you cannot have a different formula for each row in your table, Since each of your IDs have a different start and end date, this is not possible
You will have to create a new field in your datamodel table to flag the last 30 days for each ID and then use the flag field in your calculations