Forum Discussion
Add to a table previous days values
Hallo,
How would it possible to creat such a table with an automatic shift of the days depening on the filter chose.
The filter is only for one date, then the table has to show the day and four days before.
| Value | Fri 17/01 | Mon 20/01 | Tue 21/01 | Wed 22/01 | Thu 23/01 | |
| A | 0.9 t | 0.0 t | 0.4 t | 0.5 t | 0.9 t | |
| B | 0.5 t | 0.0 t | 0.0 t | 0.2 t | 0.6 t | |
| C | 0.6 t | 0.0 t | 0.0 t | 0.5 t | 0.7 t | |
| D | 6.0 t | 0.0 t | 0.2 t | 5.0 t | 7.7 t | |
| E | 0.0 t | 0.0 t | 0.0 t | 0.0 t | 0.0 t | |
| F | 1.1 t | 0.0 t | 0.0 t | 0.5 t | 1.1 t | |
| G | 16.4 t | 0.0 t | 0.0 t | 14.3 t | 16.1 t | |
| H | 0.0 t | 0.4 t | 0.0 t | 0.0 t | 1.1 t | |
| I | 0.0 t | 0.0 t | 0.0 t | 0.0 t | 5.3 t | |
| J | 0.0 t | 0.0 t | 0.0 t | 0.0 t | 15.1 t |
- So, that should be something like:
Column = IF([Date] < (TODAY() - 5),FALSE(),TRUE())
6 Replies
Is this final data format. Can you please explain with an example.
I need to creat a column simmilar to the one in the picture to have a true or false values. If the date was in the last 5 days then True if not then False.
Tough to say but generally you would want to unpivot those date columns.
I need to creat a column simmilar to the one in the picture to have a true or false values. If the date was in the last 5 days then True if not then False.
- So, that should be something like:
Column = IF([Date] < (TODAY() - 5),FALSE(),TRUE())
