web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Bar chart Data Source ...

Power Apps

Answered

Bar chart Data Source - Grouping by Date

(0) Share

Report

Report

Posted on by tapper

28

Hey guys,

I was wondering if someone could help me with the final peace of the puzzle for a Bar Chart data source.

Im using the below formula to pull through the chart items, which is correctly pulling in the journey and steps for the app user. However ideally I'd like to group the number of steps per day, so that there are no duplicate journey dates.

I've attached the an image of the the below formula's results.

Thank you in advance 😄

Sort(
Filter(
ShowColumns(
WellbeingStepsChallenge_StepsLog,
"JourneyDate",
"Steps",
"UserEmail"
),
User().Email in UserEmail
),
JourneyDate,
Descending
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@tapper

You'll want to begin my adding this code to the OnStart property of your app to store the User's email in a variable.

Set(varUserEmail, User().Email)

Then put this code in the Items property of your Chart

DropColumns( AddColumns( GroupBy( Filter(Wellbeing_StepsChallenge_StepsLog, UserEmail=varUserEmail), "JourneyDate", "GroupedDates" ), "Sum of Steps",Sum(GroupedDates, Steps) ), "GroupedDates" )

You can learn how to GROUP BY and SUM tables of data here. I adapted this method to your problem.

https://matthewdevaney.com/powerapps-collections-cookbook/group-by-and-find-the-sum/

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
tapper 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney

Thank you so much for your help with this.... It worked perfectly you genius!

Thanks again

Join the conversation