jaeW_at_Onyx Coach

@AJ2020 , sorry i was mistaken and updated my post. https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ take a look at the KB.

Ask your CSM about the new data view beta. It will create the experience @MarkSnodgrass without requiring a separate ETL.

EDIT:: I WAS MISTAKEN https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ "All data loaded into Domo is assumed to be in UTC and the company time zone setting will adjust the data from UTC to the selected time zone." Then when you create a card, Domo automatically adjusts the data back…

if you stick to any of the pre-defined layouts, the cards are pre-sized to support exporting. I've also found that using borders in my dashboard to subdivide my page helps ensure I get notifications about which sections exceed the dimensions that allow exporting.

To troubleshoot this try to isolate where the error is. sum( sum( (CASE when `Type`='Charge' then `Amount Paid` else 0 end)+ (CASE when `Type`='Receipt' then `Total Amount` else 0 end)*(-1) ) over (order by `Date Created` asc)) figure out does this do what you expect it to do? sum( (CASE when `Type`='Charge' then `Amount…

https://osxdaily.com/2018/05/24/command-not-found-mac-terminal-error-fix/ It sounds like you don't have a PATH variable defined that links to your NPM install folder or domo install. ... in english. Terminal has a default set of commands defined that you can run from any folder (like cd, change directory, or mkdir, make…

You can accomplis this window functions if you have them enabled in your instance, you may have to ask your CSM to 'enable window functions in beast modes' try the following beast mode: sum(sum(amount) over (order by date_column asc) just swap in the correct column names To overcome the ledger problem APPEND a snapshot row…

it's not mentioned in any of the KB articles. maybe ask support@domo.com

Interesting... i am able to see a Month To Date option under Bar Line that allows me to graph by day. If you're not having this experience, submit a support ticket with your CSM CC'ed maybe ask them to 'confirm if there's a feature switch missing that updates your analyzer experience'

By definition, you can only partition on columns that are part of the card , because those columns in the card become part of the query that extracts data from Domo. To only retrieve one value, keep the Max(Sum ...) and add a data table limit set to 1.

What do you mean by 'large tables' Keep in mind, the core design of Domo is to support driving actionable data, I appreciate it may be frustrating to not be able to see 10,000 rows of data, if that's what you're accustomed to in Excel... but that's not really the design principles behind Domo. What you could do is build a…

@cjack-PML this really is the sort of question you should direct to support@domo.com If it's urgent cc your CSM and ask them to escalate the ticket. the connectors team has done a lot of work on the GA connectors in the past 6 months, i'm sure all the kinks have been ironed out by now, but sometimes expected behavior…

@JasonM519 oh man... this old chestnut. instead of JOINING a cumulative metric (rank & window clicked by org) consider UNIONing the data at two granularities, SELECT a.* b.clicksByOrg b.deliveredByOrg FROM clicks_at_lowestLevel a UNION clicks_at_companyLevel b Make sure to put the clicksByOrg in a separate colun from…

Sure @sdarba I'll compare two majore use cases. 1) adding dimension attributes to a dataset 2) add metrics to a dataset. -- Dimension Attributes -- Some clients will build complex beast modes for categorizing data. Consider: Case when lower(`campaign name`) like '%disney%' then 'Disney' when lower(`campaign name`) like…

can you just filter to MonthToDate and add a previous period comparison?

Are there performance advantages to using the Beast Mode "Share Calculation on DataSet" to create a metric for a DataSet compared to putting logic/formula in a DataFlow to have the metric added as a physical column on the DataSet? Yes...beast modes are evaluated / calculated at runtime. For small datasets, the impact will…

Oliver if you haven't submitted a support ticket, i strongly recommend you do (support@domo.com) if there is a bug in the API it can only be resolved with a JIRA ticket and before Domo can open a JIRA ticket there must be a support ticket

Hey Zena, it's hard to address your question if we don't know how your data is currently structured (what's the granularity? can you provide a sample dataset?) What are the metrics you want to sho in your trend report? If i had to guess you want to do something like the report "how many contractors were working on March 1…

oh wow. that sounds risky. I wonder if that activity is captured in the activity logs. If it's not, definitely something to raise as a feature request because that's the kind of thing you'd want to be notified about. keep in mind I wouldn't expect PDP policies to automigrate between a parent and subscriber instance of Domo…

What do you want to see in your chart? If you leave the value at NULL then you don't show anything because by definition there is nothing to show. If you set the value to 0 then you have a value in your legend. You could create a separate table card that maps NULL activity to a column 'No Recorded Activity' but it would be…

Sorry, if your values are NULL but you cannot set them to zero, what is the desired result? What do you want to see?

At the moment, no. Default Filters is a beta feature coming soon. Contact your CSM for details!

Looks like you have a table card. Did you try changing the chart type?

For ease of use, I would restructure the data Such that I have data1 = one row per campaign. data2 = one row per opportunity then APPEND them instead of JOIN them. By JOIN'ing the data you are currently spreading Opportunity Amount across each associated campaign (hence why you're trying to do 'crazy math'. If you APPEND…

I'm pretty sure if you use the pivot table, it does have the ability to collapse nodes to give you the visualization you're looking for.

Domo can be a little ... weird when dealing with NULLS as filters. Try wrapping your DATE column in a CASE statement and replacing the NULLS with an extreme value that allows you to identify them. ex. CASE WHEN <dateColumn> is null then '2030-01-01' else <dateColumn> end To prevent yourself from having to maintain the…

Definitely a question you should direct to support@domo.com Typically though support won't take ownership of something in your instance except to test, and even then, they usually don't create content in your instance. You can safely reassign cards and dashboards to an internal account. Do follow recommendations from the…

Yeah so still same version as ever. It's unlikely that it was due to a glitch in MySQL...

I saw that with another of my clients too... submit a support ticket and pls let us know. I wonder if any of the new changes impacted interactions.

select version() or select @@version will tell you the MySQL version number. As long as it's still 5.6 (i believe) then the version of SQL didn't change and it's unlikely the problem was a change in MySql...