GrantSmith Coach

Hi @Jessica What does your HTML code like? Are you including your graph in a <div> tag? Have you set the margin on your <div> tags in the CSS to be 0? Also you could add a colored border to your div or other tags to see where they're actually being displayed to help diagnose your issue if it's within your HTML code or if…

Can you expand on what you're needing? Are you wanting to see the data after it's been processed by your function tile or are you wanting to know the underlying query for an API call? There isn't really a way to get the underlying query of the ETL as it doesn't exactly function that way. You can run a preview of your data…

Using a formula tile you can use a regexp_replace function to extract just the domain: REGEXP_REPLACE(`email`, '^[^@]+@([^\.]+)\..*$', '$1') ^ - match the beginning of the string [^@]+ - Match 1 or more (+) of characters that are NOT (^) the @ symbol. @ - match the literal @ symbol [^\.]+ () - Store this for later…

You can wrap your beast mode in an IFERROR function to default it to another value if there was an error with your date conversion

It sounds like an issue with your username and password. Have you confirmed they are correct? Are you able to use the same connection information with the MSSQL application outside of domo to connect to the database? Have you confirmed the server name is correct? Do you have an IT department to work with to confirm the…

What topics would you like to see covered at Domopalooza next year? In Person! Unique / Out of the box design solutions Data Governance Less Fluff, more substance. Not the What but the How. What features would you like to learn more about? Custom applications App Studio What are your top challenges in Domo right now?…

Hi @pwhite8 , You might want to look into domo.onFiltersUpdate() to do something in your brick when the filters update.

Currently this isn't an option. I'd recommend posting this idea to the Idea Exchange where other user can vote on this idea and help direct Domo's product roadmap.

You should be able to pass in the updateMethod=APPEND as a url parameter to the api endpoint.

I believe Domo defaults to Open Sans looking through the CSS.

I'd recommend logging a support ticket to have the Domo team look into this issue in the back end to see if they can find a reason why the dashboard copying isn't working correctly for you in this instance.

Currently I don't believe there is an option and that's something Domo would need to change. I'd recommend logging an idea exchange idea to support unicode characters during CSV exports.

The Domo Knowledge Base contains several good articles about transforming data within Domo. I'd recommend reading over these articles to get a good understanding of the transformation possibilities:

That's fine, you'd just need two different beast modes, one for display and one for sorting. Have the display on your table and the sort in your sorting options on the card.

It does. If fieldname is a timestamp you can just do this to get the numerical equivalent HOUR(`fieldname`)

Domo is doing string sorting and not numerical sorting because you value is a string. You can create a beast mode to calculate the numerical hour value (if you don't already have it) and then use that in the sorting section instead of your actual display hour string you currently are using. This way it will display how you…

Can you expand on this a bit more? It seems you already have variance as a % in your pivot table?

Are the audit date and submit date fields or timestamp fields? I've written up an article previously on formatting the difference between two timestamps which may be helpful.

If you're having issues with the connector I'd recommend logging a ticket with support for them to look into it on the back end.

This is because your regex is searching for a mapping and then replacing that with the same thing it found. Because there is no REGEXP_SUBSTING you need to match the entire string and then it'll replace the entire string with your mapping. You can do this with the ^ (start of string) and .* (any number of characters) and $…

You'd need to do a cartesian join on your dataset with your mapping dataset, apply the rule, and then reduce your dataset back to the original size. Start by adding a new column called Join Column with a value of 1 to each your input dataset and your mapping dataset. Join these two datasets together on the new join column.…

The input dataset should be the one you're wanting to do PoP analysis on along with the calendar dimension dataset from the Domo Dimensions connector. It's good practice to filter out any unnecessary data as early as you can in the ETL to improve processing efficiency. If you don't need dates prior to last year remove them…

It's the grey canvas area your tiles reside. Click inside anywhere inside that area but not directly on a tile then do a control+v to paste the code in.

This would create a new field with the extracted value if it matches the logic, otherwise it's got a value of Unassigned. `field` needs to be replaced with the source field / column which has your campaign name data.

I'd recommend utilizing a custom PoP data dimension to allow you to display multiple years or deltas. I've done a write up on this in the past which you may find helpful.

In Magic ETL JOIN tile can't join using a between clause however you can add a single column to each dataset, give it a name of "Join Column" with a value of 1, then join both datasets together based on this field and then use a filter tile to filter our records were it's not between the two dates.

DONE

Alternatively for a more customizable data solution you can utilize a custom date offset table and gives you a bit more flexibility graphing data than the standard PoP charts. I've done a write up on this before here:

Have you tried using variables? You can conditionally return a specific column based on the criteria selected. You'd just have beast modes for the many different columns you want to display. You'd need to have the same amount of columns though as you couldn't have an empty column.

CASE WHEN REGEXP_LIKE(`field`, '^(A\d+).*$') THEN REGEXP_REPLACE(`field`, '^(A\d+).*$', '$1') ELSE 'unassigned' END You can use a formula tile and a regular expression to pull out the values which start with A followed by some numbers. ^ - Start of the line () - Match group to store the results found - in this case the…