Best Of
Re: Magic ETL Nested Case Statement
That's great to hear @user027926 . If you can mark any answers as accepted that helped you, that would help others in the community.
Re: Getting Previous Year Actual Sales to Populate
@FreshSqueezed if you can provide a couple rows of data from the dataset that you are building the card with that would help @mhouston and I a better understanding of what might be going wrong with the formulas that you have tried.
Re: Get MySQL on latest version
I use window functions all the time in redshift, but can't use them in MySQL because they weren't introduced until version 8.0
Re: Share DataFlow (all input datasets)
Yes! It would also be great to see who already has access to a dataflow, similar to the dataset "Overview" tab.
Re: Is there a way to suppress sections (collections) in a page/dashboard?
Unfortunately, what you are doing is the best workaround as this currently isn't possible. It is a good idea to submit to the Ideas Exchange section of the Dojo and see if it could be included in a future release.
Re: simply question
Hi @NevilleMills, due to the underlying architecture of Domo and data storage in general, the data removal process would not be as easy for users as say, highlighting rows or columns in the DataSet level and deleting, or running a DELETE FROM type command.
What you can do is create a dataflow to input your dataset, filter out the row(s) you don't want and then direct it out to another dataset (i.e. Unused/Archived). You could also then contact Support [support.domo.com] to request for those rows to be deleted once you have directed the unwanted data into a separate dataset.
amehdad
Re: DOMO Connector for google sheets not working correctly
Hi @user019029, how did you go with this?
It could be that in the Domo connector settings, under 'Advanced Options' or similar, make sure you have selected the correct range of data.
amehdad
Re: Averaging multiple Percentile rankings
If I'm understanding your issue correctly, the issue is that you want to compute a beast mode of a beast mode. My recommendation is to use Magic ETL for (at least) your first computation and then you can compute the second formula either in another Magic ETL tile or in a Beast Mode. If you use the formula tile in Magic ETL beta, this should be pretty straightforward. Hope this helps.
Re: Total Row on a tale card is giving incorrect values
Hi @Saketh, so the total row for the card is calculated after the beast mode is calculated, meaning what you see happen is it’s adding your percentages instead of calculating your total percentage.
To go about getting a true total row, you'll need to use an ETL to group your data together and sum all your columns using a Group By tile, then using an Add Constant tile, put the value of Total in your label field, and then append this row to your original dataset.
amehdad
Re: Difference in Business Hours
This is an interesting one. I started sketching something out and there are a lot of scenarios to account for. I think you will need multiple nested case statements and you would use the WEEKDAY(), DATEDIFF(), and HOUR() functions to help with doing the math. I'll see if I can come up with something workable over the weekend. If you haven't already looked at this post, this may help you as well.