Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator II

Count Total Distinct Help

Hi Guys,

Please correct me in the below formula.

Target Cartons = (Hours/count(TOTAL <Name> DISTINCT DATE_TIME))*29


I am trying to distribute the hours worked for each hour and calculate target based on it. If ABC worked 4 hours, it should consider only 8/12 date and DATE_TIME of 8/12 and distribute among it and multiply by 29, so 1*29 = 29. But with above formula, it also counts the DATE_TIME of previous day and hence gives the output in the below second table.

How do I correct the formula so as to get only the count of current days hours?

SS.PNG

1 Solution

Accepted Solutions
haneeshmarella
Creator II
Creator II
Author

I think I got it, changed from Name to Date

(Hours/count(TOTAL <Date> DISTINCT DATE_TIME))*29


Thank you for your responses though Vishwarath.

View solution in original post

4 Replies
vishsaggi
Champion III
Champion III

May be add Date field like

Target Cartons = (Hours/count(TOTAL <Name>  {<Date = {[$(=Date(DATE_TIME, 'M/DD/YYYY')))]} >} DISTINCT DATE_TIME))*29

haneeshmarella
Creator II
Creator II
Author

No change in output, gives the same result.

vishsaggi
Champion III
Champion III

Can you share this sample file to look into?

haneeshmarella
Creator II
Creator II
Author

I think I got it, changed from Name to Date

(Hours/count(TOTAL <Date> DISTINCT DATE_TIME))*29


Thank you for your responses though Vishwarath.