Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be you need IntervalMatch to a calendar table
May be you need IntervalMatch to a calendar table
Thank you