Distinct Count by Date

I did try to create a Running Total with a formula in the Evaluate. I first created a Formula with just {Customer.EstDate} called Date2008. Then I created a Running Total on the field on Date2008. Summary was set Distinct Count, under Evaluate I used a Formula Year({Date2008}) = 2008 and Reset the recordson a group. That failed. :)
Â
If that's not what you mean, please clarify.
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


--- On Thu, 8/13/09, Sean McDaniel <smcdanie@...> wrote:


From: Sean McDaniel <smcdanie@...>
Subject: RE: [Vantage] Distinct Count by Date
To: vantage@yahoogroups.com
Date: Thursday, August 13, 2009, 10:40 AM


Â



Hi Jonathan,

At this point you'd need to do a running total. Within the running total you
can create a formula indicating when to consider the record, when to reset
the count, etc.

Your formula for the running total for 2008 would be something like this

Year(<my date field>)=2008 - this will return a true when the current record
should be evaluated in your distinct count and false when it shouldn't.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Jonathan Lang
Sent: Thursday, August 13, 2009 11:08 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Distinct Count by Date

Good Morning,

I am stuck on what I am sure is an easy solution.

I am writing a report that Lists the Customer.GroupCode then shows a
DistinctCount by Year with the sales of each GroupCode. It Looks like this:

2008
2009
Customer DistinctCount Sales
Distinct Count Sales
GroupA 20 $650,000.00
54 $850,000.

The problem I am having is doing more than one DistinctCount by date. Does
anyone know how to do this or have a formula?

Thanks,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
Good Morning,
Â
I am stuck on what I am sure is an easy solution.
Â
I am writing a report that Lists the Customer.GroupCode then shows a DistinctCount by Year with the sales of each GroupCode. It Looks like this:
Â
                                        2008                                                  2009
Customer        DistinctCount                  Sales                   Distinct Count           Sales
GroupAÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $650,000.00Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 54Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $850,000.
Â
The problem I am having is doing more than one DistinctCount by date. Does anyone know how to do this or have a formula?
Â
Thanks,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â




[Non-text portions of this message have been removed]
Hi Jonathan,

At this point you'd need to do a running total. Within the running total you
can create a formula indicating when to consider the record, when to reset
the count, etc.

Your formula for the running total for 2008 would be something like this

Year(<my date field>)=2008 - this will return a true when the current record
should be evaluated in your distinct count and false when it shouldn't.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jonathan Lang
Sent: Thursday, August 13, 2009 11:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Distinct Count by Date





Good Morning,

I am stuck on what I am sure is an easy solution.

I am writing a report that Lists the Customer.GroupCode then shows a
DistinctCount by Year with the sales of each GroupCode. It Looks like this:

2008
2009
Customer DistinctCount Sales
Distinct Count Sales
GroupA 20 $650,000.00
54 $850,000.

The problem I am having is doing more than one DistinctCount by date. Does
anyone know how to do this or have a formula?

Thanks,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]