MarkSnodgrass Coach

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.

Ok. Then it sounds like you just need the case statement portion of your formula and you just need to remove your group by line and it should do what you want it to do.

The formula tile doesn't recognize the GROUP BY term in your syntax. You also can't flag other rows based on one row in the formula tile. You would want to build your flag with your statement and then join the data back to itself to flag those other rows that meet that criteria. If you are unaware, you can split out a…

@eshwarboini There are actually two flex table chart types that you can choose from and they are not the same. You chose the flex table that is under the period over period chart type. You need to choose the one that is under Tables and Textboxes. This will have the additional field that you are not seeing.

That is strange. It shouldn't make a difference, but for consistency's sake, try adding quotes around your src value in your image tags. I noticed you are using quotes on all your other tag values. It's possible the browser you are using isn't rendering it properly. I'm using Chrome and it rendered the images the way you…

I think you should check your output dataset and verify there isn't additional HTML that is messing things up. I took your HTML in your example and pasted it into a Demo Webform and used the HTML table card and it showed the two images right next to each other in one cell.

Yes. One way to do this is to use create a beast mode and use the CONCAT statement to make it one field: CONCAT(' <a href="https://www.walshportal.com/walshintegrated/images/logo-white.png" target="_blank" rel="noopener noreferrer"><img height="20px"…

Have you gone to the History tab and to the right of the Successful/Failed text clicked on the 3 dots to view the details? This should tell you what step in the ETL process is having the issue. One common issue is a data type changing for a column in the source dataset that is being used for aggregation.

A solution that was recommended to me was to change the person's role to Social and reset their password. This puts them in a viewer type role and resetting their password obviously keeps them from logging in with their original password. You might also need to change the e-mail listed in Domo to keep them from resetting…