Bar chart Data Source - Grouping by Date

(0) Share

Report

Posted on by tapper

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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@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."

Was this reply helpful? Yes No
tapper 28 on at

Like (0)

Report

Hi @mdevaney

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

Thanks again

Was this reply helpful? Yes No