Get Parent Aggregate Count in Child Grouping
Hi there,
I would like to be able to calculate sub-group proportions.
In the example below, there is a group by the Parent column and the Count is 8.
Next, there is a sub-group on the Child column, and the Counts are 7, and 1, respectively.
In the sub-group caption, I want to show
- Sub Group 1 : 7 (87.5%)
- Sub Group 2 : 1 (12.5%)
The problem is, when creating the caption at the sub-group level , the CaptionTemplateContext does not contain any information which would enable me to calculate counts at the parent level
That is, I can't calculate 7/8 = 0.875 because I cannot find out that the parent count is 8.
Is there a way to solve this?
|
<SfGrid DataSource="@Products" AllowGrouping="true" AllowPaging="true">
<GridGroupSettings Columns=@Units>
<CaptionTemplate>
@{
var order = (context as CaptionTemplateContext);
if (order.Level == 1)
{
TopParentCount = order.Count;
<div>Parent Grouping - @order.Count</div>
}
else if (order.Level == 2)
{
Calculated = (order.Count / TopParentCount);
<div>Sub Grouping - @order.Count :- @Calculated</div>
}
}
</CaptionTemplate>
</GridGroupSettings>
<GridColumns>
<GridColumn Field=@nameof(Product.ProductName) HeaderText="Product Name" TextAlign="TextAlign.Right" Width="120"></GridColumn>
. . .
</GridColumns>
</SfGrid>
@code{
double TopParentCount { get; set; } = 0; // for getting parent aggregate count value
double Calculated { get; set; } // for calculating value for subgroup
public List<Product> Products { get; set; }
private string[] Units = (new string[] { "QuantityPerUnit", "ProductName" });
. . .
} |
 |
Hi Rahul,
The sample you have provided is wrong. Here is an example screen shot from your sample:
As you can see, there are 6 items, spread across 5 groups, under this Parent Grouping.
The goal is to shown what percent of items (count) is in each sub grouping. The desired output (for the example above is)
- Subgroup - 1 item (16.7%)
- Subgroup - 1 item (16.7%)
- Subgroup - 1 item (16.7%)
- Subgroup - 2 item (33.3%)
- Subgroup - 1 item (16.7%)
Does that make sense?
