expression query

[didierodayo]

Hi ,

I have the expression below and would like to understand the where condition (date=,). What is the return when there is nothing in front of the equal sign. also could this expression be written differently?

Sum({$<Date=,[ADDRESS]={HOME},STREET={LEVIS}>} If(Movedate=Date,[Rentpay]))

Thanks for your help.

D

[sunny_talwar · Accepted solution]

date = means that the expression should ignore any selection in date field. What's the reason to re-write the expression? is this not working or slow? Are you trying to get rid of the if statement?

[didierodayo]

Thanks Sunny, Yes the chart is quite slow so I am trying to see if there is a better way of writing the same.

[sunny_talwar]

‌I think you might be looking to remove the if statement. Is movedate and date both fields? Are you able to share a sample to show how the data looks like?

[didierodayo]

Date and Movedate are not always the same. sorry I don't have a sample data atm. the outcome is on a line chart. Thanks

[sunny_talwar]

Dummy data which is close to how your actual data looks