We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Legend for group items

Thread ID:

Created:

Updated:

Platform:

Replies:

132133 Aug 15,2017 01:44 PM UTC Aug 21,2017 11:29 AM UTC Dashboard Platform 6
loading
Tags: Dashboard Widgets
Peritus
Asked On August 15, 2017 01:44 PM UTC

Hi
1. When I render a Pivot or Chart with a group by (using dashboard), the legend for the grouped quantity is "Sum ...." or "Total of....", irrespective of the selection, Max, Min, Average. Can this legend be customised?

2. Can A pivot table be paged? I have a simple data value captured for 30 items, every day for last three months.
e.g 
DeviceID   Value  Date
Dev1            1         2017-06-01
Dev1            2         2017-06-02
Dev2           3.4       2017-06-01
... so on for 30 devices from Jun 1 till date.
I create pivot grid, with date in columns (1..31) and months with device id in rows.
In the deployment under IIS or under preview, the table does not load .. at least I got tired of waiting.
The data is rendered perfectly in the designer during design time

Any suggestions?
Regards


Peritus
Replied On August 15, 2017 03:08 PM UTC

Hi
1. When I render a Pivot or Chart with a group by (using dashboard), the legend for the grouped quantity is "Sum ...." or "Total of....", irrespective of the selection, Max, Min, Average. Can this legend be customised?

2. Can A pivot table be paged? I have a simple data value captured for 30 items, every day for last three months.
e.g 
DeviceID   Value  Date
Dev1            1         2017-06-01
Dev1            2         2017-06-02
Dev2           3.4       2017-06-01
... so on for 30 devices from Jun 1 till date.
I create pivot grid, with date in columns (1..31) and months with device id in rows.
In the deployment under IIS or under preview, the table does not load .. at least I got tired of waiting.
The data is rendered perfectly in the designer during design time

Any suggestions?
Regards


Attached a dashboard connecting to adventure works connection name, retail sales anaysis (random data)


SELECT
 [dbo_RetailSalesAnalysis20151027180914017].[ProductCategoryName] AS [dbo_RetailSalesAnalysis20151027180914017_ProductCategoryName]
 ,[dbo_RetailSalesAnalysis20151027180914017].[Country] AS [dbo_RetailSalesAnalysis20151027180914017_Country]
 ,[dbo_RetailSalesAnalysis20151027180914017].[SalesAmount] AS [dbo_RetailSalesAnalysis20151027180914017_SalesAmount]
 ,[dbo_RetailSalesAnalysis20151027180914017].[SalesTargetAmount] AS [dbo_RetailSalesAnalysis20151027180914017_SalesTargetAmount]
 ,[dbo_RetailSalesAnalysis20151027180914017].[Continent] AS [dbo_RetailSalesAnalysis20151027180914017_Continent]
 ,[dbo_RetailSalesAnalysis20151027180914017].[SalesDate] AS [dbo_RetailSalesAnalysis20151027180914017_SalesDate]
 FROM
 [dbo].[RetailSalesAnalysis20151027180914017] AS [dbo_RetailSalesAnalysis20151027180914017]

Illustrates both problems.

It says Row Total, instead of Max or Min and does not expand the groups



Attachment: advnetureWorksSAlesbyYearByMOnthByDate_4df12f35.7z

Renuka N [Syncfusion]
Replied On August 16, 2017 11:41 AM UTC

Hi Peritus, 

Query 
Response 
When I render a Pivot or Chart with a group by (using dashboard), the legend for the grouped quantity is "Sum ...." or "Total of....", irrespective of the selection, Max, Min, Average. Can this legend be customised? 
Yes we can customize “Sum of Column” and “Max.Column” text  in PivotGrid and Chart widgets. Please refer the following UG links to achieve your requirement. 

PivotGrid: 


 


Chart: 
 

 

Can A pivot table be paged? I have a simple data value captured for 30 items, every day for last three months. 
e.g  
DeviceID   Value  Date 
Dev1            1         2017-06-01 
Dev1            2         2017-06-02 
Dev2           3.4       2017-06-01 
... so on for 30 devices from Jun 1 till date. 
I create pivot grid, with date in columns (1..31) and months with device id in rows. 
In the deployment under IIS or under preview, the table does not load .. at least I got tired of waiting. 
The data is rendered perfectly in the designer during design time 

We can reproduce the reported issue of “Data will not load after drilldown of PivotGrid” and logged bug report for the issue which will be available in our release estimated on first week of September, 2017. 

Regards, 
Renuka N. 


Peritus
Replied On August 16, 2017 02:34 PM UTC

Hi Peritus, 

Query 
Response 
When I render a Pivot or Chart with a group by (using dashboard), the legend for the grouped quantity is "Sum ...." or "Total of....", irrespective of the selection, Max, Min, Average. Can this legend be customised? 
Yes we can customize “Sum of Column” and “Max.Column” text  in PivotGrid and Chart widgets. Please refer the following UG links to achieve your requirement. 

PivotGrid: 


 


Chart: 
 

 

Can A pivot table be paged? I have a simple data value captured for 30 items, every day for last three months. 
e.g  
DeviceID   Value  Date 
Dev1            1         2017-06-01 
Dev1            2         2017-06-02 
Dev2           3.4       2017-06-01 
... so on for 30 devices from Jun 1 till date. 
I create pivot grid, with date in columns (1..31) and months with device id in rows. 
In the deployment under IIS or under preview, the table does not load .. at least I got tired of waiting. 
The data is rendered perfectly in the designer during design time 

We can reproduce the reported issue of “Data will not load after drilldown of PivotGrid” and logged bug report for the issue which will be available in our release estimated on first week of September, 2017. 

Regards, 
Renuka N. 


Hi

1. Pivot lables: Please see the screen shot - highlighted parts

2. For Chart, my apologies, I forgot to mention "Pie Chart". Please see attached highlighted

Let me know if these are customisable.

Regards


Attachment: Forum_query_48b991d1.7z

Renuka N [Syncfusion]
Replied On August 17, 2017 01:11 PM UTC

Hi Peritus, 

Query 
Response 
Pivot lables: Please see the screen shot - highlighted parts 
We have considered your requirement of “Customize Summary Header text of PivotGrid” as a feature and logged report for the same. This feature will be available in any one of our releases. 
 For Chart, my apologies, I forgot to mention "Pie Chart". Please see attached highlighted 
We have considered your requirement of “Customize measure field name in Header text of Propotional Chart” as a feature and have logged feature report which will be available in one of our upcoming releases.  

NOTE: Header text customization will not be applied to dimension values. While render chart with series like the following image. We couldn’t change Header text of Pie Chart, since header text represents dimension value not dimension field name in the scenario. 

 


Please let us know, if you have any concerns. 

Regards, 
Renuka N. 


Peritus
Replied On August 19, 2017 01:28 AM UTC

Thanks

Hope to see these implemented soon

Regards


Renuka N [Syncfusion]
Replied On August 21, 2017 11:29 AM UTC

Hi Peritus, 
We will let you know once these features are implemented. Appreciate your patience until then. 

Thanks, 
Renuka N. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;