WorldWarHulk Member

we actually need the date as we use this as the basis for the graph when we separate them by month.

thanks! I will try this out... follow up question... the first cell in column B is a static number(1504), how can I add that in there?

Here is what I got. (SUM(`surveyscore`) - (MIN(`surveyscore`) + MAX(`surveyscore`))) / (COUNT(`Survey Date`)-2) I tried it and it looks like it is doing it's job...

Thanks dthierjung I truly appreciate it!

I missed an "=" sign (CASE WHEN `Planned Hours`=0 OR `Total Hours from SOW Breakdown`=0 THEN '' WHEN (`Planned Hours`-`Total Hours from SOW Breakdown`)/`Planned Hours`=0.0 THEN 'Within the Planned Hours' WHEN (`Planned Hours`-`Total Hours from SOW Breakdown`)/`Planned Hours`>0.1 AND (`Planned Hours`-`Total Hours from SOW…

Thanks for the response. yes. it's not getting validated. it still didn't work changing the 10% to .1 am I missing something else? (CASE WHEN `Planned Hours`=0 OR `Total Hours from SOW Breakdown`=0 THEN '' WHEN (`Planned Hours`-`Total Hours from SOW Breakdown`)/`Planned Hours`.0 THEN 'Within the Planned Hours' WHEN…

if there are multiple 2's, we filter out only one of the 2's. 

this actually looked promising. But unfortunately, the draw back is, we couldn't average the scores per person. 

Hi ST_-Superman-_ - basically, the row is the relationship. the Owner has his Score, and the PE has his own. I attached a sample view of what I want to see in DOMO.

Hi Brian - It still shows Scheduled to be delivered within 3 days. can you delete it on your end? Thanks!