GrantSmith

You have three options: 1 - Revert your ETL to a prior version that had these versions in it on the Versions tab of your dataflow. If you made additional changes to the ETL after removing these datasets, you'll have to reapply your changes. 2 - Delete the old historical dataset and just create new testing/validation…

で Can an "orphaned" output dataset be re-added to a dataflow? GrantSmithによるコメント 08/19

Quick responses today, but I'll add here's a link to the documentation about the Calendar card: https://domo-support.domo.com/s/article/360043427973?language=en_US

で Calendar Chart GrantSmithによるコメント 08/12

Do you have a picture of what you're currently seeing or how you have your pivot table configured? And is it correct to assume you're sorting based on the Actual Total column?

で The sorting functionality is not working in the Pivot Table. GrantSmithによるコメント 07/29

Are you getting an error when attempting to save the beast mode to the dataset? You should be able to save a beast mode to a dataset that has a variable in it. I've tested in my instance, and it works correctly.

で Domo variable GrantSmithによるコメント 07/29

Hi @verytiredgirl , When I'm trying to do comparisons like this I format my data so that when a date is selected, it will have all the other associated dates with it and then you can just use some beast modes to get the relative values. I've done a write up on this method here:

で Comparing period over period dynamically with Month End Date variable GrantSmithによるコメント 07/22

There isn't a way to do this through the UI, but I'd recommend adding this as an idea in the idea exchange. I'd upvote it.

で Bulk Delete Unused Beast Modes GrantSmithによるコメント 07/20

They likely were developed independently of each other. This would be a great idea for the idea exchange to recommend the Domo team implement and allow other users to vote on this.

で There is no Line Label setting for Symbol Line Chart? GrantSmithによるコメント 07/16

This sounds like a bug with the platform. I'd recommend logging a ticket with Domo Support outlining your issue for the development team to look into.

で United States Map drill odwn GrantSmithによるコメント 07/16

This sounds like a bug with the platform. I'd recommend logging a ticket with Domo Support outlining your issue for the development team to look into.

で Duplicating a Dashboard into App Studio Breaks Cards & Re-adds Previously Removed Cards GrantSmithによるコメント 07/16

What do you currently have set for your sorting options on the card? Are you sorting based on the date first and then the total second?

で The sorting functionality is not working in the Pivot Table. GrantSmithによるコメント 07/16

The public APIs are restricted to datasets created by the API; the API cannot upload data to non-API datasets.

で Datasets creation and adding the data GrantSmithによるコメント 07/08

You could try and leverage Domo's AI capabilities to allow users to ask their questions and get answers.

で How many X did we do in Y? GrantSmithによるコメント 07/08

The issue is likely the top level net revenue and expenses are pre-aggregated and remove the granularity for GL. You may need to swap the data sources so you have your more granular data source to allow for filtering but may require some extra tweaking.

で Can Filter Cards be used with the Domo Finance app in App Studio? GrantSmithによるコメント 07/03

Right now I don't believe it's possible but I'd recommend adding it as an idea in the idea exchange

で Can we use a semantic model as a data source in Magic ETL? GrantSmithによるコメント 07/03

I'd recommend logging a ticket with Domo Support as this sounds like a bug within Domo and they'd be the best resource to help with the issue.

で Filter Selection not working GrantSmithによるコメント 06/26

What type of errors? I'd recommend logging a ticket with support as that'd be the fastest way to get a resolution

で Is there an outage? GrantSmithによるコメント 06/25

"Copies" are actually just the same card. You can see this if you edit the card on both dashboards the ID in the URL for the card will be the same so there isn't really an original and a copy. If you want to "delete" a "copied" card from a dashboard all you need to do is select Move/Copy and remove the dashboard from the…

で How to delete a copy of a card GrantSmithによるコメント 05/26

Hi @Ab_Israni When I'm doing comparisons for year over year for custom ranges what I do is restructure my data so that I have several different periods for each record based on the date. For example if you're looking at January 1st it'll have a current value of Jan 1 2026 and a Last Year period value of 2025. I've done a…

で Same period last year measure GrantSmithによるコメント 05/22

In this case you'll need to log a ticket with support to have them look into the issue.

で Qualtrics Connector Failing for Report "Distributions" GrantSmithによるコメント 05/18

CASE WHEN Metrics = 'QTY' THEN CASE WHEN SUM(QTY) != 0 THEN SUM(QTY) END WHEN Metrics = 'Sales $' THEN CASE WHEN ROUND(SUM(Sales $), 0) != 0 THEN CONCAT('$', ROUND(SUM(Sales $), 0)) END END Just apply the same logic inside your case statement so you have a nested case statement.

で Showing value '0' as blank/null in mega table? GrantSmithによるコメント 04/29

Have you tried using a conditional beast mode? CASE WHEN SUM(`field`) != 0 THEN SUM(`field`) END

で Showing value '0' as blank/null in mega table? GrantSmithによるコメント 04/29

This may be a bug, I recommend logging a ticket with Support to have them look into it.

で Drilldown stopped working on Beast Mode field with HTML (previously worked) GrantSmithによるコメント 04/29

Yes, I'd recommend using the Dataset Copy with Append update method. This will update the dataset every month and automatically give you a timestamp (BATCH_LAST_RUN). You could use an ETL to union these two datasets together and have a column to state "Current" or "Historical" and trigger it to run on your historical…

で Month End Snapshot & Current as of today on the same dataset, is it possible? GrantSmithによるコメント 04/29

Did you end up using the files API endpoint or a different endpoint?

で Programmatic method of sending files to a Pro-Code App's directory GrantSmithによるコメント 04/13

This sounds like a bug with how CourseBuilder is building out the YouTube links. I'd recommend logging a ticket with support

で Domo Course Builder Import - From Existing Card? GrantSmithによるコメント 04/13

When you're using your single groupby (before your formula), what are the values being returned for: SUM(Budget Sales Dollars) SUM(Budget COGs) SUM(Budget Pounds) Do you have any filtering in place? Are there records making it to the group by tile?

で The Math Isn't Mathing GrantSmithによるコメント 04/13

You can create a custom managed attribute which would allow you to use the new field as part of your dynamic groups.

で Dynamic group based on user role GrantSmithによるコメント 04/13

Workbench connects to a single instance. You'll need a secondary workbench server to authenticate with your UAT environment and pull the data.

で How to Federate the dataset from PROD into UAT Instance GrantSmithによるコメント 04/13

Is the account type the same as the connector you're attempting to use or is the shared account type the same as the account type you created?

で Shared read-only service account appears in Accounts panel but not in dropdown selection. GrantSmithによるコメント 04/10

If you store it as a field in your dataset, you can use Smart Text to display it in a notebook card

で Can you add the date/time on a card when it was updated in App Studio? GrantSmithによるコメント 04/09

GrantSmith Coach

コメント