4 Replies Latest reply on Oct 19, 2018 7:32 AM by Heano Kim

# How can I calculate the fixed minimum date from a filtered time range?

Hello,

This is my first time posting so please excuse anything I might have forgotten.

I am trying to calculate the overall minimum date for each tester given a filtered date range. In this example, I will be looking at all tests started on or after 10/1/2018.

As you can see below, in the second column [Min. Test Start Date], the earliest date I have from this filtered time frame is 10/1/2018. This column is not a calculated field but rather a quick measure (e.g. MIN([Test Start Date])). What I would like is for the third column [Days Worked (date)] to all say 10/1/2018.

For [Days Worked (date)], I attempted to calculate this using this formula below, but since it aggregates at the tester level, I get values that range as far back as 11/24/17. I am not very experienced with using the FIXED function so I am quite unsure which direction to head in.

How can I get the minimum date for each tester to all say 10/1/2018 given my filtered time range?

Any guidance would be appreciated. I will be quick to respond.

• ###### 1. Re: How can I calculate the fixed minimum date from a filtered time range?

Hi Heano

Try this formula and check its working or not

{Fixed: MIN(Test Start Date)}

This should repeat 10/01/2018 in all testers

• ###### 2. Re: How can I calculate the fixed minimum date from a filtered time range?

Hi Akram,

I tried implementing your formula, but this is the result that I get.

How can I set it up so that the formula will take into account the Test Start Date filter that I've set to 10/1/2018 - 10/31/2018?

• ###### 3. Re: How can I calculate the fixed minimum date from a filtered time range?

Ok. So you can try use the same date use have used in date range filter.

Ex:

{FIXED [Test Start Date] : MIN ([Test Start Date] )}

This should work dynamically even if you adjust the date filter

• ###### 4. Re: How can I calculate the fixed minimum date from a filtered time range?

I think I've tried this before... doing this returns all the test start dates for each tester.