Hi,
I am thinking to show data on quarterly basis, so i create a column containing each quarter of the year e.g. Q1 2006, Q2 2006.. Q1 2007, Q2 2007. when I visualize these data, split by quarter. they are arrranged in the way like Q1 2006 Q1 2007, is there a way to show them in the right quarterly order?
I also noticed omniscope aggreage date in the way like Jan 2006-Mar 2006, Mar 2006 - May 2006, is it possible to aggregate date in the Jan 2006- Mar 2006, April 2006-Jun 2006?
Thanks,
Xuan