Grouped Bar Chart Month put bars starting from 0 instead of 1

Adhoc
, , ,
#1

Hello,

I am using a grouped bar chart in Helical Insight 4.1GA for plotting monthly data. The data is coming accurately as month number 1 to 12 in tabular view. However when I apply the grouped bar chart it becomes 0 to 11. How do I fix this.

image

Thanks,
Snow.

#2

Hello snow,

The grouped bar chart take up counting from 0 and thus this is getting changed. For your scenario you can convert the month number 1 to 12 into a text format and it will not convert the numbers and show you as per your expectations. Simply using DBfunctions convert the datatype of that column from number into text. Then it will work fine.

image

Thank You,
Helical Insight.