Show Latest Month Data

[ashishpalkar]

Hi There

I have below requirement, where I want to show latest month data from given set of data, From below example I want to show only May Data in the graph / Table by default without selecting any parameters on the QV application.

Date	Project	Associate
1/1/2015	ABC	1
1/2/2015	ABC	2
1/3/2015	ABC	3
1/4/2015	ABC	4
1/5/2015	ABC	5
1/6/2015	ABC	6
1/7/2015	XYZ	7
1/8/2015	XYZ	8
1/9/2015	XYZ	9
1/10/2015	XYZ	10
1/11/2015	XYZ	11
1/12/2015	XYZ	12
2/1/2015	ABC	1
2/2/2015	ABC	2
2/3/2015	ABC	3
2/4/2015	ABC	4
2/5/2015	ABC	5
2/6/2015	ABC	6
2/7/2015	XYZ	7
2/8/2015	XYZ	8
2/9/2015	XYZ	9
2/10/2015	XYZ	10
2/11/2015	XYZ	11
2/12/2015	XYZ	12
5/1/2015	ABC	1
5/2/2015	ABC	2
5/3/2015	ABC	3
5/4/2015	ABC	4
5/5/2015	ABC	5
5/7/2015	XYZ	7
5/8/2015	XYZ	8
5/10/2015	XYZ	10
5/11/2015	XYZ	11

Thanks in advance.

[sunny_talwar]

It is attached with my previous post. Open this link: Re: Show Latest Month Data

Best,

Sunny

[ashishpalkar]

Thanks again. 

[sunny_talwar]

No problem

I would ask you to mark correct/helpful answers to close the thread if the problem is resolved

Best,

Sunny

[ashishpalkar]

One more twist in this, if the current month is June , it should only show June data. If there is no data in June it should display message as No data for June.

[sunny_talwar]

How did you determine if you want to see June? Is it always going to be June data you would want to see??

[ashishpalkar]

The current month is June and we have data for May.  In such situation it should only show June Data and show message "No Data available".

[sunny_talwar]

Please find attached

Expression:=Count({<Date = {"$(='>=' & Date(MonthStart(Today())))"}>}Associate)