User_32612 Member

Haha let me know if you find it, I didn't see one

I see. Weird that all the options are there though, they just don't do anything. Thank you for the quick response, I will make a regression in a beast mode

@MarkSnodgrass Unfortunately this conditional color feature is something that our team has expressed is necessary for us to use Domo for this project, so ideally I wouldn't like to give up here after all the help that the Dojo has provided for other issues. I will definitely submit this as a suggestion, but are there any…

@jaeW_at_Onyx Awesome that worked, thank you!

@jaeW_at_Onyx I don't see a setting for HTML tables to transpose. Where did you see that?

@GrantSmith I decided to make a calculated column in my dataflow and that successfully aggregated the "Pre WK16 AVG" into one column. I hadn't realized that the calculated columns in data flows behave differently that beast mode, this should be useful info moving forward. Thanks for the assistance!

Essentially what I am asking is is there a way to aggregate columns that have the same name and average their values into one column? As you can see above, when I use a beast mode to rename weeks 1-15 as Pre WK16 AVG, instead of aggregating them they are each shown.

@jaeW_at_Onyx The time frame is defined by a beast mode which filters out any week after 15 and any week prior to the current date. What I'm looking to do here is essentially what you see in this excel chart below (ignore the # & axis differences, this is separate data): The reason we want to go this route is the chart…

It appears the reason the denominator in my beast mode was calculating as zero was because i had week 42 filtered off the chart so domo could not reference it. Problem solved!

@GrantSmith I watched the video and the explanation makes sense, though I am still getting "Infinity" as the result of the beast mode when using the window functions. I have a meeting with my CSM today at 4pm to look into this. I will let you know if we have arrived at a solution. Thank you for the assistance so far!

@GrantSmith could you explain what that function does differently by adding the extra sum functions & the over() function? I reached out to my CSM and we have window functions enabled but when I used this function it provided an error and the card would not load despite the beast mode viewer validating the function. I…