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)
Hope this will help you..
Max User Registered.twbx.zip 38.6 KB
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.
On Sat, Oct 5, 2013 at 11:24 AM, . Indumon <
On Sat, Oct 5, 2013 at 2:45 PM, Faysal Shaarani
Thanks so very much. I appreciate your help. It solved my problem.
On Sat, Oct 5, 2013 at 9:59 PM, . Indumon <