Hi frnds,
I have a requirement like where Daily some hundreds of service tickets will be generated in CRM sysytem. we are loading data daily in to BI system. In My report I need to display the number of service tickets generated till yester day and also the number of service tickets generated today.
I have to use a variable for From and To date in between these From and To dates How many service tickets are generated and I have to calculate the number of tickets created till one day before the To date value and the number of tickets created on To date value
Here My question is how can I calculate the number tickets created on those two days?