Month not visible in column Chart

[Kumar1987]

Hi,

I have built a simple page to show the number of tickets by month/region. I've created a calculated field to sort the month and the formula I used is below. The challenge I have is, in the chart November month data isn't shown and the data is present in the gsheet I'm using. If I just remove the month "November" and leave the data in the source file October month isn't displayed and just the November data is displayed not the month.

Please assist.

CASE
WHEN Month= "January" then '01-Jan'
WHEN Month= "February" then '02-Feb'
WHEN Month= "March" then '03-Mar'
WHEN Month= "April" then '04-Apr'
WHEN Month= "May" then '05-May'
WHEN Month= "June" then '06-Jun'
WHEN Month= "July" then '07-Jul'
WHEN Month= "August" then '08-Aug'
WHEN Month="September" then '09-Sep'
WHEN Month= "October" then '10-Oct'
WHEN Month= "November" then '11-Nov'
WHEN Month= "December" then '12-Dec'
END

[kosiorro · Accepted solution]

Hi, I believe your styles are configured to only show 10 bars on the chart.

Let me know 🙂

[Kumar1987]

Thanks, @kosiorro Yes the style was set to 10, I have fixed it now. Thanks for your help.