Use an island table to look up a date range, and pass that to a chart?
I have a weather app with data imported from IOT devices. I would like to know if it would be possible to add an island table that contains work order numbers, start dates, and end dates. The idea is that I could provide a drop-down list of work orders and the user could select one, which would pull up the start and end dates for that work order which would be used to define a date range to filter the chart. Would this be possible? If so, could you provide an example?
Hi @rubenmarin . Thanks for your suggestion but I'm getting a syntax error; can you take a look? I just copy/pasted your expression and the syntax error shows up whether I keep your field names or replace with my own, so it seems like a true syntax error and not related to the field names.