ArborRose Coach

I have given this example in previous answers. Say you create a formula for the current year. You can use the same formula to also find the value for the year before {previous year}. To find the difference, just subtract one from the other. This should be the same thing you are working with. The difference being, you want…

You can Google "emoji" to find sites and catalogs. This one might help.

Obviously I don't have your data or your structure. This was just using something mocked up. Dates would be actual dates and I would have a calculated field that would identify the week start date.

Calculation for 1/2/23: CASE WHEN Week Start Date='1/2/23' THEN Value END Calculation for Total: SUM(Value) Calculation for Average: AVG(Value)

OpenStreetMap (OSM): OpenStreetMap is a collaborative mapping project where users contribute geographic data. You can access OSM data through various tools and APIs, such as Overpass Turbo (). Use queries to extract zip code boundaries for Mexico City and export them in GeoJSON format. Natural Earth: Natural Earth provides…

Admin » Governance » Toolkit » Schema Management Schema Management lets you change the column type (data structure) of a dataset. If your dataset has an integer as the data type for a field, you can change it to a date.

There appears to be something in the ETL that isn't valid. Perhaps it doesn't have a output tile or something?

Colemen's answer converts the information to date. There is a toolkit function for Schema Management to modify structure for that date. Please mark Colemen's answer as yes if it solves your issue.

Manual recreation - identify the form's field from the existing Smartsheet. Create a Domo form and add fields that correspond to the ones your had in your Smartsheet. Create a dataset or use an existing set to gather form responses. Python - can be used to automate the creation of forms, or populate forms. Or integrate…

Try this formula: DATE_FORMAT(STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d'), '%Y-%m-%d') STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d') extracts the date portion in the format YYYYMMDD. DATE_FORMAT() function converts the date into the YYYY-MM-DD format, which should be sortable.

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?