Comments
-
Hi Grant - I was able to resolve this issue. I do believe there was a Null value in the dataset. I included a "Else 0" after the case statement and that resolved the problem. Thanks for following up!
-
Hi Mark - I added else 0 in the following places found in the below code. Seems like it's subtracting the TQ and LQ. But now the LQ formula is not displaying any values (even though that beast mode is independent of the QoQ one. --2_Quarters_ago ((CASE WHEN (QUARTER(CURDATE())=1) THEN (CASE WHEN…
-
Perfect. Your response makes sense. I only loaded 5 quarters worth of data into Domo which explains why the formula returns NULL. I was thinking that the remaining quarters that had data still would be able to divide by 4, but the previous month's NULL errored out the result. Thanks again for your expertise and…
-
Hi Grant - I read your post, modified the formula found in the linked post to suit my needs: Which yielded the below results. Awesome. Exactly what I needed! Thanks for your guidance and quick response! Do you happen to know why the quarters with less than 4 scores do not have any rolling avgs? Thanks again!
-
@MarkSnodgrass the suggestion you have provided worked. I moved the aggregation from beast mode to the ETL/dataflow (via Add Formula in the Group By) and the values are not split anymore! Much thanks for your help!
-
There are currently no sorts being applied.
