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!
