gbrown Member

Thanks. Is this how I would set up the lag function? @david_cunningham

The overall goal is to find a pattern in which our customers order products within our data.

The problem is I am trying to append this data onto another dataset which is structured like this @MichelleH

@MichelleH There are no beastmodes calculations at this moment. The weekly plans are simply just a beastmode to give me a value of '0'. They are more of a placeholder for now until we get the data. The dataset is grouped by product line and sum of the actual values. Example: Actuals are labeled MR - Incoming Orders VK…

The weekly plans are a beastmode that just gives me a '0' for now until we can implement to the data. The actual data is a groupby sum of the product line. @MichelleH

@MichelleH The weekly plan columns are beast-modes and the actuals are columns within the data already structured. Thanks

@MichelleH Makes sense. Thanks! How would I word the beastmode to create those values? The weekly plan / weekly actuals are values and/or beastmodes

Worked great! Thank y'all for the help!

Thanks @GrantSmith ! This beastmode helped with removing decimals and still kept the color conditions active. What is the correct way to format this beastmode to be able to have commas in the value? Thanks

Great that worked! One last thing is it will not format to currency I am assuming because it comes in as a text. Is there work around this or is this as detailed as DOMO's beastmodes can get

Thank you for this. This looks like this will be able to help. In the beastmode what do I need to change? It seems to be brining the budget over but not the color. CASE WHEN SUM(Budget) > SUM(Amount) then concat('',SUM(Budget),'') else concat('',SUM(Budget),'') end

Yes, if the audit of that submission ID fails any of the tests the entire submission will result in a fail

Level ! - Any single 'Critical' will result in a failure of the audit. Level 2 - Any two (2) 'Major' will result in a failure of the audit. Level 3 - One (1) 'Major' and two (2) other questions will result in a failure of the audit. Level 3 - Three (3) other questions will result in a failure of the audit. These are the…

@MarkSnodgrass I was able to locate the dataset. It had something to do with permissions. One last question...Does Forms in DOMO have a barcode scanning capability or QR Code implementation similar to google forms? Thanks

I saw this as an option on the DOMO website but I believe that isn't the case either. It almost seems like the form does not fully submit after clicking the submit button.

@MarkSnodgrass I believe I am referring to this dataset It populates every time I submit a response on the form builder side but not when another user submits on the form viewer side.

@MarkSnodgrass Hey Mark another question on form builder/viewer. When I submit a form through formbuilder the response dataset populates with the submission, but it seems that the form viewer does not have working submissions. What would be the issue here? It will let me fill out form accordingly but when I hit submit it…

@MarkSnodgrass This works perfectly. Thank you for your help on this! Thanks, Garrett

@MichelleH Is there a way to do a filter formula to calculate without the rank and window tile. it can be in a beastmode if needed. Something similar to CASE WHEN YEAR(`Date`) >= YEAR(CURDATE()) AND MONTH(`Date`) <= ADDDATE(CURDATE(), INTERVAL 3 MONTH) THEN 'SHOW' ELSE 'HIDE' END The one problem is that it is picking up…

@MichelleH @MarkSnodgrass How would I go about this in a window function under the rank and window tile? or do you know what the beastmode would look like?

@mhouston i was using the following beastmodes above in a CASE statement using the AND function making each one IS NULL then 'filter out' else 'keep' end

They are fairly long which could be causing the issue... Change in Margin - 2020 to 2021: (SUM(CASE WHEN YEAR(`Period Date.1`) = YEAR(SUBDATE(CURDATE(), interval 1 year)) AND MONTH(`Period Date.1`) <= MONTH(SUBDATE(CURDATE(), interval 1 day)) AND DAYOFYEAR(`Period Date.1`) < DAYOFYEAR(CURDATE()) THEN `Net Sales Amount`…

@GrantSmith Always best to talk something through haha...yes that makes total sense now. Thank you for your help on this!

That makes sense. Is there a beastmode that can help in this instance or should I make an etl and aggregate the columns accordingly. Thanks

for example:

@MarkSnodgrass Worked great! Thanks you for your help on this. If I was to use a rank and window to get start of day and most current of day how would I format that rank? rank by row number, timestamp descending? Thanks

@MichelleH Yes, I contacted them regarding this issue. I am waiting to hear back on the corrective action going forward. I will keep you updated when they reach out. Thanks

This worked perfectly. Thank you for your help on this!

Ahh..I see now and got it working. Thank you for your help Mark!