Charting Toolkit Column Series in a FeatureLayer MapTip?

How about my second question? Is there a way to place values on top of the bars?

Looks possible, but I didn't test it myself : https://msmvps.com/blogs/deborahk/archive/2011/02/19/silverlight-charting-displaying-data-above-the-column.aspx

Cool. I never know if its going to be simple or extremely difficult. How about my second question? Is there a way to place values on top of the bars?

How would I do that? Does that mean I have to modify the chart template with a hundred lines of code?

No. Just define the chart title with this syntax:

 
<chartingToolkit:Chart ..............>
  <chartingToolkit:Chart.Title>
    <StackPanel Orientation="Horizintal">
      <TextBlock Text="{Binding ........}" />
      <TextBlock Text="{Binding ........}" />
    </StackPanel>
  </chartingToolkit:Chart.Title>
  ......

march-training-news-email-1200x600-1.jpg

How would I do that? Does that mean I have to modify the chart template with a hundred lines of code?

Also another question, I'd like to show the actual value in text on top of the columns similar to the attached picture. Would there be a way to do this?

Chart.jpg

e7bf213f-2f14-4232-bc2e-80be57bc5042.zip

As the title can be any UIElement, you can define it as a stackpanel containing 2 TextBlocks.

Dominique -
The editor does not allow Names that begin with a number, hence the underscore. However your suggestion to use Tag in it's place worked great. Thanks

Now, is there a way I can concatenate 2 field values to produce the Title? Something like

<toolkit:Chart Title="{Binding [tcmlatestcounts._STREET+tcmlatestcounts._FROM]}" FontWeight="Bold"  Width="800" Height="400">

MuhammadWaqar_ul_islam

Need FULL CODE FOR XMAL AND C#
thanks

However, I would still like to remove the legend box.

You can edit the chart template with Blend and remove the legend (or less 'brute force' you should be able to edit the 'LegendStyle' as well).

Also, is there a work around for not being able to use a number as the Name? The underscore is unsightly.

The name of the Serie is coming from your definition of the IndependantVlaue : IndependentValueBinding="{Binding Name}" . It means that it's the name of your listbox item :
<ListBoxItem Name="_1998" Content="{Binding [tcmlatestcounts._1998], TargetNullValue={StaticResource zero}}" />

Is there any problem to remove the underscore from this name? If there is a problem, a workaround might be to use the 'Tag' property instead of the 'Name', i.e:
- IndependentValueBinding="{Binding Tag}"
and
- <ListBoxItem Tag="1998" Content="{Binding [tcmlatestcounts._1998], TargetNullValue={StaticResource zero}}" />

Dominique -
Hi again. Further research led me to a different construct for the chart. It now looks like this and is closer to what I wanted.

 <esri:FeatureLayer.MapTip>
                            <Border Style="{StaticResource PanelBorder}">
                                <Border.Resources>
                                    <sys:Int32 x:Key="zero">0</sys:Int32>

                                    <ListBox x:Name="Counts">
                                        <ListBoxItem Name="_1998" Content="{Binding [tcmlatestcounts._1998], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_1999" Content="{Binding [tcmlatestcounts._1999], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2000" Content="{Binding [tcmlatestcounts._2000], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2001" Content="{Binding [tcmlatestcounts._2001], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2002" Content="{Binding [tcmlatestcounts._2002], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2003" Content="{Binding [tcmlatestcounts._2003], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2004" Content="{Binding [tcmlatestcounts._2004], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2005" Content="{Binding [tcmlatestcounts._2005], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2006" Content="{Binding [tcmlatestcounts._2006], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2007" Content="{Binding [tcmlatestcounts._2007], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2008" Content="{Binding [tcmlatestcounts._2008], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2009" Content="{Binding [tcmlatestcounts._2009], TargetNullValue={StaticResource zero}}" />
                                        <ListBoxItem Name="_2010" Content="{Binding [tcmlatestcounts._2010], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                 
                                </Border.Resources>

                                <toolkit:Chart Title="Historical Counts" FontWeight="Bold"  Width="800" Height="400">
                                    <toolkit:Chart.Axes>
                                        <toolkit:CategoryAxis Orientation="X" Title="Year" />
                                        <toolkit:CategoryAxis Orientation="Y" Title="ADT"  />
                                    </toolkit:Chart.Axes>
                                    <toolkit:Chart.Series>
                                        <toolkit:ColumnSeries Title="ADT" IndependentValueBinding="{Binding Name}" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource Counts}, Path=Items}" />
                                    </toolkit:Chart.Series>
                                </toolkit:Chart>
                            </Border>
                        </esri:FeatureLayer.MapTip>

However, I would still like to remove the legend box. Also, is there a work around for not being able to use a number as the Name? The underscore is unsightly.

Hi Dominique -

Using your example I have been able to get this started pretty well.

 <esri:FeatureLayer.MapTip>
                            <Border Background="Pink">
                                <Border.Resources>
                                    <sys:Int32 x:Key="zero">0</sys:Int32>

                                    <ListBox x:Name="_1998">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._1998], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_1999">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._1999], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2000">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2000], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2001">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2001], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2002">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2002], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2003">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2003], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2004">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2004], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2005">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2005], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2006">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2006], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2007">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2007], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2008">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2008], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2009">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2009], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                    <ListBox x:Name="_2010">
                                        <ListBoxItem Content="{Binding [tcmlatestcounts._2010], TargetNullValue={StaticResource zero}}" />
                                    </ListBox>
                                </Border.Resources>
                                <!--<TextBlock Text="{Binding [tcmlatestcounts._1998]}" Foreground="Black" />-->

                                 <toolkit:Chart Title="Historical Counts" Width="800">
                                    <toolkit:Chart.Axes>
                                        <toolkit:CategoryAxis Orientation="X" Foreground="Transparent" />
                                    </toolkit:Chart.Axes>
                                    <toolkit:Chart.Series>
                                        <toolkit:ColumnSeries Title="1998" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _1998}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="1999" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _1999}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2000" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2000}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2001" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2001}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2002" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2002}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2003" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2003}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2004" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2004}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2005" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2005}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2006" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2006}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2007" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2007}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2008" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2008}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2009" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2009}, Path=Items}" />
                                        <toolkit:ColumnSeries Title="2010" DependentValueBinding="{Binding Content}" ItemsSource="{Binding Source={StaticResource _2010}, Path=Items}" />
                                    </toolkit:Chart.Series>
                                </toolkit:Chart>
                            </Border>
                        </esri:FeatureLayer.MapTip>

I would like to label each vertical bar with the title (year) that it represents and eliminate the legend. Is there a way to do that?
Thanks

Binding b2 = new Binding("");
MyDictionaryConverter dc2 = new MyDictionaryConverter();
b2.Converter = dc2;

You need to initialize the ConverterParameter as well:
b2.ConverterParameter = "NEWFIELD";

If this is not working, try debugging the converter by putting a break point in the Convert method in order to figure out the issue.

Is possible to insert a combobox inside a cell of a DataGrid?,

Sorry, I am not used to working with datagrid.
I suggest you to create a new thread with another title, hopefully somebody knows.

I thought I had solved Question 2, but is not working very well :mad:

Please let me know if you know how to do it..

Thanks!
Emiliano

Forget about Question 2, I've solved it!!

Thanks.
Emiliano.

OK Dominique, Thanks, I will try to fix it.

Coming back to the MapTips, I implemented the class MyDictionaryConverter that you gave to me, but I couldn't bind it correctly. It's OK if I do (just with the Converter. I also set others parameters to b2):

Binding b2 = new Binding("");
MyDictionaryConverter dc2 = new MyDictionaryConverter();
b2.Converter = dc2;

Question 2:

I have other question:
Is possible to insert a combobox inside a cell of a DataGrid?, you know, I don't need a Column template with the entire column with combo-boxes (I know how to do it), just I need one combobox in one of the cells from the Data Grid. My idea is to have a column that depending of the type of data that I have (controling it through the code behind), set the content of the column with a text box or with a combobox. I want a mix of those in the same column.
Is that possible?

Thanks!
Emiliano.

Hi Emiliano,

From the code, it looks like an event handler is set on the first click :

 
private void ckbVisibility_Checked(object sender, RoutedEventArgs e)
{
CheckBox ckb = sender as CheckBox;
TocItem data = ckb.DataContext as TocItem;
if (ckb.Tag.ToString().ToLower() == "new")
{
ckb.Tag = "";
data.ItemChecked += _itemChecked;
}
}

It's likely the source of your issue.
I guess this would need little change either to initialize the event handler another way or to avoid usage of this event.
My 2 cts :
- remove this event
- make IsChecked virtual in TOCItem
- override IsChecked in TOCLayer and TOCService for doing the job (which is in _itemChecked today)
- use a basic twoway binding between IsChecked and the UI

Note that this sample is not provided by ESRI so you won't modify it from ourself:)

Dominique,
I realized about a problem with the layers on the TOC.
If I try for example:
TOC.TocItem ti = TOC1.Services[0].Children[0];
ti.IsChecked = false;

and I didn't click over any node on the TOC yet, it turn off the layer but doesn't refresh the map.

If first, I click in some node of the TOC, and then execute these two lines of code, it turn off the layer and refresh the map.
For some reason is refreshing the map just only if you clicked in a node before do this steps.

I would like to force this click or find some way to refresh the map after turn off the layer.

Some idea?

Thanks.
Emiliano.

Thanks Dominique, I will test the Converter part.

About the layers in the TOC, I'm turning those layers off doing something like "tl.IsChecked = false;" where tl is the TocLayer. It works, because the checks box from each layer are off after that step, but the map doesn't refresh.
The opacity of the service is not changing.
Some idea?

Thanks in advance.
Emiliano

Finally, I was able to take out the X-axis label, but I couldn't implement a null converter in SL3, because like you said TargetNullValue is available in SL4.
Could you explain to me how to do it?

You need to combine the dictionary converter (needed with SL3) and the converter returning 0 when null:

 
public sealed class MyDictionaryConverter : IValueConverter
{
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
var dict = value as IDictionary<string, object>;
if (dict != null)
{
if (dict.ContainsKey(parameter as string))
return dict[parameter as string];
}
 
return 0;
}
public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
{
throw new NotSupportedException();
}
}

What Should I refresh after it?

I would say : nothing, should be automatic. Is the slider changing the opacity?

Hi Dominique,
Finally, I was able to take out the X-axis label, but I couldn't implement a null converter in SL3, because like you said TargetNullValue is available in SL4.
Could you explain to me how to do it?

Other Question.
After Load the graphics I'm turning off some layers in the TOC by code (implemented the ESRI Gallery Example of the TOC).
After turned off the layers the map doesn't refresh the changes, I still seeing all the layers on the map, but my TOC has the check-box from those layers unchecked.
What Should I refresh after it? I've tried to refresh the map service, the TOC layout, etc, but I can't get my map refreshed.

Thanks a lot!
Emiliano.

Thank you very much!, I will test it.

Thanks for you help.
Emiliano.

In the same case (kastofan chart) if the value of the field TEL_TOT in the database is null, the application is giving an error (attaching it).
Is there a possibility to prevent that? or control it?

You could use a null value converter or, with SL 4, use the TargetNullValue binding attribute:

<Border.Resources>
<sys:Int32 x:Key="zero">0</sys:Int32>
<ListBox x:Name="Telephones">
<ListBoxItem Content={Binding [TEL_TOT], TargetNullValue={StaticResource zero}}" />
</ListBox>
<ListBox x:Name="Mobiles">
<ListBoxItem Content={Binding [MOB_TOT], TargetNullValue={StaticResource zeo}}" />
</ListBox>
<ListBox x:Name="Internets">
<ListBoxItem Content={Binding [INT_TOT], TargetNullValue={StaticResource zero}}" />
</ListBox>
</Border.Resources>

is there the possibility to take out the number "1" that is in the bottom?, is there a property to configure the x-axis label or something like that?

You can make transparent the x-Axis label:

 
<chartingToolkit:Chart Title="Communication" >
<chartingToolkit:Chart.Axes>
<chartingToolkit:CategoryAxis Orientation="X" Foreground="Transparent" />
</chartingToolkit:Chart.Axes>
....

You can also change the style using Blend.

Sorry, I forgot to ask you something else.
In the same case (kastofan chart) if the value of the field TEL_TOT in the database is null, the application is giving an error (attaching it).
Is there a possibility to prevent that? or control it?

Thanks.

error.JPG

2010-08-26_093041.png

Great, I solved that thanks your help!

One more question. In the Chart that you did for kastofan, is there the possibility to take out the number "1" that is in the bottom?, is there a property to configure the x-axis label or something like that?

Thanks!

First problem:
txtProd is null when I try to add a binding by code.

The maptip is not in the same namescope. You should be able to get it by :

TextBlock txtBlock = ChartFeaturelayer.MapTip.FindName("txtProd") as TextBlock;

Second Problem:
If I try creating a new TextBlock instance and changing the binding like this code below, it doesn't work:

FeatureLayer ChartFeaturelayer = MyMap.Layers["ChartFL"] as FeatureLayer;
ChartFeaturelayer.OutFields.Add("NEWFIELD"]);
txtIDChart = new TextBlock();
Binding b = new Binding("");
b.Mode = BindingMode.OneWay;
b.ConverterParameter = "NEWFIELD";

txtIDChart.SetBinding(TextBlock.TextProperty, b);

You forgot to initialize the converter:

b.Converter = new DictionaryConverter();

Note : il you are using SL4, you don't need the dictionary converter anymore:

 
Binding b = new Binding("[NEWFIELD]");

Dominique,
I have a problem trying to update the binding by code inside a FeatureLayer. For example I have this Feature Layer in the XAML:

<esri:FeatureLayer ID="ChartFLayer" x:Name="ChartFL"
            FeatureSymbol="{StaticResource ProductionMarkerSymbol}">
                <esri:FeatureLayer.OutFields>
                    <sys:String>PROD_ACUM</sys:String>
                </esri:FeatureLayer.OutFields>
                <esri:FeatureLayer.MapTip>
                    <Border Style="{StaticResource MapTipBorder}">
                        <Grid Height="160" Width="160">
                            <Grid.RowDefinitions>
                                <RowDefinition Height="50"/>
                                <RowDefinition Height="80"/>
                            </Grid.RowDefinitions>
                            <TextBlock Margin="5,0,0,0" Text= "Prod: " Foreground="White"/>
                            <TextBlock Margin="25,0,0,0" x:Name="txtProd" Foreground="White" Text="{Binding Converter={StaticResource MyDictionaryConverter},ConverterParameter=PROD_ACUM, Mode=OneWay}" />

                                                  </Grid>
                    </Border>
                </esri:FeatureLayer.MapTip>
            </esri:FeatureLayer>

I want to update by code the ConverterParameter PROD_ACUM in txtProd, but I cant!
First problem:
   txtProd is null when I try to add a binding by code.
Second Problem:
If I try creating a new TextBlock instance and changing the binding like this code below, it doesn't work:

               FeatureLayer ChartFeaturelayer = MyMap.Layers["ChartFL"] as FeatureLayer;
               ChartFeaturelayer.OutFields.Add("NEWFIELD"]);
               txtIDChart = new TextBlock();
                Binding b = new Binding("");
                b.Mode = BindingMode.OneWay;
                b.ConverterParameter = "NEWFIELD";

                txtIDChart.SetBinding(TextBlock.TextProperty, b);

                txtIDChart.UpdateLayout();

Thanks in advance.
Emiliano.

KevinStofan

Dominique,

Thanks. This was a huge help. Your example is exactly how I needed it to look.