MTD

[#1]

Hi All

Submited By	False Alert	=[Sam Ref Id]
1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#	L2/L3 Approved	SAM123102286552
1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#	L2/L3 Approved	SAM123102286573
1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#	Auto Approved	SAM123102286683
1163317: palanikumar raman - 05/03/2015 08:47:23 PM#	L2/L3 Approved	SAM529106947601
1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#	L2/L3 Approved	SAM123102289503
1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#	L2/L3 Approved	SAM123102293281
1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#	L2/L3 Approved	SAM123102303422
1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#	L2/L3 Approved	SAM123102303474
1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#	L2/L3 Approved	SAM123102304200
1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#	L2/L3 Approved	SAM123102327431
1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#	L2/L3 Approved	SAM124102328599
1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#		SAM123102331772
1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#	L2/L3 Approved	SAM124102343668
1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#	L2/L3 Approved	SAM123102348301

Need to find the distinct Sam Ref Id for the MTD of Max Month and MTD of  Previous Month where false Alert not equal to Auto Approved.

In the above example April all data and March excluding 25th and 26th

[rubenmarin]

Hi Senthil, please check attachment (script and text boxes). Hope this helps!

[florentina_doga]

hope this help?

i use a variable dataref.

[#4]

Hi

Thanks for your help.

If i select any month , the Previous Month value is not displayed.

Can you help me out on this

[rubenmarin · Accepted solution]

Hi, You can ignore Month selections in set analisys:

Count(DISTINCT {<Date={'>=$(=MonthStart(AddMonths(Max(Date), -1)))<=$(=Date(AddMonths(Max(Date), -1)))'}, Month>}  [Sam Ref Id])

Change the bolded 'Month' to the name of your month field, maybe you want to ignore other selections like quarter, year...