cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aadilganie
Advocate V
Advocate V

Group and Filter Chart Data

Hi,

 

I am trying to show users a chart breakdown of their expenses by item type & total (sum) and filtered by their BudgetID.

I have managed to get the item type grouped but the chart now shows the series and lables as item type. How do I add the filter by budget ID and the total to the chart?

 

This is what I have so far:

GroupBy('Budget Management Details',"Item_x0020_Type_x0020_Text", "Item Type")

 

I know I may have to use the AddColumns function but keep getting the syntax incorrect.

 

Please assist!

1 ACCEPTED SOLUTION

Accepted Solutions
aadilganie
Advocate V
Advocate V

I think I have managed to figure it out with the following:

 

AddColumns(GroupBy(Filter('Budget Management Details',Budget_x0020_ID_x0020_Text = varLastID),"Item_x0020_Type_x0020_Text","Budget_x0020_ID_x0020_Text","ItemGroup"),"varTotal",Sum(ItemGroup,Total)),Budget_x0020_ID_x0020_Text)

 

Have had to add lookup columns as Text columns in the child list as could not read lookup columns in the group by. Not sure if there is a way aroun this...

View solution in original post

1 REPLY 1
aadilganie
Advocate V
Advocate V

I think I have managed to figure it out with the following:

 

AddColumns(GroupBy(Filter('Budget Management Details',Budget_x0020_ID_x0020_Text = varLastID),"Item_x0020_Type_x0020_Text","Budget_x0020_ID_x0020_Text","ItemGroup"),"varTotal",Sum(ItemGroup,Total)),Budget_x0020_ID_x0020_Text)

 

Have had to add lookup columns as Text columns in the child list as could not read lookup columns in the group by. Not sure if there is a way aroun this...

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (4,193)