Hi Experts ,
In Chart Component , I have a requirement to display Month names in order . For this I have done the following
I configured the chart Component by Month_name vs Record Count
When i preview the chart , Month Names are displayed in the following order
Aug,Dec,Sep,Feb,Jun,Apr,Jul,Nov,Jan,May,Mar,Oct
But I want to display the months in Correct order
Even I tried with a view , by writing the below EQL
DEFINE Base2 AS SELECT COUNT(1) AS click_Month GROUP BY "Month","Month_No","year" ORDER BY "Month","Month_No","Year"
When i preview the "View", records are shown up in correct order, But in the chart same behavior is observed.
I tried the above but couldn't acheive the requirement which we have .I was able to acheive only when i have the attribute concatenated with Month_Number and Month_Number. But our requirement is only show month name in the chart
Any thoughts would be gratefully appreciated.
Thanks In Advance