Can you adjust the scale of the bar chart?

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 :slightly_smiling_face:
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 :slightly_smiling_face:
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?

I need to go out now, but I will try to make some screenshots when I am back :slightly_smiling_face:

Here you go:

1 Like

Thank you so much :slightly_smiling_face:
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. :slightly_smiling_face:

3 Likes

Never be afraid to ask questions, it’s how we all learn :wink:

4 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.