Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Month report in arrears
Migrateduser
<p>Hi all</p>
<p>Ok I'm sure this will be easy for you experts...</p>
<p>How do I report on data that only covers 'last month'?</p>
<p>What I'd like to do is report on all data between eg 1 July and 31 July. Then of course it'd report data from 1 August to 31 August.</p>
<p>I will run this automatically via Open Objects on the 1st of each month, so it would simply run July on Aug 1 and so on. Essentially I want to filter out all data apart from the last full calendar month.</p>
<p> </p>
<p>For Info the report would look similar to below:</p>
<p> </p>
<p><strong><span style="font-size:14pt;"><span style="font-family:calibri;">Contact Subject Direction Medium User No. of contacts</span></span></strong></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">Sales Incoming Call SR 5</span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">Sales Incoming E-mail TW 4</span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">Sales Incoming E-mail BG 7</span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">Sales Outgoing E-mail FC 6</span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;"> </span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">At the bottom I'll add sub totals for each subject and a grand total but I'm ok with that.</span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;">Thanks </span></span></p>
<p><span style="font-size:medium;"><span style="font-family:calibri;"> </span></span></p>
Find more posts tagged with
Comments
There are no comments yet