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
One Month Per Page In Report?
Migrateduser
I have some data from my database:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT
dfdate as "Date",
dfunsv as "Unshipped Dollars",
FROM mstf
</pre>
<br />
The date is ascii in the form of 'yyyy/mm/dd'<br />
<br />
Basically, I want to show 3 columns per row.<br />
Date, Unshipped Dollars, Unshipped Dollars This Month To Date.<br />
<br />
To get that last column I do: <pre class='_prettyXprint _lang-auto _linenums:0'>Total.runningSum(row["Shipped Dollars"], null, 0)</pre>
<br />
There are only 2 things that I cannot figure out how to do.<br />
I want each page to be a new month.<br />
So say the database goes from 2012/01/10 to 2012/08/07<br />
<br />
I want a page for January, where the dates start on the 10th, then the next month starts on the next page, and so forth.<br />
<br />
I also want my Unshipped Dollars This Month To Date field to start over each month (thus start from 0 each page).<br />
<br />
Does anyone know how I could pull this off?<br />
<br />
Thanks
Find more posts tagged with
Comments
There are no comments yet