Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
Hi Senthil, please check attachment (script and text boxes). Hope this helps!
hope this help?
i use a variable dataref.
Hi
Thanks for your help.
If i select any month , the Previous Month value is not displayed.
Can you help me out on this
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...