ArborRose Coach

That doesn't seem to paste well. Here's a screenshot. It doesn't seem to recognize padding-right or padding-left. But it does recognize padding: 0px 0px 0px 0px; where each pixel number represents in order: top, right, bottom, and left.

This works… CONCAT('<div><a href="', 'www.yahoo.com', '", "target="_blank"><img src="','yoururl/images/jate.jpg','" height="42px" style="vertical-align:middle"><span style="vertical-align:middle;padding:0px 0px 0px 20px;">', Title`,'</span></a></div>')

Something like this? Last week case when YEAR(`Date_Column`) = YEAR(CURRENT_DATE() - INTERVAL 1 WEEK) and WEEK(`Date_Column`, 1) = WEEK(CURRENT_DATE() - INTERVAL 1 WEEK, 1) then `amount` end week previous case when YEAR(`Date_Column`) = YEAR(CURRENT_DATE() - INTERVAL 2 WEEK) and WEEK(`Date_Column`, 1) = WEEK(CURRENT_DATE()…

Sorry…the space doesn't show in the webpage. CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img src="',`thumbnail_url`,'" height="42px" style="vertical-align:middle;"><span style="vertical-align:middle;">', '&nbsp;', `Title`,'</span></a></div>') Oh wait…your inside of a CONCAT. Add the space as '&nbsp;'…

In html "&nbsp;" means space. But a space that isn't ignored. So they can be strung together to make {space}{space}{space} by using &nbsp;&nbsp;&nbsp;. You put it anywhere you want a space character. Don't forget the semicolon. Also, you should have the span nested inside the anchor in this order: <a…

Using an html table chart type…you can create an html style. This one is nonsense…but should give you enough to create your field. CASE category when 'category1' then CONCAT('<span style="color:green;background-color:#ff0000;">',col1,'</span>') when 'category2' then CONCAT('<span…

It appears to be sorting…just not the sort you are looking for. When I do values using year & month, I create a monthname and a month (integer value). For example monthname(CURRDATE()) might give me "April". Whereas month(CURRDATE()) would give me "4". I put the monthname version on the card and put the month version on…

I don't see a question, only a heading. Can you provide more info?

By the way, make sure you use semi colons to separate things in style. After each "vertical-align:middle", you should follow with a semi colon. CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img src="',`thumbnail_url`,'" height="42px" style="vertical-align:middle;padding-right:10px;"><span…

You can use "&nbsp;", which is a forced space in html. Html ignores consecutive spaces. Or you can add padding to the style , such as "padding-right:10px;".

I'm not very familiar with App Studio, but I believe the themes apply to the overall card, not the chart specifics. It looks like you need to adjust the line colors in analyzer.

I think you posted the same question twice. Cards are linked by a dataset's common fields. If you first create a card with your data, then make a separate "filter" card….make sure you use the same dataset. And make sure the field used on your filter also appears on the other card. When you select a value on the filter…

Cards connect by common fields in the dataset. When you make a dropdown (filter charttype) card, make sure you use the same dataset and make sure the field / column exists in both cards.

Setting up two separate email connectors may seem like overkill, but it would be a clean and reliable way to make sure the files get to the right dataset. Since these are apparently manually triggered, having two separate connectors would make sure each file is processed independently as soon as the email is received. note…

Depending upon the process, you can append rather than replace. I bring xlsx files into Domo using Domo WorkBench…find it under admin > toolkit. You could also setup an ETL to merge the two using the Append tile. But it might trigger unecessary credits on your account. You could also create an external application to merge…

You can append it using ETL append rows tile. I do this to bring in legacy datasets that don't get updated on a daily basic.

I know the following isn't a "clean" solution….but may help you identify how to get your solution. Using something like this, you can identify the "hour" segments someone worked. You could then count the occurrences within the hour segments. Such as getting the number of people working at six o'clock: SUM(CASE WHEN…

The invite I received shows April 25th at 10 AM MT.

I don't think the workflow is designed support direct querying or executing SQL from within the brick itself. You probably need to incorporate additional steps that handle the query.

Have you tried using Rank?

In your export, it might be affected by how you have configured the API, or how the data is stored in Domo's dataset. In the Admin > Toolkit there's a schema management tool for adjusting the data structure of a dataset. You may also consider using something like Python to perform your export. I use Python to export my…

I believe to change the dataset that your brick is connected to, you'll need to adjust the configuration within the brick itself. Open the configuration settings and look for the option where you specify the dataset that the brick is connected to. This is labeled as "Dataset" or something similar. Sorry, I'm not currently…

I believe the token limit is a security feature designed to prevent abuse. Each token represents a user session or authorization to access the data, and there are limits imposed to prevent overuse. Instead of generating new tokens for each user or sessions, you can possibly reuse tokens. Or manage the expirations more…

The error message you're receiving suggests that the Azure Active Directory (AAD) tenant where the application is registered does not have the specified application installed or consented to. This error typically occurs when the application (in this case, the one trying to connect to Sharepoint) is not registered in the…

Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.

The error in the provided Domo code lies in the mismatched parentheses at the end of the CASE statement. You have an extra ) before the THEN 1 clause. (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN…

Oh…make it less than but not equal if you want up to today but not including today.

The condition "<= month(CURDATE())" means compare years up until today's date. It is comparing Jan through today (April 18, 2024). For specific ranges like a specific month: To include records where the month is April - SUM(CASE WHEN YEAR(DocDate) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) AND MONTH(DocDate) = 4 THEN…

That's the formula I use. The version you show is not summing the full year. That month condition means it is summing YTD (year to date)…..less than or equal to the current month. You need to put some more criteria to it for the period you want. I am about to go to a meeting, I'll try to give you something specific when I…

I don't think there's a built-in feature. But you could create another column in the dataset to represent the colors based on your value criteria. And use custom marker icons (blue and red airplane icons), assigning them based on the data.