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

Silverlight PivotGrid

215 Answers 1612 Views

General Discussions

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

This question is locked. New answers and comments are not allowed.

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...

answered on 06 Jul 2012, 06:54 AM

Hi

We received access to the CTP and were impressed with the level of completeness of the control.

In the demo system provided it worked smoothly and from a user interaction it did most things we wanted immediately.

We put together a wish list of additional features that were not obvious from the demo and investigated these at a code level - our feedback is below.

Other users should not rely on this as a definitive answer... and other more experienced developers or with more time might overcome some of the perceived shortcomings.

1. Drill through to obtain a list of source data.
We want select an individual cell and programmatically determine the criteria on that cell via row and column attributes so that we can then generate (outside of the pivotgrid) a data set for use in another control such as data grid. It was not obvious how we could achieve this.

2. More than just summation... need counts, min max, Avg, median
Not available in the demo, but available programmatically - Telerik PivotGrid appears to support all the following Sum, Count, Average, Max, Min, Product, StdDev, StdDevP, Var, VarP - all Good. Thanks

3. Calculated fields (user customisable instead of data driven) - it would be good to support Expression Fields like
http://demos.telerik.com/silverlight/#GridView/ExpressionColumn + http://demos.telerik.com/silverlight/#ExpressionEditor/FirstLook
It appears that the fields can only come from source data.

4. control of sorting of data labels (columns and rows).
It would be good to provide control over the sequence of columns - but this does not appear possible.

5. clickable links in data row headers and column headers
We believe this is possible.

6. Access the summarised data to feed into a graph component.
We would like to extract the summarised data from the pivot grid for use in export or as the source data for a chart control. This does not appear possible.

7. Exporting to excel, csv etc.
see 6 above

8. print/pdf options
would need access to source data

9. save/reload user configuration data
possible with manual coding

10. filtering within row filter, column headers.
Not yet supported.

Thanks

answered on 07 Jul 2012, 01:18 PM

Hi,
The contribution of James is excelent and I would like to emphasize the suprisingly good performance and "Excel" pivot look.
That being said I would like to add the following to the list:

11 - OLAP support
I haven't been able to see that on the demos

12 - Possibility of creating a subset of information based on a couple of rows
This feature is interesting if I want to use multiple selection of rows, and see the "temporary" totals, avg, etc and the possibility to "group" those selected rows into a single row to evaluate it along with the rest of the information

I would like to suggest to the rest of the "testers" to keep posting their opinions and ideas here on this forum because this way we can share it with everyone.

answered on 09 Jul 2012, 09:40 AM

Hi,

Thank you all for the wonderful feedback.

@Keith - You should have received an email regarding the CTP. Enjoy.

@James

1. Drill through to obtain a list of source data. This feature is not available at the moment but it is listed on to-do list. Is this a must-have feature?

2. More than just summation... need counts, min max, Avg, median. All standard functions are available programatically. We are working on UI dialogs and menus that will allow users to easily choose any function.

3. Calculated fields. Currently not available. This one is also on our to-do list but it is unclear when we will be able to implements it. Is this a must-have feature?

4. control of sorting of data labels (columns and rows). Programatically available but at the moment custom code is needed. Working on providing UI dialogs and menus. By default, values are sorted in asceding order. If you would like to reverse the ordering you could try the following:

public Example02()

{

InitializeComponent();

var provider = this.pivotGrid.DataProvider as LocalDataSourceProvider;

var description = new PropertyGroupDescription() { PropertyName = "Product" };

description.GroupComparer = new MyComparer();

provider.RowGroupDescriptions.Add(description);

provider.Refresh();

}

public class MyComparer : GroupNameComparer

{

public MyComparer()

{

}

protected override Cloneable CreateInstanceCore()

{

return new MyComparer();

}

public override int CompareGroups(IAggregateResultProvider results, IGroup x, IGroup y, PivotAxis axis)

{

// reverse the default order

return base.CompareGroups(results, x, y, axis) * -1;

}

5. clickable links in data row headers and column headers. Could you please clarify this? Is it possible to provide a scenario for this one?

6. Access the summarised data to feed into a graph component. Possible but not user friendly. Will try to provide chart integration in the future. Is this a must-have for your scenarios?

7. Exporting to excel, csv etc. Not available. It is on our to-do list but unclear when we will be able to implement this. Is this a must-have for your scenarios?

8. print/pdf options. Will consider it for the future.

9. save/reload user configuration data. Will support RadPersistenceFramework in the future.

10. filtering within row filter, column headers. We are currently working on this and the next version will have many improvements regarding filtering.

@ carlos

11 - OLAP support . Currently not supported but we are working on this.

12 - Possibility of creating a subset of information based on a couple of rows. Interesting feature that we will consider for future implementation.

@Travis

We are working on OLAP support and we will try to make this feature available as soon as possible.

We also have supoprt for IQueryable which allows you to use Entity Framework (or other IQueryable) for performing grouping on the server. This allow us to have lighting-fast grouping plus extremely low memory consumption - actual entities are not downloaded to the client. For example, working with 1 million entities will have barely noticable effect on memory consumption. What do you think about this? Do you find it compelling? Unfortunately it is currently only available for WPF.

Thank you for your time. Keep the feedback coming.

All the best,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

answered on 10 Jul 2012, 12:46 PM

Hi Milan

Thanks for the detailed reply.

1. I think it is quite important. The Pivot Grid allows the user to summarise various datasets, but once areas of interest are identified, then the ability to investigate further is necessary. Whilst my comment is titled Drill Through.. I dont require the control to provide this feature in its complete form. So long as I could click on a cell and receive an event which provided some details on that cell such as column dimensions and row dimensions, then I can use this to access the data directly from the source system.

For me - Priority 1

2. Telerik currently working on short cut menus to enable use of alternative stats fields. Great. I think this would be my 1st or 2nd priority.

3. Calculated fields - I am happy to wait for this. Lower Priority.

4. THanks for the code - we can make that work.

5. clickable headers.. For example, one data source I have would contain data with dimensions for Job Number, Supplier, Tasks. So one (simplified) use of the Pivot Table would have Job Numbers as Row Headings, Suppliers as Column Headers and Count(Tasks) as the data values. It would be useful to be able to allow the user to click on the Job Number and then navigate to another screen which shows details for that specific Job Number.

6. 7. 8. All about accessing the summarised data. I dont need built in PDF, built in export, or built in charting.. access to the data will meet our requirements, as most of the implementation will be fairly customised.

For me - I think this is the 3rd most important after items 1 and 2 above.

Thanks - as asked by other users - any details on expected beta version, and then full release would be much appreciated.

answered on 10 Jul 2012, 03:12 PM

Hello,

@James - Thank you once again for the wonderful feedback. We will consider all requests and suggestions.

Since there is a huge demand for cube support we have updated our priorities and we will put more effort into this feature and also try to give you bits with cube support as soon as possible. Currently, I cannot commit to a certain date but we will try to have this working in a month or so. We will post more details when we are ready.

Regarding the release cycle of RadPivotGrid, we plan to have an official CTP (which will include additional features and bug fixes) in 2-3 weeks, after that we will have an official Beta. Most probably the Beta will be released with Q3. V1 will be released after the beta phase.

We believe that having CTP and Beta phases is crucial for matching your expectations and providing you with the best pivot control on the market. As you can see, we are pretty flexible about the features that will make it into the official release and we want to make sure that those features are the ones that you really need.

All the best,
Milan
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

answered on 10 Jul 2012, 06:06 PM

Hi Milan.

Thanks for keeping us updated.

As for the export feature I agree with James, it's not necessary at this point to have a built in - all good looking - export xls,pdf, etc.
A simple datatable (or list of objects of some class of yours) would be fine.
The component we are currently using has an export to file feature but we still create our own exports based on the data that it has because of specific layout needs.

Personally our company has this priorities:
1 - OLAP MDX support
2 - Export data
3 - Possibility to group (merge) selected rows into a single one (our clients have specific needs for this - for example when viewing thousands of rows of products they sometimes see products that are similiar (only colors differ for example) and they want to group all those colors into one single row of that product grouping all those rows to better compare the results along with the other products)
4 - [very low priority]
4.1 public events like:
cell selected
row selected
cell mouse over
4.2 allow adding aditional options to context-menu for a specific cell or set it's custom tooltip
4.3 for debugging purposes - some way of viewing the mdx query being executed

When the new update with olap support becomes available, please let me know and we will start more intensive tests to give you a more accurate and detailed report.

answered on 11 Jul 2012, 09:16 PM

@Milan

I forgot to mention another very important - high priority - feature for us:
Ability to export the current "configuration/view" - preferably a xml.

Our clients like to create "views" for repetitive (monthly, etc) analysis, basically they select the measures, dimensions, do the groupings,etc and then they save to their user area on the db the xml that the control we are currently using allows to export. That configuration state (xml) will be loaded each time the user want's to use that view (obviously the xml only contains the settings... the data is fetched from the database uppon loading the xml)

answered on 30 Jul 2012, 05:01 PM

Greetings Telerik - I have some questions and requests....

#1 - Need OLAP support

#2 - Need OLAP support ... (didn't copy paste that - very much need this :) ..

#3 - How come none of the demo/examples online shows a user defined filter criteria? When I add some dimension to as a to the "filter" box, it seems to have no effect - i.e., I get no ability to apply my filter. You have some filter example pages, but they are just hard coded button pushes.

#4 – Does this (or will this) pivot control have multi-select hierarchy controls that are similar to excel?

#5 – How much control do developers have over the style of individual parts of the “PivotFieldList”. So for example:

5.1: suppose I have a dimension that I want to show in RED font – Is that possible?

5.2: suppose I want to apply special business logic that removes dimension ‘Y’ from “Row Labels” automatically whenever dimension ‘X’ is added as a filter. Is that possible?

#6 – You point out that this control scales well with large datasets in one of your examples. But what about a massive dimension? For example, suppose I have a dimension with a million members. If I drop this on the Y-Axis, will this control break? If I drop it as a filter, and then uncheck just one item, will this control generate an exclusionary WHERE clause with just that one member? Or will it generate an inclusion list with the other 999,999 members?

#7, #8, #9 #10…. NEED OLAP Support J

Thanks!

answered on 31 Jul 2012, 07:01 AM

Hello All,

RadPivotGrid is public CTP now (available for ASP.Net, WinForms, WPF and Silverlight) and you can download it from "My Account" by downloading the lastest release (2012 Q2 SP1).

Demos are available here (for SL & ASP.Net):
http://demos.telerik.com/silverlight/#PivotGrid/Layouts
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx

Now is the time for feedback so please let us know what you think and what you need.

You can use this corresponding forum:
http://www.telerik.com/community/forums/wpf/pivotgrid.aspx
http://www.telerik.com/community/forums/silverlight/pivotgrid.aspx
http://www.telerik.com/community/forums/aspnet-ajax/pivotgrid.aspx
http://www.telerik.com/community/forums/winforms/pivotgrid.aspx

Regards,
Hristo
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 10 Aug 2012, 06:25 AM

Hi,

Currently it is not in our plans to include working with mdx queries. In the moment we are working very hard to provide support for cubes, but we will not have mdx expression editor or render user generated mdx queries. In fact could you share some details why do you need such queries and how do you plan to use them? Maybe we'll find a way to help you with the current planned features. Please share the details and we'll do our best to help you for this problem.
For your second question - the pivot will be available for ASP.NET and it will have support for ipad. Current version is not tested with it, but when we release the official one you shouldn't have any problems using it on ipads.

Thanks for evaluating RadPivotGrid! You can contact us if you have any other questions or suggestions.

Regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 10 Sep 2012, 03:14 PM

Hi,

Our RadPivotGrid will have OLAP support. In fact it is currently in development and hopefully it will be ready for our Q3 release (in October). You don't have to subscribe for that, you should download our official releases. As the RadPivotGrid is currently in development you can download our latest internal builds as well and use them, because we are trying to include all new features in these builds. You may follow our discussion in this forum and send us your feedback and suggestions how we could improve the RadPivotGrid.

Hopefully this helps.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 03 Sep 2015, 02:06 PM

Hi,
How to remove row from PivotGrid if data is empty or null ? Right now if property is null in Header Row have text '(blank)'
I want have row with different count leve. Right now I can have alway the same numbers of levels.For Example below want to show just two level:

PivotItem.TestDataLevel1 = 'Title 1';
PivotItem.TestDataLevel2 = 'Title 2';
PivotItem.TestDataLevel3 = null;

LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel1 ) });
LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel2 ) });
LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel3 ) });