Good day
I created a collection for my line chart as follows:
ClearCollect(CREQE_FormCollection, CREQE_Form);
ClearCollect(
CREQE_FormWithMonthYear,
AddColumns(
CREQE_FormCollection,
MonthYear,
Text('Date of Request', "[$-en-US]yyyy-mm")
)
);
ClearCollect(
GroupedData,
AddColumns(
GroupBy(
CREQE_FormWithMonthYear,
MonthYear,
GroupedItems
),
MonthlyTotal,
Sum(
GroupedItems,
"SubmissionAmount"
)
));
This syntax gives no errors except the collection table is showing [Object object] under the MonthlyTotal field and I don't think this is right.
I get errors if I put double quotes quotes like so: ClearCollect(CREQE_FormCollection, CREQE_Form);
ClearCollect(
CREQE_FormWithMonthYear,
AddColumns(
CREQE_FormCollection,
"MonthYear",
Text('Date of Request', "[$-en-US]yyyy-mm")
)
);
ClearCollect(
GroupedData,
AddColumns(
GroupBy(
CREQE_FormWithMonthYear,
"MonthYear",
"GroupedItems"
),
"MonthlyTotal",
Sum(
GroupedItems,
Value(SubmissionAmount)
)
)
);
Items: GroupData
Series: MonthTotal
Label is MonthYear
Please help
