Connecting data picker with excel spreadsheet and using the corresponding data

0
Hello, Can anyone tell me how to tell a date picker to refer to dates from an Excel spreadsheet? I want to be able to select a period of time and based on this period of time, the corresponding data from the spreadsheet should be used to create charts. Thanks!
asked
2 answers
0

You need to create a microflow that based on the two dates retrieves all the objects between those dates and then iterate over those to create the data for your charts. I would use a non persistent object for that.

Regards,

Ronald

 

answered
0

Thanks for your quick response.

Unfortunately I'm still a Mendix beginner, so maybe you can briefly explain to me how I build the microflows based on the two dates?

I would then try to solve the next steps by myself.

answered