MarkSnodgrass Coach

@swagner Assuming you have always 3 dashes in there (as shown in your examples) you can use SPLIT_PART to get the string after the 3rd dash, which is the 4th part. SPLIT_PART(`String`,'-',4) Hope this helps.

@Jessica You will probably need to provide more specifics as to what fields are in your dataset to work with, but generally I would say yes you can do this without a recursive. In the ETL, you can split off the IDs and dates in your dataset and then group by max date. Then join it back to your main dataset and join on the…

I know the mega table limit has been in place since it was created. I don't have specific experience with the scheduled reports limitation, but I would be surprised if the CSV export was providing more data than the card that it is based off of.

If you are using the mega table card type, it is limited to 25,000 rows. Additionally, Scheduled Reports CSV attachments have a 5mb limit, but it sounds like the row limitation is your issue. To get around this, you would need to look to export the actual dataset and there isn't a straightforward scheduled option to do…

The 1k, 10k, 100k, etc.. are for deciding how many rows you want to include from your input datasets. This is helpful if you have some joins in your dataset and, depending on how your input dataset data is sorted, you might not see any results to your join unless you tell the preview to process a larger chunk of your…

Unfortunately, no. The preview window will only let you scroll through 100 rows. It would be nice if it would. Next to run preview, you can change how much data it will pull in (default is 10k rows), but that still won't affect how many rows are in the preview window. You can help your troubleshooting a little bit by…

@MichaelClark Try breaking things down. Start with only having the last sync field in the table card and setting the aggregation to max. This should give you one row with the latest sync data in your entire dataset. If you are seeing more than one row, than a setting in Analyzer is causing the issue. The most common reason…

@user030156 To your original question, I would advocate for implementing the simplest and most straightforward solution so that others are easily able to understand if they have to manage the card or dataset down the road. Did you try just choosing MAX in the aggregate options when you dragged in the date field into your…

You can't edit an uploaded datasets directly in Domo, but there are other ways to change the data. In Magic ETL, you can use various tiles to replace data based on certain criteria. You can also join to another dataset in Magic ETL that has the correct data and use the columns from that dataset in your final output.

You could create a beast mode that is MAX('last_sync') . This will give you the latest sync date based on the other columns that you are choosing to display in your card.

To determine the 2nd Tuesday of the month, you could use the DAYNAME function and the DAY function. The 2nd Tuesday of the month can only occur between the 8th and the 4th of the month, so you could write a beast mode like this:…

It's a little unclear of what you are trying to do, but if you change 1 following to 0 following, that should eliminate the total in the first row. If you are really want to previous values and next values then consider using LAG for previous and LEAD for following and then you could total them together in the next tile.

I would look at this post by @GrantSmith who lays out this functionality nicely.

I would suggest you look at this youtube video by @jaeW_at_Onyx who walks through building an offset date table which would allow you to do what you want. In his example, he is building date dimension table for the exact day a year earlier, but you could make yours different so that it you can compare the dates you want…

When entering 0046 directly into Excel, for example, in order to not have Excel change it 46, you have to preface it with an apostrophe. You could try adding an apostrophe in your formula tile, but I am concerned how that will render on any cards you have built. If you don't care about the cards and just worry about the…

In your columns, change each of your fields except for date to aggregate by SUM. This will give you one row per month.

I don't think there is an option to disable that. I agree that it can lead to confusion. It would be worth submitting it in the Ideas Exchange to allow that to be an option to disable.

If you open up the file in a text editor such as notepad are the leading zeros missing? I know Excel will often remove leading zeros if you just try and view it in there.

I would encourage you to watch this Magic ETL Overview video in the Domo Video Library that might help you be more comfortable with some of the ETL controls. https://www.domo.com/help-center/videos/watch/xjqpW94Nq28/cat/PLc_JazWEwlVrPxLLzsXziS7tOCaDLxFny Around the 1:40 mark they talk about the preview functionality. There…

@estelle531 You can create the placeholder row by using Magic ETL. You would need a dataset that has a list of your different types and then do a left join to your main dataset and join on the type column. This will insert any missing types and have a null value for your count. You can then use the IFNULL function to…

You can use different datasets in your drill path. They just need to contain the same field that is being drilled into. Here is a note from this KB article that may help. Notes: 1) The new DataSet must contain the same category and series column name(s) you filtered off of in the original DataSet. The column data should…

You can create a beast mode that would turn a null to 0 with this: IFNULL('Count',0)

You should check your filter tile and see if you are losing all your rows there. Click on the Filter tile and then on Preview and see if it shows rows. If it doesn't, you need to adjust that. Formula tiles don't drop rows, so you need to look at the previous tiles before it and see where you are losing your rows.

Did you click on the Run Preview at the top of the ETL like I mentioned and then waited for the green checkmarks to appear?

Next to Configuration, click on Preview. This will let you see all rows.

Along the top of Magic ETL, there is a Run Preview button. Click on this. Once there is a green checkmark next all of your tiles, click on the Formula tile and then click on Preview. This will show you your data and will show you the column you created in the formula tile. Look through this column and see if you see values…

You will want to look at your formula tile and review your case statement. Run the preview in the Magic ETL and then click on the Formula tile where your case statement is and click on the preview link. Look through the results and see if you see other values besides G. If you don't see anything besides G, then the issue…

You can drop the column as you have shown in your screenshot. You won't need it after the join because the Req ID will be in the original table.

@user026529 Here is what your Group By tile should look like:

Are you using the big integer data type? It appears that Domo has issue with that type for MySQL merges. It may be the same for Azure. See this older discussion.