Single Datefield (periode/date range) for start and end date

[mwittmann]

Hello experts,

i'm struggeling with the following for a long time. Herhaps anyone can help me. This would be great.

This is my table:

Values
Id
Start
End
Value

What i want to see is the average development of "value" by time. So i need a single datefield as a range depending on start and end.

By filtering a year or month of the periode, all value with 

periode<=start and periode >=end 

should be shown...

I think a third datefield as a daterange and a Set function which only shows the values with "start" and "end" within the timerange.

Thank you really much. I appreciate any advice.

Marcel.

[sunny_talwar · Accepted solution]

May be you need IntervalMatch to a calendar table

[mwittmann]

Thank you