Hello folks.
Iโd like some help here.
To keep it short.
I have a Table called Feed. It displays a list of daily entries going back 2 years
This table has a โDateโ field for the day an entry was created
It also has a โMonthโ field, for the month the entry was created
Lastly, it has a "Yearโ field for the year the entry was created.
I created a bar chart that I want to display all entries from only the previous 3 months (the current month and the last 2) to review recent activity.
This is the expression I created for it.
OR(
AND(([Date] > TODAY() - 90), ((MONTH([Date])) > (MONTH(TODAY()) - 3))),
AND(([Date] > TODAY() - 90), ((YEAR([Date])) >= (YEAR(TODAY())-1)))
)
This is the result.
The January, November, and December bars are desired, the October one is not. Itโs a bit difficult for me to figure out. Can someone please assist?
(Please do not suggest an expression about just counting the previous 90 days, as that can cut off some entries from the oldest month. I need to be able to see ALL the entries from the oldest month).
Thanks for any help.
Solved! Go to Solution.
Thanks @Steve
I needed the last 3 months, not the next 3, so i just usedโฆ
[Date] > EOMONTH((TODAY()), -3)
worked like a charm, thanks!
Side question: Is there any way to short the bar graphs from left to right by date (instead of by alphabetical order)? Thatโs been particularly frustrating for me.
Thanks @Steve
I needed the last 3 months, not the next 3, so i just usedโฆ
[Date] > EOMONTH((TODAY()), -3)
worked like a charm, thanks!
Side question: Is there any way to short the bar graphs from left to right by date (instead of by alphabetical order)? Thatโs been particularly frustrating for me.
I donโt work with graphs much, so I canโt answer from experience. My guess is no, itโs always alphabetical, so youโd have to (re)name your columns so they sort as desired.
Disappointing, but fair enough. I can find a way to work around that. Thatโs all I need for now. Thanks again for the help!
Hi Im actually trying to solve for the last 90 days if some one could assist that would be great
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |