jaeW_at_Onyx Coach

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

Good news! This is a standard MySQL implementation question! https://www.mysqltutorial.org/mysql-update-join/ You would do use an UPDATE with a JOIN to a table for JOINs based on a SELECT. Alternatively, given that it looks like in your example you want to update one column based on different criteria, you could accomplish…

In PowerPoint you can create different templates (1 card, 2 card , 4 card). Does that impact the export? Alternatively, could you use a different chart type? Maybe a 1 row table card?

MagicETL does support Window Functions which would allow you to create a cumulative total for a year-to-date calculation. If you want something like a percent of total calculation, you would use GROUP BY and then JOIN the grouped data back to the main data. I would recommend that you AVOID aggregate functions like these in…

I'm 95% confident that PDP permissions are ADDITIVE (so if i'm I'm in group 1 and group 3 i will see the data available to group 1 AND the data available to group 3). It sounds like you want to use PDP to provide filtered views of your dashboards and that's NOT the same thing as providing filtered sets of Data. assume that…

java cli has a command delete-dataset which will allow you to delete one dataset at a time. if you want to delete a list of them implement a FOR LOOP in your scripting tool of choice. https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool