Share
Report
24Hi all,
I'm trying to show data from my sharepoint list in a pie chart for columnR that is only for the previous week number rolling. By that I mean the data always shows the previous weeks data by week number.
ForAll(
Choices('MySharepointlist'.ColumnR) As A,
{
Number: CountIf(
ForAll(
'MySharepointlist',
ThisRecord.ColumnR.Value
) As B,
B.Value = A.Value
),
Value: A.Value
}
)
I've tried to add this before the main code for the pie chart but struggling to show the data
ClearCollect(
FilteredOrders,
Filter('MySharepointlist', WeekNumber(Week No.) = Today() - 7)
);
FilteredOrders,
Filter('MySharepointlist', WeekNumber(Week No.) = Today() - 7)
);
Categories:
I have the same question (0)
All responses (
Answers (
