MarkSnodgrass Coach

I just came across this KB article and this might be useful to you as well. https://domohelp.domo.com/hc/en-us/articles/360043430133

When comparing by months between 2022 and 2021, there is only one month in 2022 that has occurred, so the rest of the months would be zero causing your math to result in a negative value. You might consider looking at this post when building period over period analysis.…

Domo has a JSON No Code OAuth Connector that you might be able to use in this case and avoid the process of building a custom connector. You can read about it here: https://domohelp.domo.com/hc/en-us/articles/360052105454-JSON-No-Code-OAuth-Connector

@MattGo not a problem. Happy to help. If you can mark any answers as accepted that helped you, that will help others in the community.

Are you using the HTML table card? This is not the standard table card, but is found under tables and textboxes in the chart type dropdown list.

This is what the beast mode looks like: CONCAT('<a href=https://www.google.com>Google</a>') If your url is coming from the dataset, you would add additional concat arguments and use your fields.

I noticed some of your case statements don't have an ELSE clause. I would start by adding ELSE 0 to those as Domo doesn't like subtracting when one value is blank. Hope this helps.

@MattGo I did just do a test using the HTML table card and if you have a column that has a hyperlink, it renders properly in the e-mail body itself and will take the user to the link. I did find that you need to make sure that your link is in one of the first few columns because it doesn't seem to show all of the columns…

A good place to start is to install the Domo Stats dashboard in the Domo App Store. It will create a number of datasets that will have this type of information and it will also build a set of cards for you. There is also the Domo Governance datasets in the App Store. I would look into adding those to your instance as well.…

Unfortunately, you need to create a new account, which you can do in the data center under the accounts sections, and then you can go to the dataset using the connector and then choose the new account you just created under the settings section. You can share the account, but you can't change the owner.

On some connectors, in the configuration settings, there is the option to include the file name as a column. If you have this option on the dropbox connector, select that and then you can use the formula tile in Magic ETL to extract the information you need.

@Andrew_Chaffin works with John Stevens and may be able shed some light on finding these missing items. Andrew, any help you can provide?

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">',…