I am looking in to past snapshots of data. We have a weekly refresh. My requirement is to find the count of all the items those were in Pending stage between this date range 05/24/2010 to 06/27/2010 has now( as of today) converted to 'Design In' or 'Design Win' Stage. DW_LOAD_DATE is the date field that is used
to store the snapshot every week.
I have attached the screenshot of the table box where it correctly shows whats happening, but when I use the following syntax it yields zero.
Count(if(DW_LOAD_DATE>='05/24/2010' AND DW_LOAD_DATE<=06/27/2010 AND LINE_ITEM_STATUS='Pending',
if(U_LINE_ITEM_STATUS='Design In' or U_LINE_ITEM_STATUS='Design Win', OPP_ITEM)))
Could you please help me in finding where's the mistake is?
I have also attached the excel file exported from the QV app.