GrantSmith Coach

They would need to add the data in another dataset. You could utilize a Web Form for the user to edit within Domo (or alternatively a Google Sheet / Excel Document) and then join that data to your dataset to include the annotation.

Currently this isn't an option but I'd recommend adding this to the Idea Exchange as a product enhancement

There isn't a supported version to automated this process however you could utilize the internal APIs to do this.

Currently no, this doesn't appear to be an option to remove it. If you can, perhaps filter out the negative values from your dataset.

Agree with @RobSomers . Fixed functions are great for this use case. You can find more information on them here with several examples.

You'll need to prep your data via an ETL to do this. You can pull in the calendar dimension dataset from the Domo Dimensions connector. In the etl filter your calendar dataset to be after your first date in your dataset and exclude any dates in the future with a filter tile formula `dt` >= DATE('2020-01-01') AND `dt` <…

What method are you using to automate the loading of your data? How quickly do you need your data updated?

What sort of error message are you getting?

Not exactly however you could include an additional column with the notes and use that field as a tooltip and include that in the hover text but that would be a on a row basis and not on a cell basis.

Median isn't able to be calulcated in a beast mode but you can do it within a Magic ETL using a group by tile.

You won't be able to visualize MoM and YoY on the same graph with the PoP charts Domo provides. When I'm trying to visualize both in the same graph I will utilize a custom date dimension table and utilize a line + bar graph to show both values and the PoP % change. I've done a write up on how to configure a custom date…

An alternative would be to have the SA360 data ingested into BigQuery and utilize the BigQuery connector to pull the data.

There is an option with the premium Brand Kit which allows you to white-label your outgoing emails with some features still in Beta. I'd recommend reaching out to your AE to discuss it with them.

Yes, you'll schedule jobs to query your database and then send the data up to Domo to ingest. You can read mode about it here:

If the user hasn't logged in yet you can go into buzz for the user who sent the invitation under conversations > Buzz and you can click the remind button to send them another email. Alternatively if they need to log in and forgot their password you can have them click the Forgot password? link on the login screen.

Currently it's an all or nothing in terms of the interactions however, have you looked into utilizing a FIXED function beast mode with some FILTER DENY to prevent the calculation from being affected by certain columns?

You can utilize a beast mode as part of your card (just make sure to save it to the dataset so you can filter on it on your page) to define the categories.

Not with a connector. You could utilize workbench and have that server connect via VPN before connecting your your database

You can then set your chart to be the last 13 months and create a beast mode to return either yes or no if they're less than the current month. CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURDATE()) THEN ‘KEEP’ ELSE ‘EXCLUDE’ END Then just filter on that beast mode for the KEEP values. LAST_DAY is a hack I use to get the last…

Correct

You could have 2 separate slicers, 1 for the high level category that would filter the other slicer having your lower level slicer to show only those values in your high level category. Alternatively you could likely utilize a Domo/DDX brick to get more control over the filtering / UI interactions to combine them in to a…

Are you simply looking to just remove the open and close brackets and the double quotes?

Alternatively you can use a group by tile and select the minimum value for your pass fail column and join it back to your original dataset that way if any are marked as fail all would become fail.

I’d recommend using the CLI tool to do a large dataset import as it will use the streams API and split your data into chunks and load your data faster

Are you wanting each row to have that 5% value or just a single summary number? if you want each row to have that number you’d need to use a window function 0.05 * SUM(SUM(IFNULL(BuyerDebit,0)+IFNULL(SellerDebit,0)+IFNULL(BuyerCredit,0)+IFNULL(SellerCredit,0))) OVER ()

How is your data structured? That will determine how to proceed with a beast mode. Typically when I’m working with periods comparisons I’ll establish a date dimension table to get different periods easier. I’ve done a write up on this which you can find here:…

Filter your card with a beast mode to calculate the prior week's timeframe and then schedule your report based on the filtered card.

Do you have a fields variable defined in your code prior to this segment?

There are other options depending how technical you want to get. There is the Python SDK you can use or the Java CLI to export those and automate them outside of Domo

You can utilize a window function to pull the MAU for each month and divide your DAU by that number MAX(CASE WHEN `category` = 'DAU' THEN `users` END) / MAX(MAX(CASE WHEN `category` = 'MAU' THEN `users` END) FIXED (BY LAST_DAY(`date`)))