MarkSnodgrass Coach

If the above select statement is what is in your output dataset, I might try moving that statement to be a new transform in your ETL and then just do SELECT * FROM last_transform_name (whatever you name the new transform) in your output dataset. Perhaps that will shake it loose. I tend to not put much logic in the output…

My apologies, since you are doing a left join you would get results, so ignore my first comment. Are you saying you don't see the column heading? Or you don't see any values? I have seen where the preview window doesn't always refresh when you add another column. Does it show up when you save and run the ETL and you view…

I'm not sure how your query is returning any results because you are hard-coding a value of Remove in your Bad table, which will make every row in the bad table a have a value. You are then wanting records from the bad table where Dummy is null, but you just populated the value of Remove in every row in that table. I would…

If it is like another Microsoft connector, you will have to manually type in the directory that it is located in: Example for sub-sub-directory: test/test/test Once the directory path is populated, the select file dropdown should give you a list to choose from.

I would suggest using the Microsoft SharePoint Online Rest Connector if your files are stored Office 365. There is a little bit of setup required in your Azure instance, but it gives you good flexibility to consume any Excel file that is stored in SharePoint/Office 365. Here is a link to the KB article:…

As far as I know, card interaction filters only apply to the same dataset. However, page filters can be configured to all datasets on the page with field names that are the same. You may want to consider that as an option, or set up your page as a dashboard and use different slicers as your way to filter all cards on a…

This is how I would write it and then you can filter to whichever result you want in each card. CASE WHEN `dt` <= DATE_ADD(CURRENT_DATE(), INTERVAL 4 WEEK) and `dt` >= CURRENT_DATE() then 'Within 4 weeks in the future' WHEN `dt` >= DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) and `dt` <= CURRENT_DATE() then 'Within 4 weeks…

That's great to hear @Joe_M . If you have the option to accept answer on my response, that will help others in the community.

If you don't have anything in the optional group by field, I would put the same field that you have in the items field into the optional group by and choose count as the aggregation type. I would also check the date range filter if your dataset has a date field and see which field it is using for the date range. If your…

It would take those that are between 30-59 days late.

You should be able to drag this beast mode into the x-axis and then also to the y-axis and then on the y-axis field, click the pencil icon to change the aggregation to count. Did you try doing that?

Yes, you could do this a couple different ways, depending on how you want to look at your formula. I might go with this: CASE WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 90 THEN '90 days late' WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 60 THEN '60 days late' WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 30 THEN '30 days late' WHEN…

@user048760 using the datediff function and the current date function in my initial response would get you that day difference.

I would create a beast mode that divides them into groups like this: CASE WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 90 THEN '90 days late' WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 60 THEN '60 days late' WHEN DATEDIFF(CURRENT_DATE(),`dt`) >= 30 THEN '30 days late' ELSE 'Not Late' END Replace 'dt' with the name of your auction date…

Yes, there are. Your Customer Success Manager (CSM) would be able to provide you with a quote. Pricing tends be based on website analytics where it would be embedded into.

Alerts aren't set up to compare one column to another. You may need to perform this evaluation in a beast mode to create a single value that you can check to see if it is greater than zero, for example, when creating the alert. This previous thread sums up the alert limitations pretty nicely.…

@ankt84 that is great to hear it is working! I have had to do the reset chart properties from time to time when something isn't working as expected. If you can mark my answers as accepted, that will help others in the community.

odd. I just did a test and it worked. My beast mode looks like this which is just a copy and paste of what you shared but changed the date field to match the covid dataset field. CASE WHEN DATEDIFF(CURRENT_DATE(), `date`) > 3 then concat('<div style="color:red">',`date`, '</div>') ELSE concat('<div style="color:green">',…

The basic table card supports a limited amount of HTML in it. To do what you want to do, you need to choose the HTML table card type. This is found under Tables and Textboxes in the chart types dropdown list.

If I recall, the exam is a two-part exam. One part is a multiple choice exam that is around 20 questions. You do have to complete it once you start it, but only takes about 30 minutes and they give you a big window to complete. The 2nd part is an "offline exercise" that you will complete and upload your finished product by…

the dataset via e-mail connector does have an update mode of append, but it can be challenging if you are toggling back and forth and not lose what is currently stored. I might suggest a recursive dataflow. Here is the KB article on how to create it in Magic ETL.…

There are a couple examples out there for you that are worth looking at: @jaeW_at_Onyx has a nice video that walks through this: https://www.youtube.com/watch?v=CDKNOmKClms&t=764s @GrantSmith also has a nice write-up on how to do this:…

@r4geqwit I actually was able to recreate your issue in Magic ETL. This does seem like a bug that should reported to Domo Support. However, I was able to develop a workaround by wrapping a date function around both values and then it evaluated correctly. Like this: CASE WHEN DATE(`datereported`) >= DATE('1/1/2022') THEN…

I would double-check that your Application Latest Hired Date is being seen as a date field by Domo and not a text/string field. If it is not being viewed as a date field, the evaluation will be problematic.

This is likely coming from Domo Workbench. You need to go to where Domo Workbench is installed (likely on a company server) and check there for the reason that it isn't running. In Workbench, you can also change the type from Other Provider to Excel.

@micheleb are you applying some additional formatting or something? When I put this in the beast mode editor: SEC_TO_TIME(37900) The card resolves to That seems like what you are going for.

You can use a case statement and datediff to do this: CASE WHEN DATEDIFF(CURRENT_DATE(),`lastpmtdate`) >= 60 THEN '60 or greater' ELSE 'less than 60' END Then just filter to 60 or greater

If your dataset is showing totals for each day, you can do this in Magic ETL with just a few tiles. It would look something like this: Use the formula tile to create a year column and month column Use the group by tile to get totals for each month: Use the Rank & Window tile create an 18-month total calculation by using…

I found these API calls as potential options for you: https://collectapi.com/api/gasPrice/gas-prices-api/stateUsaPrice https://collectapi.com/api/gasPrice/gas-prices-api/usaCitiesList

Agree with @GrantSmith Your sorting and limit properties should look something like this: