Hi Community,
I am working on an internal project for Task tracking where my data source is a SharePoint list. I am trying to create an analytics screen to show the data for Task Status (Open, Closed, Cancelled, in progress) which is the choice column, and AI group again which is the choice column filtered by dates from and To. Tried to find on the web a solution and leads to achieving this but didn't find one.
The following is created in an Excel chart could this be possible in power apps along with Table filtered with date pickers from and to
I have tried to create a collection of 2 choice columns and a Date column for now and the same data needs to be used to display in a column chart
my X-Axis needs AI Group (Choice )
Y-Axis -count
Legend - Task Status (choice)
I tried to use the following code but this gives me only a count of 1 choice column though
AddColumns(
GroupBy(
AddColumns(
Filter(
'CollListColumns',
field_1 >= DatePicker1.SelectedDate&& field_1 <= DatePicker2.SelectedDate
),
"Vfield_10",
field_10.Value
),
"Vfield_10",
"Group"
),
"Count",
CountRows(Group)
)
need help to develop a code that can club both choices columns' data and filter the same with date range
my X-Axis needs AI Group (Choice )
Y-Axis -count
Legend - Task Status (choice)
Thanks in advance 🙂
