MarkSnodgrass Coach

I have not seen anyone get this error before and it's unclear as to where exactly you are seeing this message, but the first thing I would do is check the accounts section in Workbench. Make sure that the account is authorized and doesn't need to be re-authorized. Also, if you do have to re-authorize, make sure you hit the…

@user026529 if you can accept answer and/or like any of the above responses that will help others in the community as they search for similar questions. Hoped all of this helped!

That is correct about the "<" and ">" in the IN statement. The parentheses are optional around the CASE statement. Domo automatically adds them when you start typing in the formula editor and use the auto-complete option.

If you wanted to use an IN operator, your WHEN line would need to look like this: WHEN `wps score` IN (6,7) THEN 'Passive' IN clauses hold a list of values. You can't use greater than or less than operators within the list. You can technically use whatever is most readable to you and others that would need to understand…

Case statements exit after finding a match so you don't need to do a between or in statement. If, for example, your score is 7, it will evaluate the first line and since it is not less than 6, it will go to next when statement and see if it evaluates as true. It would then exit out after evaluating a true being less than 8…

Actually, after trying a similar statements, you can't do a < or IN statement like that. You need to write it like this: (CASE WHEN `wps score` < 6 THEN 'Detractor' WHEN `wps score` < 8 THEN 'Passive' ELSE 'Promoter' END)

I think all you need to do is have a space between CASE and your fieldname 'WPS Score'. It looks like they are together so Domo can't read it correctly.

Teams stores files in SharePoint, so you will want to look in the app store for the SharePoint connectors and choose the one that works best with your environment.

It appears that it is still not an option. Domo uses the dashed lines for the min max and average values, so maybe that is why they have kept it from being available as a choice in order to avoid confusion.

If the numbers you want to combine are each in different datasets, then you will need to use Magic ETL to bring them together. You would add all 4 of your datasets as input datasets in Magic ETL and then use the Append Rows tile to bring them all together and choose the option to include all columns. Add your output…

You might want to watch this video that @jaeW_at_Onyx put together on using the Date Dimensions dataset

Yes. You would want the calendar.csv file. This will have a row for every date that you can join your ads data to.

Domo has a Dimensions dataset in the app store that you can join your Google Ads dataset to do this. You would use the Date Dimensions dataset and then join it to your Ads dataset so that all dates are listed and every campaign has a value of zero instead of null for each date. Keep in mind, your dataset will end up being…

You are correct that you would need to create a separate calc in your dataflow if the user wants to filter to the current month but still the running total. You could do this pretty easily with the rank and window tile in Magic ETL. You might also look at some different card types. Maybe using the multi-value card or a…

Your beast mode is giving an error because you have an equals sign at the beginning of it. Remove that and it should return as valid.

Unfortunately, Domo webforms aren't designed for that and have no data validation logic or capabilities such as dropdown lists. An alternative would be to build a custom app that is a form and you could build in dropdown list capabilities. Adding enhancements to the webform is a good idea, though, and could be worth…

Looking around in the Dojo, this has been a feature that has been requested in the past, but has not been implemented yet. It may be worth submitting a new idea in the ideas exchange section of the Dojo and see if it can get included. There is a feature called Window Functions in Beast Mode that you can ask your CSM to…

You should be able to do a recursive dataflow on this pretty easily and store the datetime for the task at different flags. When you join the new data with the recursive data, join it on task ID AND flag. This will allow you store the task datetime when the flag is 0 and then, in a new row, the task datetime when the flag…

@grandele glad it worked for you. If you can mark my answer as the accepted solution, it will help others in the community. Have a great day!

You will want to use a case statement and the datediff function. It would look like this: CASE WHEN DATEDIFF(EmailDate,FirstDate) <= 8 THEN 'True' ELSE 'False' END This should do it for you.

In the General Chart Properties, for the Divide Value by property, set it to None.

One way to accomplish this would be to use the rank and window tile in Magic ETL and get your totals and rank them in order. You can then use the rank to show your top 10 and then use a beast mode (or formula tile in Magic ETL) to assign anyone above 10 to the other group. Use this new field as your series. You can also…

ok. you have things opposite of what I do. Below in the code block is my dataflow. Take what is in this code block and copy and paste it into a new empty dataflow. It might not like the input output datasets in your instance, but it should allow you to at least see the tiles that are important and click around. (Magic ETLs…

What criteria are you using for your filter tile? Based on what you are doing it should be where the date is null from your right table. Here's a screenshot of a basic recursive dataflow that I did, and yours appears to be set up similarly.

If your new dataset doesn't have any beast modes built off it, then there won't be any duplication because nothing is there to duplicate. If you do have a beast mode with the same name on both datasets, it will rename one by adding something like "from dataset...." to the end of the beast mode name. It will also alert you…

Unfortunately, I am not seeing an option to modify this. You could submit this as an enhancement request in the ideas exchange section of the Dojo and it might get included in a future release.

You are going to want to watch @jaeW_at_Onyx video on rolling averages https://www.youtube.com/watch?v=cnc6gMKZ9R8 You will need to ask your CSM to enable Windows Functions in Beast Modes if it is not already enabled in order to what he explains. Your tiers would just be a case statement built on top of the rolling average…

@ljb18 what field is being used to count the number of tracks? That field likely has blanks in it and the summary number will not count blanks as part of its total. Find a column that does not have any blanks or nulls and use that as your count for the summary number and you should see the same number as your dataflow row…

One issue you are running into is using the week function and your dates cross years. Since the week numbers start over at the beginning of each year, you are going to have issues with the math. You would need to incorporate if the year of both dates are the same or not and make the necessary adjustments. I had to do a…

I would recommend using the Domo CLI Tool, which you can download from the Admin - Tool Downloads section and perform these bulk actions.