Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Conditional grouping of dates on X-axis
frames88
I am able to group a date column on X-axis by weeks, months or years. I need to group the date column conditionally. Say, if a report parameter value is
Months - then the grouping unit should be set to "Months"
Years - then the grouping unit should be set to "Years"
How to achieve this behavior?
Find more posts tagged with
Comments
ahsiang
See if this helps.
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1347-dynamic-x-and-y-axis/
In your x-axis, do a case statement and check the parameter value and use the javascript month() or year() to get the year or month.