Mar 08, 2020 09:10 PM
Hi there. I’m trying to set up a graph that would only show the transactions that have closed up to the day but within the current month only so MTD.
I’d also like to be able to set up a graph that would show Year to Date or YTD for transactions that have closed from Jan 1st of the given year or this year.
Thanks in advance!
Troy
Mar 09, 2020 10:36 PM
Hi @Troy_Gamble,
I have the following suggestions:
Create a new View with a filter that contains the argument you want (for example Transaction Date is after March 01, 2020)
Create a Chart Block using this view. This will hide the items that are not in the filter.
For the Year to date, instead of March 1, use January 1.
Hope this is what you are looking for.
BR,
Mo
Mar 10, 2020 10:13 PM
Thanks so much for the reply. The issue I have is that I’m not seeing the option to set the argument for an “after this date” in the drop down of the filter?
Mar 10, 2020 10:25 PM
Hi @Troy_Gamble,
The option is in the “is” drop down menu not in the “exact date” drop down menu.
BR,
Mo
Mar 10, 2020 11:00 PM
Oh……genius! Thank you!