Hello, i have some trouble with a part of my code.
Maybe it's something super easy, maybe not.
Some context before explanations:
i'm trying to create an app for my IT support teams. it's an app for referencing some actions.
It work, so good so far.
My boss would like different a view with different chart to control the amount of our action.
And now he would like to control the amount by time.
So my code for my charts it's like this :
AddColumns(
GroupBy(
AddColumns(
collectLHprobleme;"ass1";'assistance ou incident');
"ass1";"assistance ou incident");
"Number";CountRows('assistance ou incident')
)
work perfectly.

And i try something like that for time
Filter(collectLHprobleme;'datedereview' >= DatePicker1.SelectedDate And 'datedereview' < DatePicker1_1.SelectedDate)
and it work

but i can't do time and amount in the same time.
I hop someone have a solution for me.
regards
Arthur