Concatenate lines in the display according to a date variable
Hello,
I need to be able to concatenate lines in the visualization according to a date variable.
This is what the table looks like in the data model :
NAME
DATE_START
DATE_END
WEIGHT
...
AA01
04/15/2023
12/31/2099
5000
...
AA01
01/12/2023
04/15/2023
5000
...
AA01
11/24/2022
01/12/2023
5000
...
AA01
06/21/2022
11/24/2022
3000
...
...
...
...
...
...
When the end date is "12/31/2099", this means that the line is currently valid.
I have an insert where people can enter a date, according to this date it should display the weight to today (so DATE_FIN = '12/31/2099') in the first column, and in the second the weight to the date entered.
For example, if I enter '10/20/2022', the result would look like this:
NAME
WEIGHT (currently)
WEIGHT (10/20/2022)
AA01
5000
3000
If I enter '12/20/2022' :
NAME
WEIGHT (currently)
WEIGHT (02/20/2023)
AA01
5000
5000
currently, I've gone like this: - WEIGHT (currently) : "=If(DATE_END = '12/31/2099',WEIGHT)" - WEIGHT (date) : "=If(DATE_END >= '$(vDATEWeight)' and DATE_START <='$(vDATEWeight)',Weight)" but I get a table this way: