Unanswered

Add Columns - Add Multiple Columns that are grouped Formula

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have SharePoint list with a few date columns (Date Reported, Date Approved and Date Closed ) .

I want to group the columns by month and show the amount of items for that month.

I was able to group one successfully and show it as a line in the graph but i want to show the other data points as overlaying lines/series. So ultimately I want to add other columns into this formula just not sure how to...thank you for your help!

Here is the formula i am using on the chart and in the picture

ITEMS=AddColumns(
GroupBy(
AddColumns(
Chart_RFC_Export,
"MonthName",
Text(
'Date Reported',
"[$-en-US]mmmm"
)
),
"MonthName",
"Grouped"
),

"Count",
CountRows(Grouped)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous ,

As below, but realise you can only add one of the grouped records per line - you can also use Last() if you want to

AddColumns( GroupBy( AddColumns( Chart_RFC_Export, "MonthName", Text( 'Date Reported', "[$-en-US]mmmm" ) ), "MonthName", "Grouped" ), "Count", CountRows(Grouped), "DateApproved", First(Grouped).'Date Approved', "DateClosed", First(Grouped).'Date Closed' )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thank you for your reply! I feel like it's almost there- i hope you can help me tweak a bit? I attached a picture. I updated the formula with how you told me to (changed the names but now i see them as series options. SO Thank YOU)

1) How do I get multiple lines (a line per series) to show on the same graph? (if possible) They have different count of items per month so they shouldn't be all on top of each other like in the image.
2) do you know why the dates are wonky? they are all the same year, so thats odd.

formula here, too :
AddColumns(
GroupBy(
AddColumns(
eRHA,
"MonthName",
Text(
'Date Forwarded',
"[$-en-US]mmmm"
)
),
"MonthName",
"Grouped"
),
"Count of Date Forwarded Per Month",
CountRows(Grouped),
"Count HRB Receives eRHA per month",
First(Grouped).'Date HRB Receives eRHA',
"Count Commander Approved per month",
First(Grouped).'Date Commander Approved'
)

thanks in advance! im so close :3

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Sorry, I do not use the graph feature in Power Apps (we use Power BI for that), so I cannot answer question 1 in any depth. Question 2 - one of the many reasons I do not use the "wonky" interface - I also found it difficult to display dates (amongst other things).

Was this reply helpful? Yes No