Create Chart by Dates

(0) Share

Report

Posted on by RJF61

1,265

I have the following which generates a Chart from all data in a SharePoint List. Each SharePoint List item has a Created value; so, I would like to also crate a Chart based on Start and End "Created" values. How do I incorporate into info below?

ForAll(

GroupBy(

SLAMChartSummary,

OMGrp,

ByGroup

{

OMGrp: OMGrp,

SumofNoSlams: Sum(

ByGroup,

Value(NoSlams)

)

}

)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @RJF61 ,

Please try:

ForAll( GroupBy( AddColumns(SLAMChartSummary,NewCreatedColumn,Text(Created,"yyyy-mm-dd")), NewCreatedColumn, ByGroup ), { OMGrp: OMGrp, SumofNoSlams: Sum( ByGroup, Value(NoSlams) ) } )

Best Regards,

Bof

Was this reply helpful? Yes No