MarkSnodgrass Coach

@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.

@DrGWright What constitutes all three being complete? Do you have a 'Program Enrollment Status 1' and 'Program Enrollment Status 2' fields as well that say Complete or Not Complete? If so, I would add to your WHERE clause that WHERE `Program ID` IN ('16','12','64') AND `Program Enrollment Status 3` = 'Complete' AND…

Without seeing the actual data (or a mockup of it) it is hard to give complete guidance, but here are a few things to note, followed by a cleaned up SQL statement: 1) Any field this in your select statement that is not aggregated, must be included in your group by clause. I noticed Program Title was not included in the…

Have you tried starting a new File Upload connector and uploading your file to that and just call it test? If that works, then it sounds like your existing connector is somehow corrupt and might require a call to Domo Support. 

Assuming your output dataset contains something like the following columns: Fiscal Week Number Registered Count Budgeted Count You can create a grouped bar chart by putting the Fiscal Week Number in the Category field and add the Registered Count to the Value field and the Budget Count to the Series field. Set both of…

I didn't have a Google Sheets file to work with, but I did have a SharePoint Connector Excel file to test with and see that it is doing the same thing. Subtracting 5 hours. It could be worth a call to Domo Support to see if it is a bug with these connectors, or understand their reasoning for not adjusting the time to your…

@user01804 in the Admin section, under Company Settings - Company Overview, there is a Time Zone setting. Make sure that is set to Eastern. Domo should be looking at this setting for imports.

It looks like a tootlip does show up if you add a description on the schema page of the dataset. This first screenshot is from the schema tab showing the added descriptions: And this screenshot is from the Analyzer. Notice that there is a "i" icon next to the field that has a description. If you click on it, it will show…

In the Subtotals Chart Properties, if you scroll down there is the option to Show Subtotal Columns. If you check that, you can then collapse the columns as well.

You need to have two fields in the Rows section and then you also need to turn on Show Subtotal Rows in the Chart Properties - Subtotal properties. It won't show unless both of those are in place.

Since comparative gauges only read the first row in a dataset, I have found building a magic ETL dataflow to calculate the previous value and put it in the same row as the current value, the best way to power the comparative gauge. You can calculate the previous value by using the rank and window tile in the ETL. Here is a…