Arrange chart values by month

Stimulsoft Dashboards.WIN discussion
Post Reply
mrodriguez
Posts: 2
Joined: Mon Aug 10, 2020 12:23 pm

Arrange chart values by month

Post by mrodriguez »

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!
chart_with_month_names.png
chart_with_month_names.png (43.77 KiB) Viewed 11008 times
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Arrange chart values by month

Post by Lech Kulikowski »

Hello,

Please try to use MonthIdent() function.

Thank you.
Attachments
Annotation 2020-08-12 191606.png
Annotation 2020-08-12 191606.png (42.41 KiB) Viewed 10996 times
mrodriguez
Posts: 2
Joined: Mon Aug 10, 2020 12:23 pm

Re: Arrange chart values by month

Post by mrodriguez »

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!
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Arrange chart values by month

Post by Lech Kulikowski »

Hello,

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

Thank you.
#2560
Post Reply