MarkSnodgrass Coach

If you are just doing SELECT statements, it is not too daunting. I would encourage you to review this KB article that should give you enough basic knowledge to do what you want to do. https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows/01Creating_an_SQL_DataFlow You would select your source dataset as the…

In the select columns, you can use type-ahead to slightly ease the pain of selecting your columns, but you are still limited to do it one at a time. This has sped it up for me as I have a dataset with nearly 600 columns. Perhaps a better option would be to use a SQL dataflow whose only purpose is to select the columns that…

You can move this through the admin section. Go to Admin - Pages and then click on the checkmark next to the page you want to move. Then, over on the right, click on Edit and choose Move Pages. You'll be able to make it a top level page or make it a sublevel page underneath another page (which it sounds like what you want…

Do you have any PDP policies in place that would affect what other would see? Typically, page filters affect all users, so it is surprising they aren't seeing your changes.

Do you have a unique identifier in your dataset, such as ID? If so, you can choose that column in your summary number and choose count and it should display the number of rows that you have in your dataset.

My first thought would be to use the Date Operations and use the Week of Year function to derive the week number from the invoice date and build your dense rank off of that. However, it sounds like you want to count 7 days from the first invoice date regardless of the day of the week. To get what you want is going to…

Is the external source that you are connecting to throttle how many records it will return at once? It has been a while since I have used the developer studio, but I seem to remember having to build some looping functionality for it to return all of the records. 

It appears to be going off of the format that is chosen for the Y-axis. If you format your y-axis to show zero decimal places, your min/max/average should use that format.

I would agree that the ETL would be the way to go. I would suggest that you look into the Rank and Window options in the ETL. Here's a knowledgebase article that breaks it down. https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window Also, it is worth noting that you can have one…

If you just have the line column and the quantity column and choose SUM as your aggregation, you should get what you are looking for. If you click on a line it will drill into that line and show you the details of the line number. Now, if you add other columns into your table card, it will start taking the uniqueness into…

For append, you have a few options, but the most common method is to combine the datasets where the column name and types are the same. You'll see the various options when you configure the append rows tile. You can make them the same by using the Set Column Type tile and the Select Columns tile. This allows you to change…

@Sgoedecke Have you tried just evaulating based on the month of the period instead of the entire date and just look for January? It would look like this: SUM(SUM((CASE WHEN MONTH(`PERIOD`) = 1 THEN (`Beg Balance`+`AMOUNT`) ELSE `AMOUNT` END) ) ) OVER(ORDER BY `PERIOD`) It seems like using the MONTH function would make it…

@imelendez Typically when you are merging a historical dataset with a current dataset, you would want to use the append method in the ETL, especially if your columns are the same, which it sounds like they are since you made sure to use the same stored proc. Try using the append method instead of the join method in the ETL…

In the ETL and the SQL dataflow, you can't pull in all rows because it is just for previewing. You can adjust how many rows you see, but you can't choose all rows when your dataset is very large. You will want to complete your ETL with an output dataset and then build a basic card that is powered by that dataset to…

An important thing to note is that in ETL and in SQL, it will not load your entire dataset if you have a large dataset. Therefore, it can be tricky validate your data while building if you are looking for specific values. Depending on the setting, it may just be loading 10k rows of your dataset. Keep that in mind. As far…

I would suggest you make your where clause to be: WHERE 'date' BETWEEN '10/1/19' AND '10/31/19' This is the more standard date format for SQL to evaluate the dates, assuming your date format is m/d/yy

You can use the color rules feature to change the color for the single value. Here's a link to the KB article if you haven't used it before. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Setting_Color_Rules_for_a_Chart

Have you tried changing your date selector grouping? If it is set to None, that could be your issue if your date field has a time stamp in it. Try setting it to group by Month and see if your calculation works properly.

Have you looked into using color rules? This allows you to use a certain color for specific values throughout your instance. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Setting_Color_Rules_for_a_Chart You can tell it to apply it just to a card, or all cards…

I wonder if the distinct is throwing it off. Here is a beast mode that shows login failure rate that is similar to what you are trying to do. I got it from one of the cards in the DomoStats quickstart if you have that in your instance and want to compare. (COUNT((CASE WHEN (`Action` = 'FAILED_LOGIN') THEN `Action` END )) /…

I'm not seeing the attachment. Can you try sending it again?

I'm pretty sure you can't create new datasets, but you can have it append rather than replace when you set up your e-mail dataset connector. This would allow you to keep your historical data and you could set up your card to look at the most recent data and display only that.

On this page, https://learndomo.domo.com/learn/course/23/domo-basics-training-level-1;lp=10 , scroll down and in the bottom right section of the page there is the File Repository Area. Click on the Understanding Pages - Sample Data link to download the sample data.

The easiest solution would be to add an additional statement that resulted in "Brad/Scott" like this: case when `Customer Home Branch` IN ('207500','208500') then 'Brad/Scott' when `Customer Home Branch` IN ('203500') then 'Scott' end However, I think you are wanting to be able to have Brad and Scott listed individually.…

I would suggest using Magic ETL and using the Set Column Type operator. You can then tell it that you want it to be a text field and you wouldn't have an extra field created when you create a Beast Mode Field. If you are not wanting to create an ETL, the TRIM function as stated above looks like the best option. 

I don't know if there is a way to change it, but I know it is not specific to the pie chart card. That is how Domo has the legend functionality working on line and bar graphs as well with a legend. If you hover over an item in the legend, it isolates that item, but if you click on it, it will remove it. It could be worth…

If you aren't doing much in your Magic ETL, you might consider DataFusion, also known as Blend. It is much better equipped to handle datasets that are in the millions of rows. https://knowledge.domo.com/Prepare/Magic_Transforms/DataFusion

No, I'm familiar with DomoStats. That is not it. It is called Domo Governance Datasets. Here is a screenshot of it from the app store. Search in the app store for it under connectors and then choose Get the Data and select Dataset Schemas as the 1st dataset to retrieve.

If you look at this thread, you can do it with MySQL https://dojo.domo.com/t5/Data-Sources-and-Connectors/Deleting-records-from-a-dataset-using-MySQL/m-p/23359 Also, you could think about temporarily using the replace method and then go back to your append method. 

@hamza_123 If you look in the app store for Domo Governance you will see a connector that will get you what you are looking for. It has multiple datasets to choose from, but it sounds like the two you would be most interested in looking at are Datasets and Dataset Schemas. Hope this helps.