Stimulsoft Business Intelligence System | Forum

Hello,

I have a dataset formed by a date and several values for that date. I want to display those values by the month of the date in a chart, showing the 12 months of the year and it's respective sumatory.
The problem I have is that I can either use the month number, so it arranges correctly but the labels are in numbers, or use the month name, so the labels are correct but it orders the data in alphabetical order of the month.
Also, only the months with data are shown but I would like to show all the months. Is there a way to do that?

Thank you so much!

Hello,

Please try to use MonthIdent() function.

Thank you.

That worked! But now the months appear in English while with the MonthName function they appear in Spanish (the language I want to use). Any idea why thy this happens?

Also, another problem I have encountered making this chart is that I want to display all the months of the year and, for the months where there is no data, show a 0. Is that possible?
Thank you!

Hello,

We have added that task in our to-do list.

Thank you.
#2560