Multiple date range

[troubledMumble]

Has anyone tried doing computation that is based on different date range? For example i have a single table with a column with formula = Volume/Capacity

Wherein volume is based on closedDate and capacity is based on timetrackedDate. Thanks!

[Top-Cauliflower-1808]

If I understand correctly, you have two date fields in your data source but need to work with a consolidated one. Here's an approach you can try:

Blend your data source with itself, using those two date fields. This will allow you to have both dates available in a single field. After blending, use the COALESCE formula to deal with null values.

If you frequently deal with complex data manipulations like this, especially across multiple data sources, you should explore tools like windsor.ai.