Filtering data using date report parameter

[James]

My report pulls 6 months, on the first to the last day for each month, of data from the past using a data picker and will use all 6 for one of the graphs, but I also want to use only the last full month of data for all of the rest of the graphs so I need to filter the 6 months to get that data.  I am trying to filter only the data for the last month using the date from the parameter but for this I will need the date parts because I want from the first day of the month to the last day of the month.  Can someone please give me an idea how I can do this?

ie.

Date Picker chooses 3/5/2019 meaning getting data for all days in each month of Oct, Nov, Dec, Jan, Feb, Mar

One report uses all 6 months

All other reports use only data from March

Any help would be greatly appreciated.

[Neli]

Hello James,

The attached report demonstrated the following approach: 
A CSV data source which contains dates from October 2018 to March 2019 is used. The Report Parameter is DateTime.
The Graph displays only the data for the month of the selected date. The following filter should be added for this purpose to the Graph :

Expression: =Fields.Date.Month
Operator: =
Value: = Parameters.DateParameter.Value.Month

More information for Graph filtering can be found at How to: Add filtering to Graph item article.

Regards,
Neli
Progress Telerik