jaeW_at_Onyx Coach

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...

@Stefano your visualization is just an extension of @GrantSmith 's path model. PrevPageCurrent PageNext PageCountabc15startaend1acend42cbc22 if for SessionID = 1 the journey was A > B > A >C then you would have 4 entries for that one journey. Start > A > B A > B > A B > A > C A > C > End That'd be a gnarly little piece of…

Try pulling your data into a card. Although MySQL may show the datatype as text, what really matters is how the data gets stored in Vault (Domo Data Storage layer) and then interpreted into Adrenaline (Domo Database / Visualization) layer. If you think about it, ALL data gets converted into 'text' when it gets stored as a…

I have on decent authority that this feature is on the road map and coming to a Beta / Release soonish.

I appreciate it's frustrating but I'm unsurprised that it's not working as expected. Lat Long are a coordinate pair. So when you graph a point you're expecting Domo to simultaneously apply two filters (lat, and long) on your table card. That said, I'd be really surprised if Domo retained the data in your visualization in…

Can you confirm that your URL works in a table card or similar? Also, I would be unsurprised (but am unsure) whether exporting HTML actually works. In the absence of HTML links you could export as a table via Excel Addon and then link Excel spreadsheet object in Excel.

Welcome to the Dojo the happiestt place on Earth ? You'rs is a very subjective question. Instead, I recommend go to the Appstore, Search for quickstart, and you'll see a ton of quickstarts that you can deploy to your instance in one click. They will give you examples of what can be done in Domo. Pick one that aligns with…

You could wrap your metrics in a CASE / COUNT DISTINCT CASE WHEN (Count ( Distinct USER ID) <= 20 then NULL ELSE <Metric> ) END Think through if you want to FILTER Out Rows (with a WHERE clause) for groups that shouldn't belong. How does that affect the overal metric if I'm showing % of total? If you want to exlcude out…

So what takes 5 minutes? I've never seen Domo take more than a few seconds to login. Does entire dashboards take a while to load? How many cards are on that dashboard? Or do individual cards take a while to load? Is this immediately after updating a dataflow / dataset in Domo? And does card performance get better later on…

hey friends ... wow super old thread! But this trick is a good one. Here's a solution in Redshift that may work a little faster because the MySQL proc does not use indexing and these string operations get expensive.…