jaeW_at_Onyx Coach

@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

@hamza_123 in Domo it's called a 'Trellis Chart' new ... sometime last year i believe.

"We are considering an app so that we can display additional input fields used to re-calculate the data table and/or save the additional information." ... it's unclear what you're trying to accomplish. You can use pfilters in URL strings to filter cards:…

@Simon_King I get that it looks like you're battling with authentication. It's unclear to me where you want to apply this code. We have an IDE to facilitate connector development that simplifies authentication. And similarly, if you're passing data to APIs inside a custom app, there's tooling in Domo java CLI that supports…

@RDSco , You can accomplish this Period calculation using parameterized queries. Take a look at this video as a foundation. https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=2&t=63s You can set a date and then use BEAST MODE + CASE statement to calculate the range of dates for…

If you want to stick with Domo-integrated workflows, ask your CSM about the Form Builder App or any apps for capturing user input. I'm pretty sure there are a handful of free and premium options.

https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Setting_the_Time_Zone_for_a_Workbench_5_Job Take a look at this KB. I'm 90% positive that if you set this value to UTC AND you ingest the data into Domo, it will store in UTC and DISPLAY according to company settings. TO TEST THIS Upload Date,…

Awesome, please mark solution answers if appropriate! Glad to help!

I suppose you could make a test account that is an Admin and just carefully control access to credentials. For a multi-tenant environment, Domo Publish might be the best / most secure solution that mitigates risk of data leak. In the absence of that option, check with your CSM about Custom Roles. There is a grant…

https://youtu.be/-yJXArKUNFo @swagner here you go!