I want to build an interactive dashboard for our organization and I ended up with Retool for that.
At the moment I have already linked 1 resource (warehouse management system) and I can retrieve the correct information.
I want to make a widget that tells how many pick lists are still open. I want to do this by counting the number of different idpicklists and displaying them in a presentation widget. I can do this in a chart because it contains an aggregation function, but this does not yet work in a performance widget.
Who can help me?