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
computed columns based on expression builder.
Migrateduser
<p>Hi,</p><p> </p><p>I've got a report where I'm asking users to enter a month of year, and a search variable.</p><p> </p><p> </p><p> </p><p>However, I would like to create N columns where N is the number of days in the month and populate it with a count of number of occurances on the day (1-30 for example) of that month.</p><p> </p><p>I can calculate the number of days in the month in a birt variable and have the month and month+1 variables also.</p><p> </p><p>So how can I create a report to query the Result of my data set and perform a count on a date field?</p><p>I don't think it would require N selects!!? </p><p> </p><p>Thanks for any suggestions on how to go here...</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet