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
How to display Count of User Account created Grouped by month and Year ?
Migrateduser
<p>Hi, </p>
<p>My SQL query is below:</p>
<pre class="_prettyXprint">
select user_name, account_created_date from Users</pre>
<p>Using this, I need to create a Bar chart which shows count of "User Account created" based on Month and Year.</p>
<p> </p>
<p><sup>Month</sup> is the X-axis and <sup>User accounts Count</sup> is the Y-axis. This means, if I select year 2013, then the Bar chart should show me Count of User account created from Jan to Dec for only 2013. And if I choose 2012, then Chart should show me Count of User account create for Jav - Dec for only 2013.</p>
<p>Note: account_created_Date returned from sql query is normal datetime format.</p>
<p> </p>
<p>Please let me know how to achieve this in Birt ?</p>
Find more posts tagged with
Comments
There are no comments yet