jtrollinger Member

Please disregard this question I had my ( ) in the wrong place within my beast mode.

Thanks Mark I used your suggestion to build a Drill down table by Customer Sorted by Balance. This will work. Thank you.

CustName is being FORCED into the 1st Sorting position because I have Show Sub Total Rows selected. I can not delete it nor move it.

Please disregard I figured it out. Simple BeastMode called DAYNAME() did the trick. dah…🙃

David, Ultimately I found this portion below of your answer to be true. Thank you to all for responding to this question. DAVID's Reponse: Since your calculation is using "count distinct" in the denominator and numerator, it could also be theoretically possible for the monthly and total averages to be different than the…

All Cards are using the Status Date as the Date Range Field. Removing the SORT Field PUNCH SCORE from the Table does nothing other than resort the table in a different manner. The Total PUN SCORE remains the same. Replacing SUPERINTENDENT with Status date does nothing to the total Line. (I require Superintendent to be a…

Here are screen shots of Cards Filtered: ALL coming from same dataset all using PUNCH SCORE BEAST MODE = 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)) ALL Using Last 12 Weeks

Would someone be willing to jump on a TEAMS / WEBX to walk through this. I have provided all the information I possibly can but this issue would best be solved via talking it out with someone. Trying to type out the problem and explain the issue can only go so far on this forum.

My bad, This is the ONLY BEAST MODE BEING USED FOR Gibson Score Trend, Score Trend and SCORE AVG BEAST MODE for PUNCH SCORE = 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)) Again Cards are pulling from the same data set a filtered the same using only the beast mode above.

That's what I thought you were going to say. Let me try and reconcile the difference between the two.

All cards you see are using the same data set with the same filters. Here are the two Beast Modes. After seeing both these side by side I think I see the answer but would like to hear your thoughts. BEAST MODE for PUNCH SCORE = 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)) BEAST MODE for Score AVG =…

If I count without Distinct then my number is incorrect

This does not make sense. How can ROW Totals for Michael Reed on Closed Punch Tickets by Super Card match Total of Closed Tickets by Plumber then. Both Cards are pulling from exact same data set, filters are exactly the same on both Cards but Closed Tickets by Plumber Card is just showing what Plumbers have same…

Perfect! Thank you Grant!

Mark, I can not just sum transaction amount I have to take into account source codes. My issue was SourceCode should have been = and not != Thanks

Disregard! SourceCode should have been = and not !=

Mark, Yoou got me on the right path. This is the Beast Mode that ended up working. I needed to put a MAX in front of the PROJTOTALCOST because that was an already aggregated amount via the ETL. Thanks for your help. (SUM(IFNULL(case when SourceCode = 'AP' then TransactionAmt end,0))) / (MAX(IFNULL(ProjTotalCostEOJ 1,0)))

Here is the data coming across FLAT (NO PIVOT TABLE). I would think my Beast Mode would need to look like this but this does not work either. SUM(IFNULL(case when SourceCode = 'AP' then TransactionAmt end,0)) / MAX(IFNULL(ProjTotalCostEOJ 1,0))

That did not work. it gave me zero % across the board.

No you were clear. Yes both of those Fields were pre-selected to SUM

SUM for RevisedEstimatedCost and JTD were pre-selected as these are aggregated via a GROUP BY in an ETL. This being the case why do I need to add SUM in front of my IFNULL Statements? I'm confused.

Beast Mode AmountLeft is calculated based on the 1st Case Statement Where if RevisedEstimatedCost is >= TransactionAmt then it is to perform the first calculation if not then it is to perform the second. Yes Data is aggregated in a Group BY in ETL

I figured it out. the IFNULL is required for the formula to work I just forgot to put it on SUM(case when SourceCode != 'CO' then TransactionAmt end) in the first part of the equation.

Marcel, I found the issue on this. I had two different numbers labor and material being represented by a single field jt158_WTExtendedCost that are differentiated by the WT#. I created a Function in the ETL to break this out and I was able to get it to work with your second formula. Thank you for your assistance.…

Excel Calculation is not matching Calculation in DOMO. Used this calculation. SUM(SUM(`Sales Price`- `Actual Cost`) FIXED (BY `SO#`))/SUM(SUM(`Sales Price`) FIXED (BY `SO#`))

I tried your first solution but the answer is not correct. I am getting 49% when I do the simple math in Excel. Here it is showing 39% ????

Update / FYI the Sale Price is a Single Line Field where as Actual Material Cost is multiple lines Summed within Card. This is what is causing me frustration / confusion.

Need the ability to search for Fields in ETL's that are Complex for troubleshooting purposes.

Thanks Grant. Syntax is everything.