How to include value zero group by collection

(0) Share

Report

Posted on by moerah

327

Hi all

how can I add 0 value in the collection for charts?

ClearCollect(
 colAllValues,
 ForAll(
 NWAllocation,
 AllocatedTo.Value
 )
);

ClearCollect(
 colNewUserNo,
 AddColumns(
 colAllValues,
 "SResult",
 If(
 Value = "Sa" ||
 Value = "Be" ||
 Value = "Wi" ||
 Value = "Di" ||
 Value = "Es" ||
 Value = "Je" ||
 Value = "Jo" ||
 Value = "Ji" ||
 Value = "Ju" ||
 Value = "Lo" ||
 Value = "Ma" ||
 Value = "Ni" ||
 Value = "Nm" ||
 Value = "Ru" ||
 Value = "Sa" ||
 Value = "Sh" ||
 Value = "Sl" ||
 Value = "So" ||
 Value = "Sy" ||
 Value = "Th",
 1,
 0
 )
 )
);

ClearCollect(
 colGroupResult,
 DropColumns(
 AddColumns(
 GroupBy(colNewuserNo, "Value", "GroupedValue"),
 "SResult",
 Sum(GroupedValue, SResult)
 ),
 "GroupedValue"
 )
);

like to include user with 0 result in chart

thank you

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

BDallas 74 on at

Like
a
(0)

Report
Copy link

Link copied!
@moerah you can add 0 by including Collect(colGroupResult, {Value: "0", SResult: 0}) to your code

ClearCollect( colAllValues, ForAll( NWAllocation, AllocatedTo.Value ) ); ClearCollect( colNewUserNo, AddColumns( colAllValues, "SResult", If( Value = "Sa" || Value = "Be" || Value = "Wi" || Value = "Di" || Value = "Es" || Value = "Je" || Value = "Jo" || Value = "Ji" || Value = "Ju" || Value = "Lo" || Value = "Ma" || Value = "Ni" || Value = "Nm" || Value = "Ru" || Value = "Sa" || Value = "Sh" || Value = "Sl" || Value = "So" || Value = "Sy" || Value = "Th", 1, 0 ) ) ); ClearCollect( colGroupResult, DropColumns( AddColumns( GroupBy(colNewuserNo, "Value", "GroupedValue"), "SResult", Sum(GroupedValue, SResult) ), "GroupedValue" ) ); Collect(colGroupResult, {Value: "0", SResult: 0})

If this solves your question, please accept it as a solution.
Thanks!
Dallas
moerah 327 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @BDallas for the reply

unfortunately, it's not working the way I want it's just displaying 0-0
BDallas 74 on at

Like
a
(0)

Report
Copy link

Link copied!
@moerah Please try this modified code.
ClearCollect( colAllValues, ForAll( NWAllocation, AllocatedTo.Value ) ); ClearCollect( colNewUserNo, AddColumns( colAllValues, "SResult", If( Value = "Sa" || Value = "Be" || Value = "Wi" || Value = "Di" || Value = "Es" || Value = "Je" || Value = "Jo" || Value = "Ji" || Value = "Ju" || Value = "Lo" || Value = "Ma" || Value = "Ni" || Value = "Nm" || Value = "Ru" || Value = "Sa" || Value = "Sh" || Value = "Sl" || Value = "So" || Value = "Sy" || Value = "Th", 1, 0 ) ) ); ClearCollect( colGroupResult, DropColumns( AddColumns( GroupBy(colNewuserNo, "Value", "GroupedValue"), "SResult", Sum(GroupedValue, SResult) ), "GroupedValue" ) ); ClearCollect( colGroupResult, AddColumns( colGroupResult, "Value", "0", "SResult", 0 ) )

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!