Concatenate lines in the display according to a date variable

Obsyky — Fri, 02 Jun 2023 12:04:43 GMT

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:

NAME	WEIGHT (currently)	WEIGHT (10/20/2022)
AA01	5000	-
AA01	-	3000
AA01	-	-

Do you have any ideas on how I can do this?

Thank you for your help!

topic Concatenate lines in the display according to a date variable in App Development

Concatenate lines in the display according to a date variable