How use TimeSpan Axe

[Autofocus]

HI all,

I am new on syncfusion products and I met some trouble with syncfusion chart control.

I am pretty sure it's pretty easy but i don't figure out.

I try to make a column chart with a category primary axis and a timespan secondary axis but I get a InvalidCastException: Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.

Code below :

XAML :

<Grid.DataContext>

       <local:ViewModel/>

</Grid.DataContext>

...

<chart:SfChart x:Name="columnChart" AreaBorderBrush="#8e8e8e" Background="White" Grid.Row="0">

                <chart:SfChart.Header>

                    <TextBlock FontSize="22"   Foreground="Black" FontFamily="Segoe UI">Time spend by application</TextBlock>

                </chart:SfChart.Header>

                <chart:SfChart.PrimaryAxis>

                    <chart:CategoryAxis  Header="Applications" Foreground="Black"  FontSize="20" LabelTemplate="{StaticResource labelTemplate}"/>

                </chart:SfChart.PrimaryAxis>

                <chart:SfChart.SecondaryAxis>

                    <chart:TimeSpanAxis  FontSize="20" Minimum="0" Maximum="500" Interval="50"   Header="Time (in Min)" Foreground="Black" LabelTemplate="{StaticResource labelTemplate}"/>

                </chart:SfChart.SecondaryAxis>

                <chart:ColumnSeries EnableAnimation="True" Palette="Metro" ItemsSource="{Binding ApplicationTime}"  XBindingPath="ApplicationName" YBindingPath="Time" Label="Sneakers sold" chart:ChartTooltip.EnableAnimation="true" ShowTooltip="True"> ...

View Model :

public class ViewModel

    {

        public ObservableCollection<Model> ApplicationTime { get; set; }

        public ViewModel()

        {

            ApplicationTime = new ObservableCollection<Model>();

            ApplicationTime.Add(new Model { ApplicationName = "Visual Studio 2013", Time = new TimeSpan(1,40,30)});

        }

    }

Model :

    public class Model

    {

        public TimeSpan Time { get; set; }

        public string ApplicationName { get; set; }

    }

Maybe I have to herit System.TimeSpan class to implements IConvertible (to convert it to double) ?

Thanks.

[Sheik Syed Abthaheer M]

 
Dear Customer,

Thanks for using Syncfusion products.

At present we are not having TimeSpanAxis support for chart secondary axis. However we have meet your requirement in workaround by converting TimeSpan value to double. Please find the sample in the below location.

Sample: TimeSpan_Sample.zip

Please let us know if have any queries.

Regards,
M.Sheik
 
 
 
 
 

[Autofocus]

Thank you very much. It works as expected.

[Sheik Syed Abthaheer M]

Dear Customer,

Thanks for your update.

Please let us know if you need any further assistance on this.

Regards,
M.Sheik

[Peter]

Hello,

I'm having same problem with TimeSpanAxis as 2nd axis. Same exception.

I wanted to see the workaround example for converting to double, however access to that file is denied.

Thanks&Regards,

Peter

[Hemalatha Marikumar]

Hi Peter, 

  

Greetings from Syncfusion. 

  

You can achieve this requirement with the help of TimeSpanAxis in SecondaryAxis by converting the TimeSpan values to double.  And you can customize the axis labels format using LabelCreated event as per the below code snippet. 

  

Code Snippet [Xaml]: 

  

<chart:SfChart.SecondaryAxis> 

            <chart:TimeSpanAxis LabelCreated="NumericalAxis_LabelCreated" > 

            </chart:TimeSpanAxis> 

        </chart:SfChart.SecondaryAxis> 

  

Code Snippet [C#]: 

  

private void NumericalAxis_LabelCreated(object sender, LabelCreatedEventArgs e) 

        { 

            TimeSpan Value = TimeSpan.Parse(e.AxisLabel.LabelContent as string); 

            DateTime date = (new DateTime(1970, 1, 1).AddMilliseconds(Value.TotalMilliseconds)); 

            e.AxisLabel.LabelContent = String.Format("{0:HH:mm}", date); 

        } 

  

  

And we have prepared a sample based on your requirement and download the sample from the below location. 

  

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/11837389555797.zip 

  

Please let us know if need any further assistance on this. 

  

Regards, 

Hemalatha M.