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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to calculate the percentage of some numeric column in dashboard?

Platform: Dashboard Platform |
Control: Dashboard Datasources |
Published Date: August 16, 2018 |
Last Revised Date: August 16, 2018

By following the below procedure, you can calculate the percentage of numeric column.

 

1. Open the "Expression Designer" window to create an expression.

 

 

2. Enter the expression and finally click "Add" button to create a numeric expression like below.

 

 

3. Now the expression column will be show in the preview grid.

 

 

4. Next drag and drop the widget to design area and click the "Assign Data" option to get to the "Data" tab of the widget.

 

 

5. Bind the expression column and dimension column like below.

 

 

6. Click "Settings" menu in the expression column and then select "Format…" option.

 

 

7. "Measure Formatting" window appears. Now change the type as "Percentage" from "Number".

 

8. Set the decimal places using up and down arrow, finally click "OK".

 

 

9. Now values will be shown in percentage.

 

 

NOTE:   

Formatting option is restricted for "String" type columns and it will be shown only for numeric type columns. If you use CONCAT() function in your expression field, it indicates the created expression is in "String" format, so formatting option is not applicable for such case.   

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

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