7 Replies Latest reply on Oct 6, 2013 11:05 AM by . Indumon

# calculate max num of a series of numbers within a start date and end date range

I have two parameters (start date and end date)

I also have a list of records as below.  I am not displaying teh data in a table in Tableau.  I am graphing the data but need to figure out the computed field as I am asking below.

Trying to get the max  no_of_domain_register_user for the list of records between the start date and end date range.  For example, if my start date is Sep 14, 2013 and end date is Sep 17, my calculated field max ( no_of_domain_register_user) would return 28459.  Any timely tips would be greatly appreciated.

domain_name    no_of_domain_register_user    Day of domain_aggregation_dt    Year of domain_aggregation_dt

abc.com    12343    September 10, 2013

abc.com    28454    September 14, 2013

abc.com    28455    September 15, 2013

abc.com    28456    September 16, 2013

abc.com    28459    September 17, 2013

abc.com    28532    September 18, 2013

abc.com    28552    September 19, 2013

abc.com    28553    September 20, 2013

• ###### 1. Re: calculate max num of a series of numbers within a start date and end date range

Faysal,  If you are using parameters to input start date and end date then below formula will return the max "No of Domain Registered User"

Parameter 1. Start Date

Patameter 2: End Date

MaxValue by parameter=

Max(If [Date]>=[Start Date] And [Date]<=[End Date] Then [no_of_domain_register_user] End)

• ###### 2. Re: calculate max num of a series of numbers within a start date and end date range

Thanks for the reply, but it is giving me the max per date.  I want the max

value across several dates within a date range.

Below is the result when I applied the formula:

domain_name    no_of_domain_register_user    Day of

domain_aggregation_dt    Year of domain_aggregation_dt    Calculation1

abc.com    28456    September 16, 2013    2013    28,456

abc.com    28459    September 17, 2013    2013    28,459

abc.com    28532    September 18, 2013    2013    28,532

abc.com    28552    September 19, 2013    2013    28,552

abc.com    28553    September 20, 2013    2013    28,553

I am looking for the results to be the same across all three dates which

should be:  28553 across all dates because that is the max number within

that start and end date period.

any ideas?

On Sat, Oct 5, 2013 at 11:24 AM, . Indumon <

• ###### 3. Re: calculate max num of a series of numbers within a start date and end date range

On Sat, Oct 5, 2013 at 2:45 PM, Faysal Shaarani

• ###### 4. Re: calculate max num of a series of numbers within a start date and end date range

On Sat, Oct 5, 2013 at 2:45 PM, Faysal Shaarani

• ###### 5. Re: calculate max num of a series of numbers within a start date and end date range

Fayasal, Change the formula as below, you will get the required output

window_max(Sum(If >=[Start Date] And <=[End Date] Then [No Of

Domain Register User] End))

On Sun, Oct 6, 2013 at 1:53 AM, faysal shaarani <

• ###### 6. Re: calculate max num of a series of numbers within a start date and end date range

Thanks so very much.  I appreciate your help.  It solved my problem.

Regards,

Faysal

On Sat, Oct 5, 2013 at 9:59 PM, . Indumon <

• ###### 7. Re: calculate max num of a series of numbers within a start date and end date range

Most welcome!