GrantSmith Coach

Hi @user048760 Are Just names included in your column and you want to blank it out or is there other information in that column that you need to retain except for the name? If it contains just the name and you want to set it to one if it is populated you could utilize a formula tile in Magic 2.0 with this code: CASE WHEN…

I’d recommend using a date dimension with custom defined offsets. Using the custom date offset dimension you can have the current value and the value from 12 months ago. This will simplify your graphing and correctly calculate the current month to the partial month from the previous period . I’ve done a Previous write up…

Hi @jgillman You'll need to aggregate your data and count all of the subscriptions before attempting to calculate the weighted average. You can't aggregate an aggregate in a beast mode so pre-aggregation is required. Once you have the number of subscriptions counted you can then use that new field in your beast mode to…

@Imbesat - Are you aggregating your data from your dataset in your table card or are you just displaying your dataset? You may also be able to utilize DataSet Alerts for individual rows. https://domohelp.domo.com/hc/en-us/articles/360042925994-Creating-an-Alert-for-a-DataSet

@AkshayAnand2 - This KB article may help explain Summary Numbers: https://domohelp.domo.com/hc/en-us/articles/360043428753-Configuring-Your-Chart-Summary-Number

You can use the value mapper to map the 0 to an empty string (click the gear icon on the replacement field - select empty string) before you use the Set Column Type.

You're attempting to aggregate twice (COUNT(SUM()) which Domo doesn't like. Are you grouping based on the order ID at all? Do you have multiple records for the same order id in your dataset? In simple business terms what are you attempting to calculate? Why are you attempting to count the sum of line items? Do you just…

You can add another SQL transformation (not a table one) to have it drop the final table if it exists before you run the word_cloud function call because in the MySQL database that's spun up it'll create the table but won't ever remove it when you attempt to create it again and cause the table already existing error. DROP…

Hi @Jobur You can utilize a beast mode to create buckets for your margin % the following beast mode works since it evaluates the first condition it finds to be true and exits. If you want to sort by these values you can make another beast mode with the same logic but instead of the string (75-100%) you can return a number…

Hi @DKCloud9 You’ll define the schema of your data set with a DataSetRequest object and pass that into when you create your dataset. There is an example of how this works on the GitHub repository specifically lines 14-17 (creation) and 33-38 (updating)…

Another option is to utilize a Value Mapper tile to search for values of 'x' and replace it with 1 or 0 (default value) if it's not found. Then use a Set Column Type tile to convert it from a string to a numeric. You can copy and paste the following code into your dataflow to replicate this logic (tweak your dataset and…

Hi @user048760 If you have Magic ETL 2.0 you can use a formula tile and a case statement to swap it out to a 1 in a new column: CASE WHEN `ExcludeOnline` = 'x' THEN 1 ELSE 0 END Alternatively you can do this as a Beast Mode as well if you need it just on the card. If you don't have Magic 2.0, you can wait when it comes GA…

You could utilize Magic ETL dataflows to check the date on the data and either split it out and archive it or remove it from the dataset depending on your company's data retention policy.

Hi @leeloo_dallas Since you mentioned Magic ETL you can utilize a Rank and Window function to calculate the LAG for the download field. You can then take the current download count for that day and subtract the lag value to get the difference increase for your day. You'll want to make sure to partition based on the year…

You and me both @Ainash. Is that the error message you get when selecting 'Run to Here' on your function call to the word_cloud? Are you able to add a transformation to just select the column you need (plus another or just a bogus value) from your input dataset and utilize that resulting table as your input table to?

To address the 4 week rolling average you could utilize the LAG window function however you'd need to have 28 different LAG functions (I'm assuming your date has a day grain and not a week grain here. If you have it by week this becomes easier and you can refer to the post @MarkSnodgrass mentioned) called in your beast…

Hi @Shumilex I'd recommend utilize a custom date offset where you can compare one date to a different date. In your case you're just wanting to know the value from last week. I've done a write up / walk through of this methodology before. You can find more information here:…

Hi @Ainash Does your dataset have a single column? If that's the case the word_cloud function doesn't work with a single column. You can add a dummy column to allow your dataset to be processed. I've written about this previously here: https://dojo.domo.com/discussion/comment/54744#Comment_54744

Hi @Lashes You can use some simple math to convert your negative number to a positive one and some trickery with the FLOOR and CEILING functions to get bands of 10. CASE WHEN `days until due` * -1 > 60 THEN '60+ days' CASE WHEN `days until due` >= 60 THEN '-60+ days' ELSE CONCAT(FLOOR(`days until due` / -10) * 10, '-',…

@ChristianW - Yes exactly what I'm looking to do but you can't get it without adding a constant value to group on in the group by tile. SQL and Window Functions don't require a column to perform a grand total.

Hi @DKCloud9 Have you tried utilizing pydomo? It's all packaged to neatly do this and is a supported method for communicating with the APIs. Are you getting an error message back with your 400 code? Have you tried replicating your API request in a tool like Postman to make sure your body, parameters and url are correct?

Glad I could help @Liliana. If you could accept my answer so others can find it easier I'd appreciate it! Thanks.

@amehdad21 beat me to it but he's correct, you'd use a Group By tile to aggregate your data grouping on whatever the partition you want to calculate the average across. If you want to do it across your entire dataset you'd need to add a constant value (Add Constant tile) in a new column to group by (Group By tile requires…

Hi @Imbesat You need to configure a summary number using your Delta field to allow for alerting. Alerts can't be done off a table card alone but require a summary number. You could use the latest value of the Delta as the summary number to alert you when it's above a certain threshold.

My understanding is that Default Filters aren't supported on embedded dashboards currently. You could default all the cards you have on your page to view the last 12 months via the date picker and put a calendar filter card on your dashboard to allow users to select different time frames. Doing a different graph by option…

A custom connector may prove to be difficult as it's must be written on ES5 which is an older version. You may be able to hack something together to interact with an SFTP folder, pull all the files and then loop through all of the files but you'll be restricted to what you can utilize. I'd be interested to hear if you're…

Hi @ramoshe This is because you're attempting to aggregate (SUM) on an aggregate (AVG) which isn't possible within a beast mode. You'd need to calculate the average of your dataset in your ETL and then use the resulting column in your beast mode. The downside to this is that it won't be respective of any filters you apply…

Glad to hear it worked for you @etszyingho . If you could accept the answer above so it's easier for others to find the solution I'd appreciate it, thanks!

Hi @etszyingho I'd recommend utilizing ETL 2.0 if at all possible as it will be more performant than MySQL dataflows but it looks like you're at a good spot with your current performance with @MarkSnodgrass 's solution.…

LEFT JOIN, RIGHT JOIN and OUTER JOIN will all return NULL values if it can't find a match between your two tables based on your join condition. This website may help explain the differences between the different join types: https://www.w3schools.com/sql/sql_join.asp It's working correctly based on your join columns and…