May 29, 2013 at 2:24 am
I've created a report that shows number of visits to our websites by month. However, its not showing the month names for each month, only january, november and january. How do I show every month number? There is visits(data) every month since Jan 2011 to present. I've included screen shots to help explain
May 29, 2013 at 3:50 am
Check the Data, whether you have a data for said months, if there is a data it should reflect in graph too..
May 29, 2013 at 4:37 am
Yeah I have data and I have enough columns for all the months i have data, it just doesn't display the labels next to the columns. Any ideas how i can get the month names next to the labels?
May 29, 2013 at 5:54 am
Under the horizontal axis options try changing the interval from auto to 1
May 29, 2013 at 6:24 am
Thanks that works great 🙂 Now the month names are displaying in alphabetical order (April, August....October September), how do i get them to display correct order?
May 29, 2013 at 2:34 pm
Most Calendar tables I've worked with have column that numbers months so you can select out that column and sort on it under your category groups. If you don't have that then you could build your own sort in your code. Something like this:
DISTINCT CASE cal_month_name WHEN 'January' THEN 1
WHEN 'February' THEN 2
WHEN 'March' THEN 3
WHEN 'April' THEN 4
WHEN 'May' THEN 5
WHEN 'June' THEN 6
WHEN 'July' THEN 7
WHEN 'August' THEN 8
WHEN 'September' THEN 9
WHEN 'October' THEN 10
WHEN 'November' THEN 11
WHEN 'December' THEN 12 ELSE 13 END AS CalSort
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply