Hi,
I have created a dashboard showing all invoices by country name to analise the revenue per country.
I want to run the report as part of a month end procedure, so I will need to create a date fields to act as a 'to' date.
It is working well and I can select an Invoice Date >= x to filter the results e.g from the 1st day of the month. This one will work as my 'from' date.
The difficulty I am having is creating an input box on the tracker for a 'to' date.
I know I can use a filter, but only if I go in as a developer. The person who runs this report will not be a developer and it will be a nuisance to keep getting a developer to change the filter.
If I run the report eg today but want to see the figures for only May, I need some from and to dates.
Does anyone have any advise on how I can create a 'to' date?
Cheers,
CHRIS THOMPSON
[Non-text portions of this message have been removed]
I have created a dashboard showing all invoices by country name to analise the revenue per country.
I want to run the report as part of a month end procedure, so I will need to create a date fields to act as a 'to' date.
It is working well and I can select an Invoice Date >= x to filter the results e.g from the 1st day of the month. This one will work as my 'from' date.
The difficulty I am having is creating an input box on the tracker for a 'to' date.
I know I can use a filter, but only if I go in as a developer. The person who runs this report will not be a developer and it will be a nuisance to keep getting a developer to change the filter.
If I run the report eg today but want to see the figures for only May, I need some from and to dates.
Does anyone have any advise on how I can create a 'to' date?
Cheers,
CHRIS THOMPSON
[Non-text portions of this message have been removed]