Best Of
Re: Simple Beast Mode Failing on Federated Dataset
@LCash I second @GrantSmith's suggestion. I've run into a similar situation in some of my SQL dataflows where the result was rounding to the nearest integer because the numerator and/or denominator were integer datatypes. Forcing both to a decimal should do the trick.
How can I alter credentials for a deleted user?
Hi,
A bunch of our connectors were set up by someone who has since left the company. Their Domo account has been deleted: does anyone know how to change the account owner of a data connector account/take ownership over from someone whose account has been deleted? At the moment, we get the error below:
Thanks!
sophiecs
Re: Overwriting an Existing DataSet with Workbench
I have solved this problem myself. When importing, I found that I could search for a DataSet and select the existing DataSet.
Tow
Re: Simple Beast Mode Failing on Federated Dataset
Hi @LCash
Just curious if you multiply your numerator and denominator by 1.0 to force them both to be decimals on the off chance that they were being treated as integers and doing integer division instead of decimal / float division.
(SUM(column1) * 1.0) / (COUNT(column2) * 1.0)
Re: Beast Mode Calculation
@Shumilex I would point you to this post by @GrantSmith that should do the trick for you. You would add an extra calculation to divide the current week number from the previous week.
https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest
Re: How to add pivoted value to new columns by Magic ETL
It looks like you are missing a comma in the function syntax. It should be:
DATE_SUB(`Year/Month` , INTERVAL 12 MONTH)
Re: How to add pivoted value to new columns by Magic ETL
@eriena It looks like you want to show the totals for each month for the previous year in addition to all the detail. You can with just a few steps in Magic ETL:
- Use a group by tile to group your totals by month
- Add a formula tile and use the DATE_SUB() function to create a new column that would have the previous years date. It would look like this: DATE_SUB(`dt`, INTERVAL 1 YEAR)
- Add a join tile and join the formula tile to the previous group by tile and join using the newly created date column and the date column from the group by tile. Rename the total column field from the formula tile side and call it last year total (or something like that). Now you will your previous year total for that month next to the current total.
- Add an append rows tile and connect your original input dataset and the last join tile to the append tile and include all columns.
This should give you what you are looking for.
Re: How can I plot values that are in the time format mm:ss on a graph
Hi @Meha, I don't think there's currently a way to visualise time in mm:ss format based on the default options. Perhaps there's a workaround that another user can offer.
In the meantime, I found this recent ideas request here [https://dojo.domo.com/discussion/53838/graphing-time-stamps-can-graph-mm-ss] that you can upvote.
amehdad
Re: Turnover calculation query
If you want the 12 month turnover rate you'll need more than 1 year worth of data. When it's attempting to do the lag for prior months and getting 12 prior records it's returning NULL. When you use + and NULL the end result is a NULL so your data is blank for all of the prior months. The beast mode should work assuming you have more than 12 months of data in your dataset.
Re: How to output list which can't be joined
Hi @eriena, is your use case related to getting a list of products that don't have an assigned shop and then you (or other users) can go back to that dataset 2 to correct/update it? If so, you can have a full outer join (i.e. giving you all the records from both tables and joining matching records where possible) setup and then add a Filter tile to only include any rows where you have a product but no shop. So it would go: Join tile -> Filter tile -> Output tile.
amehdad