The only thing it is doing, showing the exact values as on the entry date.
Then when I do a joined list, I get more than 30 items joined in one list.
Or is there a way to limit it to only 7 items? (I did not see that option)
Maybe my math column is wrong?
In there I had put for Configuration; now-6
Replace “now” with “Date” (this is the entry date)
So in that column, I see the date from 6 days before the entry date.
In the if then column I have;
If date is on or after (new column) then Weight value
Where the New Column has the date from 6 days before the date of entry.
Yes, it is wrong
You should replace Now with the special “Now” value. So the end result will be that every row contains the date from 7 days before today.
Now I am lost
I also tried it with Date and it shows the same results.
(Date is the date field that contains the date of entry)
What is the special “Now” value?
Thank you so much
I never had seen that special “Now”
Only after watching the video, did I saw it. I completely missed it.
This is indeed less complex.
This will work very well with the other charts I would like to make.
One of them had two Y axes and that would be a lot of work.
This shows to me again, how little I know and how much I still need to learn.
I just hope that people don’t mind that I am asking so many (simple) questions.
Thanks for your time and effort.