Chart with ColelctionItem doesnt show up

(0) Share

Report

Posted on by RiccoHipp1903

284

Hello guys,

I encountered the following problem.

What I want to try:

Display a chart from a sharepoint List/Document Libary based on Categories (Choice Fields). E.g. 4 are draft, 3 are send, 5 are denied.

Idea:

making a collection with those piece of Information I need

Textfield:
CountRows(
 Filter(
 Antrag,
 Status.Value = "XYZ" && Created >= Today() - 365
 )
)

Collection:
ClearCollect(
 statistikAntrag,
 {Kategorie: "Open", Amount: Textfield.Text},
 {Kategorie: "Denied", Amount: Textfield2.Text},
 {Kategorie: "Approved", Amount: Textfield3.Text}
);

The Problem I encountered:

If I insert a Pie Chart and set the Items to the Collection, the pie is invisible.