This workflow demonstrates the usage of flow variables in the date and time nodes. Here the use case is to filter the last full week of data. Hence if you execute the workflow on wednesday you still only want to get the data until the last saturday.
We achieve this by first finding the last Sunday. This will be the enddate in our filter node.
Afterwards we use the information as a flow variable in the Date&Time-based Row Filter node. In addition we set the end of the filter to one week before the start date.
Hello @Hub, thank you very much for the nice explanation of the flow.
I understand how to use the flow variable to either set the start date or the end date. But, how could I use for example two Date&Time Widgets (one for the start date and one for the end date) to set the parameters for the Date&Time-based Row Filter.
I would like to use these two dates for adjusting the Line Plot in a component for date exploration.
Here you can see my challenge where I do not know, how to connect both dates with flows to the Filter:
Hello,
I just got an Idea how to do that
It is a little bit messy, but it seems to work.
I put two filters behind each other and attached the flow variables to each on (the first got the start connected and the second one the end: