Create a Chart showing status values from a selection column

(0) Share

Report

Posted on by RyanJ1

108

Hello,

I am attempting to create a column chart to reflect the total of each status, and grand total, of items. My "Status" column contains the following choices: "New", "In Progress", "Complete", "Closed", and "Suspended". I have attempted several different functions based on research of this topic (I am NOT experienced whatsoever!). My last attempt at a solution before this post was to build a collection in the app.OnStart as follows:

ClearCollect(
 colStatusTotal,
 Sum(
 If(Item.Value in 'G4 Task Tracker List'.Status.Value ="New",Value("1"),Value("0")),
 If('G4 Task Tracker List'.Status.Value="In Progress",Value("1"),Value("0")),
 If('G4 Task Tracker List'.Status.Value="Complete",Value("1"),Value("0")),
 If('G4 Task Tracker List'.Status.Value="Closed",Value("1"),Value("0")),
 If('G4 Task Tracker List'.Status.Value="Suspended",Value("1"),Value("0"))))

However, I receive an error for "Item.Value", all ".Value" entries, and all "=" entries.

The first "If" statement is different because I attempted a different entry, which still reflects the same errors.

Any recommendations for building a chart, or assistance with my current progress would be greatly appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @RyanJ1,

Could you please share a bit more about your scenario?

Do you want to count for items of each status?

You could use the GroupBy() function to grant each status and count for each group.

Set the Items property of the column chart as below:

AddColumns(GroupBy(AddColumns(ListName, "StatusText", Status.Value),"StatusText", "GroupData"), "CountStatus", CountRows(GroupData))

Was this reply helpful? Yes No
Verified answer

RyanJ1 108 on at

Like (0)

Report
@v-qiaqi-msft

This is exactly what I am looking for, thank you! For some reason, the formula only works if I copy and paste what you provided, but it still works!

I'm attempting to apply the same logic to a pie chart to reflect the quantity of tasks assigned to each department. My department column (named "Section") is a multi-select column with 5 choices. I still run into the same errors with anything I try, and I assume I need to Concat in some fashion since the referenced column is a mulit-select. How far off is my formula?:

AddColumns(GroupBy(AddColumns('G4 Task Tracker List', "SectionText", Concat(Section.Text(Value)), "SectionText", "GroupData"), "CountSection", CountRows(GroupData)))

Regards,

RyanJ

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @RyanJ1 ,

We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue.

It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding.

Was this reply helpful? Yes No
RyanJ1 108 on at

Like (0)

Report

@v-qiaqi-msft ,
My apologies, I am still new to this. Thanks again for the help on my previous issue!

Sincerely,
RyanJ

Was this reply helpful? Yes No