Hi Team,
I am new to the charting in powerapps and need some help.
I need my chart to show the sum of OLEO produced and separated by Cut type and grouped by Date.
I got it to a point where it shows the sum of OLEO produced and grouped by Date but not separated by Cut Type.
It is currently one big sum for the day. How can i get this last piece into my formula?
AddColumns(
GroupBy(
AddColumns('OLEO KPI APP', "EntryDate", Date(Year(Date), Month(Date), Day(Date))),
"EntryDate", "theitems"),
"MonthCount", Sum(theitems, 'OLEO Produced')
)
Below is a sample of what the sharepoint list looks like.
Please help.
Thank you so much!
Dan
| Date | Oleo Produced | Cut Type |
| 3/18/21 | 62,500 | 1 |
| 3/18/21 | 94,300 | 2 |
| 3/18/21 | 42,300 | 1 |

Report
All responses (
Answers (