MarkSnodgrass Coach

I seem to recall running into a similar issue and I could never get the ETL to cooperate. I ending up doing a SQL dataflow to get the dates in an actual date format and then used that output dataset as my new input dataset in the ETL. Here is an example of what I did in my SQL dataflow CASE WHEN "EXTRACTDTE" < 19000101…

You should be able to build an ETL that has the NOAA dataset as one input dataset and your sales data as another input dataset. You would then use the Group By tile on your sales data and group by city and use the Average function on your rain total. Next, use the Join tile to join that data with your NOAA data to bring…

If you don't want to create a new column, you would need to do this in the ETL. You can use the Replace Text function to replace a site name with a different site name and not add it as a new column

You did that correctly as it looks like you are wanting to get contacts that only visited in 2018 and exclude contacts that visited in 2018 and then again in 2019.

Assuming you are using MySQL, you would do this to add 7 days SELECT DATE_ADD(mydatecolumn, INTERVAL 10 DAY) FROM MyTable

Thanks! I see the Add Tags option now and just added my 1st tag! Appreciate it!

@DaniBoy Do you have any insight on this?

Have you tried the line + stacked bar cards or line + grouped bar cards? Here's a link to the KB article about how to use them. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Stacked_Bar_with_Line_Graph Here is a screenshot of how I have used it. Hope this helps.

You should be able to do this with the Collapse Columns feature in the ETL. Here is a link to the KB article that walks you through how to do it. https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns#Collapse_Columns

When you add a page filter, if your column name is in multiple datasets, there will be a right arrow > that you want to click on. This allows you to select all datasets. Choose that and then when you use the filter, it will affect all the cards on that page that use those datasets. Here are some screenshots of adding the…

When you are viewing an individual card, have you clicked on the icon with the box and up arrow? It will give you the option to Send/Export and then you can choose to export the card to PowerPoint or PDF, which would export the card itself and not the data. When it is in PowerPoint, you could then copy and paste the card…

If you are using Domo Workbench to send the data to Domo, you can go to the Schema tab and change the data type to Text or String. This would eliminate the need to do anything in the ETL. 

Yes, you could certainly do that. If you are using Microsoft SQL Server, it would look like this: SELECT ROW_NUMBER() OVER(ORDER BY Product ASC) AS ID, Product, Class, 'TableA' AS Source FROM TableA UNION SELECT ROW_NUMBER() OVER(ORDER BY Product ASC) AS ID, Product, Class, 'TableB' AS Source FROM TableB The newly-created…

Yes, that is correct.

In my screenshot, the two dataset that are at the beginning are two different datasets. The names are cut off in my screenshot, so I could see how you were confused. For you, you should have Table A -> Add Constants and then Table B -> Add Constants 1 and then bring them together after that like the rest of the screenshot.

I just tried exporting a table card to Excel and it worked fine for me. Do you have more rows in your data than Excel might be able to handle? Have your tried going to the data center and then to the data set that powers your card and exporting that to see if you run into the same issue? That might narrow down the problem.…

I think I had the same problem as you a while ago. When you click on Add Filter, click on the arrow to the right of the column you are wanting to filter on. Then click on Select All. Here are some screenshots to help you. This should make your filter apply to all the datasets on the card. Hope this helps.

I was able to make this work by choosing a pie chart and making a card for each coverage type so that it will only have one value in it. I used the color rule for the color which looks to see if they have coverage. Since I am using a story page, I can make multiple small circles/pies and put them next to each other and get…

@Jarvis That's a good idea about the color rules. Any idea on how to create a card that is a circle or a group of circles? Or something similar? I feel like my only option is to create a custom chart, but I was hoping to avoid that.

Yes, generally it would look something like this. Just depends what else you want to do in your ETL. You can build some pretty elaborate ETLs if you want to. It just depends on your needs. You may want to watch a couple videos on building ETLs if you aren't familiar with it. There is a lot you can do.

Assuiming you are using the ETL, you should be able to use the row number function in the rank and window tile to create a unique ID for each row in your data. For #2, you should use the Add Constants tile and it after each dataset and before you union them together with the Append Rows tile. Here's a link about the Add…

It sounds like you need to pivot your data, in which case creating an ETL and using the collapse columns tile should get you what you want. Here is the KB article that discusses it. https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns#Collapse_Columns

I don't think Workbench is set up to select all tables from an entire database, but here is an option to make it a little less cumbersome. In Workbench, create a job of one your tables and save it. Go to the More tab and export the job. This will save your job as a JSON file. Now, you can open that file up in any text…

I think I created what you are looking for. Here is what I did. I created some sample data that looks like this (I've also attached the file): StudentCredits Toward ProgramCredits RequiredJim57John67Joe77Sue87Bill97 I then created a beast mode field called CreditPctRange that contains this: (CASE WHEN (`Credits Toward…

I would suggest you use the collapse columns tile to "pivot" your date columns into a single column and then use the group by tile to get the min of those dates. You can even split your dataset to do these functions and then join it back to your original dataset if you need to use it with the rest of your data. Not sure…

If you scroll down to the ETL example in this article, you can see how to do it. In the example, they are doing average, but you would just replace that with sum. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Rolling_Average_Using_DataFlows Hope this helps.

Unfortunately, it doesn't look like you can use the Last Value Projection properties when you have more than 1 series. See KB article: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Multi-Line_Graph Note: Though Last Value Projection properties appear in the Chart…

You could do this with using the row number function of rank and window and then use the filter to function. Here is the KB article for rank and window and row number. https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window#Row_Number Basically, you would use the row number…

I have used many beast modes to filters. Here is a screenshot of adding one to the filter section and it worked for me. Perhaps something is going on with your beast mode?

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…