jaeW_at_Onyx Coach

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

@GrantSmith you forgot to link the video! https://www.youtube.com/watch?v=wmMrnPO9ivY&t=2s @user052485 this is the design pattern Grant was referring to.

@SeanPT can you email me a detailed list of your ask and how / why you'd use it and any competitor products / experiences where you've seen this implemented? I like the idea of what you're proposing, I'm confident it probably would have been done before, and I'd like to check internally with the labs team to see if they've…

Check in with your CSM. There's an upcoming release that will allow you to mass filter cards or change the granularity all in one click.

SSAS cubes are built on SQL tables (is it fair to assume we're talking about Microsoft BI stack)? It might be easier / more efficient to use Workbench to access the SQL database that the cubes are built on. Alternatively you could open your SSAS cube in Excel as a pivot table. Then use Workbench to transfer the data into…

it would be computationally expensive, but could you wrap your metric in a CASE statement that calculates if improper filters have been applied? Example, if the metric is only correct if one state has been selected, could you do: CASE WHEN countDISTINCt(STATE) = 1 then ... else <metric that works across all states> end

@swagner , we can acchieve this with the lag() function in Domo. https://www.youtube.com/watch?v=cnc6gMKZ9R8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=6 Caveat, the LAG() function example in this video will be the last 12 entries. So if there's a gap in days you'd have 'the last 12 entries' not 'the 11 entries in the…

Java CLI will not alter beast modes saved to a dataset @GrantSmith (yet AFAIK). you can backup cards which will give you the json blob / representation of a card. then you can use any text editor to do a string replace of card names. then upload the card definition back to Domo. I think @MarkSnodgrass 's method is ... the…

So... takes a little digging ... an SVG is just a text file. try opening your file in a text editor. It's hard to read but the first thing you'll notice is the embedded URL to a 'background image.' https://mapsapi.tmol.io/maps/geometry/image/16/57/165736. That background image is the vector of your actual map. IF you take…

Ask your CSM if it's possible to pair Salesforce with UPSERT or APPEND. https://www.domo.com/appstore/connector/salesforce-with-upsert-connector/overview While you can use ETL to build out this pipeline, Salesforce + UPSERT would be the Domo-preferred method (as opposed to building a recursive dataflow) for building…

@kelly_tagtow if it were me, I would add a text character in front of the Donor ID upon initial ingestion into Domo. That way you're confident that at ANY PART of the pipeline in Domo (whether Magic, R, or Analyzer), the data gets treated appropriately and no truncation happens. If you're worried about mangling the data,…

To be clear. you CAN run each update statement line by line. It just has to go into a different transform. Each SQL transform can only execute one SQL statement. To get around that, some developers will implement stored procedures to execute a batch of commands. In that case you have one CREATE PROCEDURE and then one CALL

Create a View with SELECT * for each dataset and apply the appropriate PDP. Make the default permission of the original dataset NO ROWS. If certain dashboards need subsets of columns, implement that, it'll deliver the faster view performance. Consider using the PDP UTIL to automate PDP policy creation…

@Manu_UKFD I would take a very careful read of all the settings. To support customers with highly segmented GA datasets and retain multi-year history while minimizing throttling / Google enforced API rate limits, Domo implemented partitioning. In a nutshell Partitioning means "just update new data as it comes along." It is…

@DMJerryVuori , I know this doesn't help you now, but given that you and several other users voiced challenges dealing with date and time data, i'm going to run a mini-hackathon on handling date and time in Domo next week thursday. You're welcome to join:…

I don't think you can force the UI to change behavior. But if you're applying 20+ filters, that's probably very tedious for you and ultimately will be tedious for your end users. Instead, consider building a beast mode with a CASE statement to capture your filter criteria. CASE WHEN filterColumn = 'a1' OR filterColumn =…

If data is not showing up in your uncollapsed columns, be careful and ensure you match the spelling of the lookup value. Domo is ruthlessly unforgiving ? with empty spaces and case sensitivity. look through my screenshots how i SPREAD / Unpivot / One-hot-encode the Contact Type column into one column for each contact type.…