Hello everyone,
My goal is to have a simple column chart that has filters.
I was able to do the first requirement which was to count all the Open and Closed status using this formulas below.
On the onchange property of my dropdown when its equals to All Requests.
If(
//condition
drpFilter_1.Selected.Category = "All Requests",
//true---------------------------------------
//Collect list via requeststatus
ClearCollect(
colRequestStatus,
ForAll(
Distinct(
'Enquiries Improvement Request',
RequestStatus.Value
),
{Result: ThisRecord.Value}
)
);
//Collect all request count
ClearCollect(
colRequestCount,
AddColumns(
colRequestStatus,
"Count",
CountRows(
Filter(
'Enquiries Improvement Request',
RequestStatus.Value = colRequestStatus[@Result]
)
)
)
);Set(timerStart,true);,
//false---------------------------------------
Set(timerStart,true);
)
items property of the chart:
colRequestCount
Now my problem is that I do not know what to do when other categories are selected in the dropdown. Ive tried several attempts to this however to no success I am stuck. I want to be able to present only the Open and Closed Request status of the selected category in the dropdown.
