MarkSnodgrass Coach

Workbench works the other way in that you name your dataset in Workbench and then push it up to Domo and the datasets will show up in Domo with the names you gave it in Workbench. This may be helpful if you haven't already looked at it.…

The date filter doesn't lend itself to do this, but you can pull this off and keep it dynamic by making a beast mode that use as a quick filter. Here is the formula to create: /*check to see if it is the 1st of the month */ (CASE when DAY(CURRENT_DATE()) = 1 then /* it is the 1st of the month so only include data from the…

Just add Advertiser in your group by tile in the same section where you added the week number and year. It will then sum the revenue by advertiser, week number, and year.

I believe I have run into this issue when it didn't know what Domo instance I was associated with. If you didn't already, log into your domo instance and then navigate to the help center and then click on support. I am seeing my open support tickets right now when I go there, so I believe it is having trouble…

To group by week in the ETL, you will want to use the date operations tile. Drag that tile in and select week of year and name it week number. I would also add another column to get the year and select year of date in the date function. In your group by tile, group by those two columns and sum your revenue. This will get…

Unfortunately, the dashboard filters are set to work on an AND condition. Maybe not ideal, but you could could have one card that shows states totals and another card that shows region totals and have them sit next to each other in your dashboard. If you are using the filter cards, you can tell it which cards should be…

Unfortunately, you can't do totals like this in beast mode. You will need to do this in SQL or Magic ETL. It would be a nice enhancement if beast mode could eventually grab these totals as it is a common question.

I see in your attachment in the first screenshot that the dataset contains 61,598 rows. What is the row count of the dataset in your last screenshot where you are filtering on nulls and there are no rows for that filter? Is it the same? If so, then you didn't lose any rows.

In the appstore, you can add the Domo Dimensions Connector. It has a dataset of dates that you can then use to join with another dataset so that you have all dates in a range of years that you need. You can find it in the appstore by searching for calendar or Domo Dimensions

@GrantSmith gave a very nice walkthrough so not too much more to add. If you haven't looked that the KB article, it gives a nice step by step guide that may help you. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow You can also do recursive dataflows in Magic ETL.…

@swagner What if you did this? case when `Description` = UPPER(`Description`) then 'All upper' else 'Contains lowercase' end If your descriptions come in as all uppercase then it should match on the first when statement. Otherwise it wouldn't match because your description contains a lowercase letter and fall into the else…

Yes, you can do this in the ETL by grabbing the month and year from a date column and then re-construct a date column as the first of the month. Here is a screenshot of a sample dataflow that shows the steps and then I will explain what is going on in each step below. Date Operations: Add a column called Month and use the…

If you go to date range filter in the card analyzer, you can tell it to group by month. This will group it by month and year and automatically the sum the totals for you. This KB article may help you.…

Are you trying to show on your x-axis the days since Feb 22nd so that it would display 1, 2, 3, 4, 5, etc...? If so, you would need the dates for each of those days in your dataset and then you could do a datediff between that date and Feb 22nd. What columns do you have in your dataset? Also, if you do have the dates in…

You would still make use of the CONCAT function. It would just look like this to incorporate the field_ID. CONCAT('https://na132.salesforce.com/','field_ID')

@Ashleigh Unfortunately, it is looking like the functionality for the poll card is quite limited. It looks like it only supports anonymous answers and it doesn't look to store the answers in the data center.

You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this: (CASE when TRIM(`City`) = 'Abbeville' then 1 when TRIM(`City`) = 'Phoenix' then 1…

Does your organization use Google Analytics? If so, you can add the Google Analytics Quickstart App to your instance and it contains a pre-built card with beast modes that might be helpful for you. I have the quickstart app in our instance and there is a card called Average Visit Duration. They have a beast mode for…

Not sure if this will work since I don't have the data to work with, but might get you closer. Basically, I made a subquery that gets all the users and their survey data if they have it. I then left join it to the date table and moved the where clause information to part of the left join criteria. I am also hoping the…

@Cartergan Do you mind re-posting your SQL with a table alias for each column? I'm having trouble discerning which columns are from which table and that will make a difference when it comes to your WHERE clause, etc...

I have struggled with this at times as well. I assume you are trying to move these pages through Admin - Pages. What is not immediately clear when you are viewing the pages listed on this page is that it doesn't show you all the pages just by scrolling. In order to move pages not initially shown, you need to find them by…

@Cartergan The first thing that jumps out to me is that you need to change your table listing in your FROM clause. In order to get all of the dates from the dates table, that table needs to be listed first. Your FROM and LEFT JOIN syntax should look like this: FROM `date` D LEFT JOIN `qualtrics_responses` ON (D.`Date`) =…

You might also want to check to see if the access token you are using is expired. You can check on this by logging into your Domo instance and then go to Admin - Security - Access Tokens and look for the access token that is used for the workbench and the expiration date.

@Moberling I wonder if there are spaces in that field rather than it actually being empty and that is why it can't convert. Try bringing in a String Operations tile and use the trim spaces function to eliminate spaces. Then try the Set Column Type. You could also use the Combine Columns tile to try and expose what is in…

I can testify to the fact that this something Domo has implemented on all instances. I am involved in about 17 different Domo instances and any instance created in the last year or so has this notifcation in the corner and it won't go away until I do all of the things it says. On older instances, there is no notification,…

We have the Redshift SQL enabled in our instance and are able to use this SQL line to calculate a running total: sum(paymentamount) over(partition by ClaimNumber order by dateofeventyear,all_monthsofdev rows unbounded preceding) I'm not seeing this exact syntax available available in MySQL, so maybe you can get Redshift…

I think there a couple ways to solve this. First, in the State Value, choose No Aggregation. This will keep your phase value from summing. I would then add your Phase as a quick filter to allow users to choose which phase to look at it. You can use the Hover Text Settings and the Ranges to control the color and text that…

It doesn't look like stacked bar is an option in the period over period charts. There are about 7 different charts for period over period. I would try each of them out and see which one fits your need the best.

I would suggest the Period over Period cards. You could use the bar line, for example. You can then use the date range filter to compare it to the previous week, or much earlier, if needed. Here is a screenshot example: CORRECTION: The variance bar line would be a better choice as it shows the percent change. Apologize my…

Yes, dropping the Program Title from your select and group by statement will definitely help.