In an expression, find a specific record in a table

[juancaneu]

Hi!

In a chart expression, I want to get a specific record in a table.

The table contains two fields: [date], [value].

Example:  2016-11-12, 120

                2016-11-13, 145

                2016-11,14, 208

Using today's date, I want to get the corresponding value in the table. (If today is 2016-11-13, I want to get the value 145.

Thank you in advance for your help.

[Nicole-Smith · Accepted solution]

You can use an expression like this:

sum({<date={'$(=today())'}>}value)

I've also attached an example file.

[juancaneu]

Nicole:

Thank you for your precise and quick answer. I wish you a nice week!