Hello all,
I've got a group of dates to count how many referrals we have. This is the basic count: I want to create the following:
My issue is, no matter what I try I cannot seem to post the previous month that works well with the filter options. Some things I've tried:
Nothing seems to be able to beat the filter. Is it possible to showcase last months results with a current filter?
Hi -
Yes the whole purpose of the LODs in that post is to return a single value with the total - you are running into problems using filters - do not filter the data - use a parameter or 2 to allow the user to select a date - see https://jimdehner.com/2022/07/05/parameters-how-tos/ on parameters - once you have that parameter date you can look at the ytd total - or use it to get the prior ytd (or month etc) -
now you can not connect 2 data fields - they are 2 entirely independent - if you need a single data (like a calendar) the you need to add a data scaffold - see https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/ -
But I am not certain you will need that if you get the lods straightened out
