Can i calculate columns using Dashboard Designer?

[kinnaree]

Can i calculate columns using Dashboard Designer?

[Vimala Mary Maria Susai]

Hi Kinnaree, 

 

Thank you for your interest in Syncfusion products.  

  

Yes. Through Expression Designer in Dashboard Designer, you can create calculated columns and configure to widgets like other normal columns. Please refer to the below link to know more about this. 

 

https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-expression-columns 

 

Regards, 

Vimala  

[frank van den bergh]

If I read the documentation correctly, you can create expressions only based at the same level.

Is it also possible to perform calculations based on the underlying records?

Please let me explain my situation. I've a table with transport orders, a transport order is stored as multiple records (load parcel x of 30 kg at location y, unload parcel x of 30 kg at location z). When I want to show the kg per week I want to group by the parcelID in that particular week, get the max kg per parcel, and finally sum its values.

[Vimala Mary Maria Susai]

Hi Kinnaree, 

  

Please try this workaround (assumed data are used here) to show the “kg per week using group by the parcelID in that particular week, get the max kg per parcel, and finally sum its values”. Please follow the below steps to create the expression.  

1.      Create the expression for max weight and total count of parcel. Enter the expression that you like to define in the Expression text area  

Example for max weight: MAX([Weight]) 

Example for and total count of parcel: COUNT([ParcelID]) 

2.      Drag and drop a pivot grid from the toolbox. 

3.      Drag and drop delivered date field into Row(s) and click the setting button to change the “Week of Year” option to provide total weeks in the year. 

 

4.      Also drag and drop the needed columns to the Row(s) and Column(s) 

5.      Values will be shown in pivot grid widget like this below mentioned screenshots. 

 

Please try this and let us know if this works. If the provided workaround is not works then share us the sample data, so that it would help us to investigate further at our end.  

 

Regards, 

Vimala  

 

 

[Dustin Dibble]

Hi,

New to syncfusion. I have a question that relates to the above

I have a category and within that category are multiple subcategories.

I want to create an expression subtracting one subcategory from the other. How do I do that? Only "category" comes up in the expression pane. I cannot seem to dig down to do an expression on any of the subcategories within.

Thanks,

Dustin

[Vimala Mary Maria Susai]

Hi Dustin, 

 

Please try the below workaround to show the “create an expression subtracting one subcategory from the other category” and follow the below steps to create the expression.  

1.      Create an expression for subcategory. Enter the expression that you like to define in the Expression text area 

Syntax: IF(expression, true_part, false_part) 

Example: IF([Category]='Cricket',[Category],' ') 

 

2.      Drag and drop a grid from the toolbox. 

3.      Also drag and drop the needed fields to the Column(s) 

4.      Values will be shown in grid widget like this below mentioned screenshots. 

 

 

Please try this and let us know if this works. If the provided workaround doesn’t work then share us the sample data, so that it would help us to investigate further at our end.  

 

Please let us know if you require further assistance.       

 

Regards, 

Vimala