Hello there!
I have some date as a data subset form and I need to create a pie chart which show which contract are overdue and which not .This pie chart need to be drilldown to a grid which list only the contract on the selected category.
The data are these:
local!contrat: todatasubset({ a!map(id: 1,name: "Contract A",,deadline: today()-6,status: "Decline"), a!map(id: 2,name: "Contract B",,deadline: today()-20,status: "Open"), a!map(id: 3,name: "Contract C",,deadline: today()-2,status: "Draft"), a!map(id: 4,name: "Contract D",,deadline: today()+28,status: "Open"), a!map(id: 5,name: "Contract E",,deadline: today()-30,status: "Complete"), },
How can I do the grouping with this format of data?
Thank you in advance
Discussion posts and replies are publicly visible