Calculate percentages
14 Replies
Hi Anis,
We are unable to reproduce the reported problem at our end. So, we have prepared a sample as per your requirement, which is available in the below link.
Note: If you want to set “Percentage” format means, you can set by using the property Format. Please refer below code snippet.
|
@(Html.EJ().Pivot().PivotClient("PivotClient1")
.DataSource(dataSource => dataSource
.Rows(rows => { rows.FieldName("Id").FieldCaption("Id").Add(); })
.Columns(columns => { columns.FieldName("Customer").FieldCaption("Customer").Add(); })
.Values(values => { values.FieldName("Percent").FieldCaption("Percent").Format("percentage").Add(); }))
.Title("Generate Report Finissage").ClientSideEvents(oEve =>
{
oEve.RenderSuccess("setChartProperties")
.Load("onLoad")
.BeforeExport("Export")
.SaveReport("reportSettings")
.LoadReport("reportSettings")
.FetchReport("reportSettings");
}).IsResponsive(true)) |
In the sample, we have added percentage fields in PivotClient using entity framework and its work fine at our end. Please refer the below code snippet and screenshot.
Code Snippet:
|
[HttpPost]
public JsonResult GetData()
{
var data = db.Order.Select(o => new
{
Id = o.Id,
Customer = o.Customer,
DateExport = o.DateExport,
Qty = o.Qty,
Percent = (o.Qty/o.Id) * 100
});
return Json(data, JsonRequestBehavior.AllowGet);
} |
Screenshot:
If still the problem exists, kindly send your sample that replicating the problem (or) reproduce the problem in the provided sample and revert us. This would be a very helpful for us to investigate the reported problem at our end and provide the solution at earliest.
Thanks,
Manikandan.
Hi Anis,
Sorry. Still, we can’t able to reproduce the reported problem at our end. So, kindly check the below possibilities in your side.
- Check the JSON data side in AJAX success method which returns actual result (or) not (which is returned from server). Please refer below screenshot.
Screenshot:
- There is no need to multiply your values with 100 in GetData() method, while using percentage format. Because, we are multiplying values with 100 in source level, while applying percentage format. Please refer below screenshot.
Screenshot:
If still the problem exists, we kindly request you to send your sample replicating the problem (or) reproduce the problem in the sample attached in our previous update. This would be helpful for us to investigate the problem at our end and provide you the solution at the earliest.
Thanks,
Manikandan.
Hi Anis,
Thank you for your sample.
Please find our below response.
|
S.No |
Query |
Response |
|
1.
|
I already add the line and values I need, but I get false percent values, and when I add other fields, I always have false values.
|
We have checked your sample where the JSON data in AJAX success having ‘0’ value for percentage fields. So, PivotClient plots only ‘0’ value for those fields. Please find the below screen-shot for your reference.
   So, kindly revisit the calculations of percentage fields in server side and pass the data source with correct values to PivotClient control.
|
|
2.
|
There is another problem in this example, when I try to drag and drop other fields to the line, the browser displays an error message.
|
We are unable to reproduce any error message on drag and drop operation. Please find the below video for your reference.
So, kindly provide us the exact replication steps to reproduce the issue with screen-shot/video if possible. Also kindly try different browsers as well and let us know on the same.
|
Thanks and Regards,
Ramesh G
Currently, we don’t have direct support for percentage calculations based on total value. But, you can achieve this using Calculated Field option at sample level. Please refer below code snippet and screenshot.
Code Snippet: [cshtml]
|
@(Html.EJ().Pivot().PivotClient("PivotClient1")
.DataSource(dataSource => dataSource
.Rows(rows => { rows.FieldName("Customer").FieldCaption("Customer").Add(); })
.Values(values =>
{
values.FieldName("Red").FieldCaption("Red").Add();
values.FieldName("Green").FieldCaption("Green").Add();
values.FieldName("Blue").FieldCaption("Blue").Add();
values.FieldName("Yellow").FieldCaption("Yellow").Add();
values.FieldName("Total").FieldCaption("Total").Add();
values.FieldName("percentRed").FieldCaption("percentRed").Format("percentage").IsCalculatedField(true).Formula("Red/Total").Add();
values.FieldName("percentGreen").FieldCaption("percentGreen").Format("percentage").IsCalculatedField(true).Formula("Green/Total").Add();
values.FieldName("percentBlue").FieldCaption("percentBlue").Format("percentage").IsCalculatedField(true).Formula("Blue/Total").Add();
values.FieldName("percentYellow").FieldCaption("percentYellow").Format("percentage").IsCalculatedField(true).Formula("Yellow/Total").Add();
})).DisplaySettings(ds=>ds.DefaultView(PivotClientDefaultView.Chart))
.Title("Controle Mesure cm").ClientSideEvents(oEve =>
{
oEve.RenderSuccess("setChartProperties")
.Load("onLoad")
.BeforeExport("Export")
.SaveReport("reportSettings")
.LoadReport("reportSettings")
.FetchReport("reportSettings");
}).IsResponsive(true).EnableAdvancedFilter(true)) |
