MarkSnodgrass Coach

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.

Those cards using the dynamic textbox card type. In the analyzer, go to the Chart Properties and to General and then click on the plus sign to see all the different dynamic fields that are available to insert. I'm guessing Change Percent is the field you want to include. The key to the percentage working right is…

In the Filter tile, I am filtering out the rows that end up with Y, which is what rows get from your ELSE clause in your CASE statement. Have you tried implementing what I detailed out? I would suggest you do that and see if the results match what you expect.

Ok. Here is a screenshot of what I built that should get you what you want and I will explain the steps below. The first Add Formula just has your case statement in it and I created a column called Group. (Note: in your case statement, you are using <> ''. You'll know your data best, but I had to change it to IS NOT NULL…

Right. That is why I mentioned you will want to split off the data and then join it back to the main data and apply that value to the other rows with the same req id. If you are unsure how to do this, I can mock something up for you if provide some sample data.

@eshwarboini No problem. Glad I could help. If you can mark my response as accepted it will help others in the community.