Set categories and culture in kendo charts doesn't work

[Philippe]

I try to set fix categories in my kendo chart for all day of week, also when didn't have value and I just want the 5 days of european weeks like monday to friday. Second problem, I can't set culture to have the name of day in french.

        @(Html.Kendo().Calendar()
            .Name("calendar")
            .Value(DateTime.Now)
            .Format("dd/MM/yyyy")
            .Events(e => e.Change("refreshGrid"))
        )
    </div>
    @(Html.Kendo().Chart<RapportTache>()
            .Name("chart")
            .Title("Rapport de la semaine")
            .Legend(legend => legend
                .Position(ChartLegendPosition.Top)
            )
            .DataSource(ds => ds
                        .Read(read => read.Action("Chart_Read", "Saisie").Data("getDateTime"))
                        .Group(group => group.Add(model => model.TacheLibelle))
                        .Sort(sort => sort.Add(model => model.RapportTacheJourDate).Ascending())
                        )
            .Series(series =>
            {
                series.Column(model => model.RapportTacheJourDuree, categoryExpression: model => model.RapportTacheJourDate).Stack(true);
            })
            .CategoryAxis(axis => axis
                .Labels(labels => labels
                    .Culture("fr-FR")
                    .DateFormats(formats => formats
                        .Days("dddd dd")
                    )
            )
            .MajorGridLines(lines => lines.Visible(false))
        )
        .SeriesColors(
            "#cd1533", "#d43851", "#dc5c71", "#e47f8f", "#eba1ad",
            "#009bd7", "#26aadd", "#4db9e3", "#73c8e9", "#99d7ef"
        )
        .ChartArea(h => h.Height(300))
        .ValueAxis(axis => axis.Numeric()
            .Labels(labels => labels.Format("{0:N0}"))
            .MajorUnit(10)
            .Line(line => line.Visible(false))
        )
        .Tooltip(tooltip => tooltip
            .Visible(true)
            .Template("#= dataItem.RapportTacheJourDuree # (heures) : #= dataItem.TacheLibelle #")
        )
    )

And this is the actual result : 

[![enter image description here][1]][1]


  [1]: http://i.stack.imgur.com/xa3pP.png



In the actual situtation, I just have the monday on null value. If anyone have an idea, thank's for help ! :)

[Danail Vasilev]

Hello Philippe,

To localize the chart you should initially load the corresponding culture .js file and then set the culture to the kendo object. More details on the matter are available here - http://docs.telerik.com/kendo-ui/framework/globalization/overview

Regarding excluding weekends that is not possible for a date axis. You can, however, use categories where you can manually pass the week day names as strings.

Regards,
Danail Vasilev
Telerik by Progress

[Philippe]

Hello Danail and thank's for you're answers. Regarding this chart with week day, I look this with you're ticket support. 

Maybe you can help me for another chart where I use a dynamic view model with categories in a list of string.

The problem with this chart is that the categories is not define like I want, is look like this : 

http://image.noelshack.com/fichiers/2016/40/1475673508-tel2.png

If you look good, you can see I have one categories with my List<string> categories separate with coma... And I want all of my categories in the chart even I have no value. 

This the view :

@(Html.Kendo().Chart()
                .Name("ChartEquipe")
                .Legend(legend => legend
                    .Visible(false)
                )
                .Series(series =>
                {
                    foreach (var def in Model.RapportsEquipe)
                    {
                        series.Column(def.RapportSemaine).ToField(def.EmployeeNom).Name(def.ClientNom + " " + def.EmployeeNom).Stack(def.EmployeeNom);
                    }
                })
                .CategoryAxis(axis => axis
                     .Categories(Model.InitialesEquipe)
                     .MajorGridLines(lines => lines.Visible(true))
                  )
                .SeriesColors(
                    "#5DA39B", "#39635E", "#81E3D7", "#89F0E3", "#73C9BF"
                )
                .Tooltip(tooltip => tooltip
                    .Visible(true)
                    .Template("#= value # (heures) : #= series.name #")
                    )
                )

 

My ViewModel : 

    public class SaisieViewModel
    {
        public List<string> InitialesEquipe { get; set; }

        public List<RapportTacheEquipe> RapportsEquipe { get; set; }
    }
}

And my Model for chart : 

public class RapportTacheEquipe
    {
        public string EmployeeNom { get; set; }

        public DateTime RapportTacheJourDate { get; set; }

        public float RapportTacheJourTotal { get; set; }

        public string ClientNom { get; set; }

        public List<float> RapportSemaine
        {
            get
            {
                return new List<float> { RapportTacheJourTotal };
            }
        }

        public string RapportJour
        {
            get
            {
                return Enum.GetName(typeof(eJourSemaine), (int)RapportTacheJourDate.DayOfWeek);
            }
        }
    }

 

Any idea ? Thank you.

[Danail Vasilev]

Hi Philippe,

Generally, items from series are aligned over each category from the x-axis. That being said the desired appearance of the chart is not achievable with categories. To workaround that, however, you can simply use x-axis Title instead of categories.

I would also suggest that you open separate tickets/forum posts when you have different questions. Thus we can keep the threads concise and easy to track if needed. Also the corresponding support officer can answer you better.

Regards,
Danail Vasilev
Telerik by Progress

[Philippe]

Ok thank's for help, I will start a new forum post.