Best Of

Re: Can I revert data that I recently appended to my dataset?

On the history tab of the dataset, you should be able to go over the right and wrench will appear and you can choose "delete this update"

MarkSnodgrass

2

Re: How to stop Resource Library notifications?

The closest thing I could find was in notifications settings. At the bottom where it says "Product Updates and Education" click "Manage". I am pretty sure this is just for email notifications. I would reach out to you CSM for further help.

ColemenWilson

1

Re: Data exploration beyond what users have access to

Do you want users to instantly gain access or should it go through a review? Should the request come through Buzz or via another option?

A quick and dirty option is to use the mailto protocol in an HTML hyperlink where you can specify to, subject and message body so you can send it to an automated email box:

<a href="mailto:email@example.com?cc=secondemail@example.com, anotheremail@example.com, &bcc=lastemail@example.com&subject=Mail from our Website&body=Some body text here">Send Email</a>

You can also use the CONCAT to dynamically include the dataset ID in the subject or body depending on your use case.

GrantSmith

3

Re: Change background/format of report

Currently scheduled reports can't get the background changed.

Brand Toolkit (premium) does allow for adding in HTML code for the header and footer in the email templates but the background isn't an option.

GrantSmith

1

Re: Trend line within Table

Can you share an example of what the desired output would look like? Depending on this there might be different card types that you can use to achieve a this behavior and the building of it might be slightly different.

For some cards you might be able to use Segments to have a comparison line, in other cases you might need to build it using a Bar Char with Line but this will mostly depend on what your data looks like and the desired outcome should be.

marcel_luthi

1

Re: What is the format for the substring function?

This KB article may be of help where it outlines the different functions and their formats: https://domo-support.domo.com/s/article/360043429933?language=en_US

SUBSTRING(`Column`,[START POSITION],[NUMBER OF CHARACTERS TO EXTRACT])

GrantSmith

4

Re: Date Transform

You can utilize the STR_TO_DATE function and a date format string to convert it to a date.

STR_TO_DATE(CONCAT(`Year`, '-',`Month`), '%Y-%m')

I'm adding in a concat to add the year and month together as a string to then format.

From the documentation:

STR_TO_DATE

Converts strings (that Domo does not recognize as dates) from one or more string columns into datetime values.
You specify the column(s) and the current date format used in those columns.
STR_TO_DATE('DateCol','%m,%d,%Y')

GrantSmith

2