Silverlight PivotGrid in UI for Silverlight

This is a migrated thread and some comments may be shown as answers.

Silverlight PivotGrid

215 Answers 1482 Views

This is a migrated thread and some comments may be shown as answers.

215 Answers, 1 is accepted

answered on 18 Mar 2010, 04:08 PM

Hello Bernhard Gammel,

Thank you for the interest! Indeed we are already making the first steps to providing a Pivot Grid either as a separate control or as a mode of the existing RadGridView control .

We would be very happy if you share with us your expectations and requirements for such control . Any details on your business scenario and integration of such control will be helpful for us in the design process of the control.

Best wishes,
Pavel Pavlov
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

answered on 13 Apr 2010, 08:58 AM

Hi,

When do you think you will have a first release of the pivotgrid?

We are interested in such a control supporting the following features:
- drag&drop dimensions and measures
- hierarchical dimensions
- filtering(soft & hard) on dimensions also measures
- calculated fields(based on custom formulas of one or more fields)
- possibility to create schemas programatically
- customize totals (apply different formulas)
- possibility to save/load layouts(dimensions and measures, filters and sorting applied)
- possibility to replace values with colors or other representations(geometrics)
- printing

Best Regards

answered on 01 Sep 2010, 08:50 PM

I am swiftly reaching a point where this is becoming a control that I need. I would be very interested in working together with your control developer to produce something we would all get good use out of.

Essentially I have doubles/ints/strings described in multivariate space.

A simplistic data document for this might look like:

[DataContract]

public class QueryResult

{

[DataMember]

public List<QueryValue> QueryValues { get; set; }

public QueryResult()

{

}

[DataContract]

public class QueryValue

{

/// <summary>

/// Axis, AxisValue

/// </summary>

[DataMember]

public List<DfaTuple<string, string>> Coordinates { get; set; }

[DataMember]

public double ValueDouble { get; set; }

[DataMember]

public double Format { get; set; }

[DataMember]

public double Scale { get; set; }

public QueryValue()

{

}

Each row or column should be draggable to reorganize or pivot the table. Because the amount of data involved is very large, virtualization is a pretty big must have (although this could be done behind the scenes by having us implement an interface and handle something along the lines of GetAt(coordinates).

answered on 07 Oct 2010, 02:19 AM

Hi Hristo,
I do not need to transpose my data, My data looks something like this:

Town    Audience    Population

London    Men        10,000,000
London    Women    11,000,000
London   Children 5,000,000
Brighton    Men        150,000
Brighton    Women    120,000
Brighton   Children   56,000

and I need to display it in the grid as:

                      Men                 Women        Children
London       10,000,000    11,000,000   5,000,000
Brighton        150,000         120,000        56,000

Get the idea? There can be any number of towns or audiences. I can do this in the Infr*gistics PivotGrid by using a FlatDataSource, but I wondered in Telerik offer something similar. I have not yet decided which set of controls to purchase for my development.

answered on 08 Oct 2010, 09:58 AM

Hi Steve,

RadGridView does not support this internally , but with a few lines of external code it can be easily achieved .

For this we may write an IValueConverter or a ViewModel - to transform the initial data to a flat pivot-like table suitable for RadGridView and use it for ItemsSource

Since the columns are not fixed ( as you say there may be many audiences ) , we may need to use something like http://blogs.telerik.com/vladimirenchev/posts/09-04-23/lightweight_datatable_for_your_silverlight_applications.aspx.

Let me know in case you need a working sample on that .

Best wishes,
Pavel Pavlov
the Telerik team

answered on 27 Oct 2010, 11:52 AM

Hi all,

I cannot share too much about our plans in this space right now. However I can say that: We are actively working on something that we hope will solve your problems. It will be Silverlight based in the first version, but will not be limited to Silverlight only in the future. As soon as we have something stable to show we will announce it publicly.

Regarding the timeframe for the official announcement probably it will happen in the first months of 2011.

We do have a private beta testing mailing list of clients who want to participate and give an early feedback about the product. We will mail this people once we have something useful to show, but before shipping it to a broader audience. Anyone who wants to be included in this list please reply to this forum thread.

Hope this helps,
Stefan Dobrev
the Telerik team

answered on 06 Jan 2011, 10:32 AM

Hi,

A Silverlight PivotGrid feature would be very nice!!!

However, an Olap client would be great as well. In fact, there was one in asp.net developped by dundas. Now, it's dundas dashboard (silverlight)... But it's more limited than the asp.net one.
Neverthless, I found an OLAP client for silverlight developped by ComponentOne.

http://demo.componentone.com/Silverlight/OLAP/

This demo is quite interesting because you can have a chart view or a grid view. It's quite similar to what dundas did in asp.net.
This is exactly this kind of feature that my organization is looking for... So, it might be a good value for Telerik to develop something like that.

answered on 16 Feb 2011, 05:21 PM

Hi Paolo, toto rto,

I understand your impatience in waiting and wanting clear answers and a ready-to-use pivot grid. I really do – believe me or not I’m even more impatient. The people involved in its development are determined and are working hard on developing a first-class product. The facts are that we are in the midst of the development and we still have a lot of work to do. Unfortunately, I cannot be more specific than that – we can be ready in a month or two with the beta version but for a fully functional version the time frame can be probably extended till the end of the year.

There are various reasons for this delay. One of the main ones is that we’ve collected a lot of various feedback and we want to deliver most (if not all) of the requested features at once. Releasing the product with so many features will ensure that it will meet the requirements of most of our clients. This however requires a lot of work (coding/testing) to make sure that the product will work as expected.

This being said, once again I’ll ask for your patience. I hope that you will understand our position on this matter.

Greetings,
Hristo
Unit Manager
the Telerik team

Vote for Telerik products at the Great Indian Developer Awards

answered on 09 May 2011, 01:00 PM

Telerik Team, we have been waiting on olap pivot grid since 18 months Although replies always indicated some release since q3 2010 and now it's almost q2 2011 we think that you Atleast owe all licensed clients of a concrete roadmap of this controls release. I have indicated in the past that almost all the vendors- dev express, component one, infragistics, sync fusion Have a rich working version of this control Eventhough You make it sound like rocket science, we have been using a cheap cost (500). Silverlight olap grid from Ranet which has all the functions people in this post are requesting even in their free version in codeplex They have 2 developers and have the greatest support with Mac 24 hours to add features Can you guys atleast buy them?

answered on 16 May 2011, 03:28 AM

4 items for discussion..

1 - I go to the Public Issue Tracking system to have my vote on which features are important and I cant find anything matching Pivot - so we dont all go and vote on the wrong item.. can you please include the name and details of the Pivot grid in your current PITS list.

2 - In response to shivir 's post about the Ranet control.. That looks brilliant.. but I dont want to have my data require an OLAP cube before being able to use this... I am really after something where a user does a fairly simple search producing 50 to 500 records and then give them some tools to analyse that information, similar to Excel and its pivot table..

3 - I also agree with shivir's post about our expectations for a response from Telerik with more concrete information. I raised Ticket 268645 in December 2009 and received the following response
"We definitely have the PivotTable in our road map. We will release an early CTP of this next year, but it will be in post 2010 Q1 time frame. Stay tuned for more information on our site and blogs.

Sincerely yours,
Stefan Dobrev"

So if you "definitely have the PivotTable in our road map" then why can we not see something in the RoadMap now?

4 - What should we expect from being in the beta list? Are you going to email us all with a list of requirements? Lots of people posting here just say add me to the list expecting to then receive some more information about the beta ... but other than receiving regular copies of everyone elses "Please add me to the list"... I have not seen anything else. What is this list??

answered on 16 May 2011, 10:15 AM

Yep I agree. I have been monitoring this thread for at least six months plus now. I did have a requirement for pivot but have been doing a work around since then (ViBlend controls) and have been waiting. Telerik keep on saying it will appear within the next quarter, so I have been waiting.

Yes I don't need OLAP support either, but it would be nice in a later version, does not need to be there in the initial release.

Since being on this list I have only got the updates to this thread and nothing else.

Come on Telerik, can you give use more information then please wait, because in a minute I am expecting more people to move to another provider for this feature request (thats been on the cards for over 1 year now).

Yes I know my account says I have not paid for any controls, but it does not mean I have not recommended and had them purchased by the client I work for.

Regards

Richard...

answered on 25 May 2011, 12:52 PM

Hi all,

I hope my previous statements were not vague in terms of our development plans and the fact that the Pivot Grid control is included and we are doing our best to ship it till the end of this year. The reasons for being uncertain about the timeframe are pretty trivial – ever-changing priorities and a lot of other clients’ requests which we have to implement in our suite. But I want to assure you that the Pivot Grid is already with the highest priority in our development plans and we are optimistic that it will be ready till the end of this year.

Once again I would like to thank all of you for your patience and understanding.

Kind regards,
Hristo
the Telerik team

answered on 12 Dec 2011, 08:25 PM

Im surprised so many people are still waiting for this grid, inst it obvious? At best this over a year long silence is a disrespect to us the clients waiting faithfully for this elusive control and endlessly asking for an ETA to release. But truth is, with silverlight being phased out, this grid had to arrive to market 2 years ago to be in any way valuable to telerik. I bet they are really investing most of their efforts in HTML5 now, so complex new silverlight controls like the olap grid, not sure AT ALL...

might help explain why they avoid any real discussion about this grid for over a year now...