Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use an expression like this:
sum({<date={'$(=today())'}>}value)
I've also attached an example file.
You can use an expression like this:
sum({<date={'$(=today())'}>}value)
I've also attached an example file.
Nicole:
Thank you for your precise and quick answer. I wish you a nice week!