jaeW_at_Onyx Coach

it sounds like you have two questions 1) how do i identify data that was created in the previous quarter. create a date dimension with columns Date. And Start of Quarter. Then you can JOIN to your fact table and identify if the data was made before the Start of Quarter. 2) how to just show data of the current quarter.…

it sounds like you have two questions 1) how do i identify data that was created in the previous quarter. create a date dimension with columns Date. And Start of Quarter. Then you can JOIN to your fact table and identify if the data was made before the Start of Quarter. 2) how to just show data of the current quarter.…

@AndreF you're describing a couple different things. 1) security should be handled with PDP. full stop. Use PDP. 2) you want to embed inline editor. What's the problem with SSO login? is that not desired behavior? How would you like the experience to be different?

Slight correction. Percent is the same as a * wild card. So to accommodate the newline char add % CASE WHEN 'Note' LIKE '%Bankruptcy Record%Dismissal%' THEN 'Dismissal' ELSE 'Other' END' Domo Formula tiles do support REGEX expressions so just google "regex remove numeric" something like…

@faisalnjit 1) i would recommend a different visualization. consider the Bullet Chart which was designed to show target vs. actuals. by having data spread across two axis you force users to compare something in a way that may not be intuitive. By stacking Actuals and Plan into the same column of your data you've made it…

You mean other than "remove duplicates?" Really not trying to be snide, it sounds like there's a disconnect between what you expect to happen after "remove duplicates" and what is actually happening... If you don't want to lose rows, can you just remove the "remove duplicates" tile?

There is a beta for filtering on aggregates. it has been in early beta for two years and works well enough. @MarkSnodgrass the feature at DP21 is an update to the UI. no idea where we are in beta on that.

it looks like the data wasn't imported properly. if the actual data contains "List" then you need to revisit your connector. Had the dataset imported properly, i would expect to see a lonnnnnnnnng string. P.S. may need to confirm with domo that you can store wide text string datasets.

@mberkeley then split your data upstream into the two separate columns / sets of data. create a stream of data that includes excludes / dedupes category info add a constant "Activity Type" = "page_stats". create a second stream that includes category info but doesn't include the metrics for "time in seconds"…

@mberkeley if i had to guess you have times duplicated because you JOIN'ed two datasets together. If that's the case, instead of JOINing them APPEND them. That way your times don't Duplicate and you don't have to do avg(DISTINCT) https://www.youtube.com/watch?v=PVbOeLSae9o&t=250s

@MartinB when you say you can't console log, what IS it logging? if you just try logging plain text i.e. console.log('hello world') inside the .the() do you get a result?

@Ashleigh is the resident expert on Coursebuilder

@user079817 it sounds like it might be a bug. have you tried sending a message to support? Also, you can sniff network traffic in the browser, try watching traffic when you create a PDP policy in the UI. Maybe it structures the request slightly differently.

@user095063 @MarkSnodgrass is spot on in his SQL. The key difference between JOIN + ON versus subquery + WHERE is that if there was additional data of interest from the subquery, you wouldn't be able to include it in the SELECT clause. But what's your use case? solving SQL syntax is easy... but I have questions about what…

I blogged about it in YouTube / on my blog. Side note, you can do the same thing in Magic 2.0

@User_32236 , Are you hitting a Domo internal API or an external API? Domo has restrictions on which internal APIs can be hit. For more details on the error you can email support@domo.com and they'll forward your issue to the connectors team. Alternatively there is a Connector Support email <supportconnectors@domo.com>

If Databricks is a data layer but you don't have a Domo connector prebuilt you have three major options ODBC driver via Domo Workbench use transfer data via APIs (use your favorite orchestration tool, PyDomo = Python Domo SDK), or Domo CLI,…

@kenhui521 can you ask a more specific question or provide context. there are many ways of retrieving data from Domo... what are you trying to accomplish, how much data do you need to move, with what frequency do you need to move it. What have you tried? what have you evaluated / discounted?

@user069416 , just to clarify, you're sharing dashboards with people. but after the initial share they don't have access. Then you remove them and add them again they have access? if yes, that sounds like a bug, take it up with Support@domo.com but test it first. share a new dashboard (with cards that people don't already…

@user094816 , between @GrantSmith and me, we linked plenty of proper documentation. Can you ask a more specific question about what you're having a challenge with? FWIW, I'm working on a consulting project where I am using export-data in the Java CLI to extract the data i need. Initially we used query-data but it struggles…

support is best equipped to confirm and fix bugs. The Dojo community can give how-to / hacks and workaround, but we can't fix product! Good luck!

@user026529 , the IN argument works fine in a CASE statement in Magic 2.0 formula tile. just tested. Use MySQL syntax.

either use dataset views to construct filtered views of your dataset, or use the domo cli https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool#section_34, to query-data or export-data and create filtered exports.

@user09481 create a filtered dataset view and export the datasetview instead of the dataset. alternativly use the java cli, https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool#section_34 or the PyDomo SDK to construct filtered queries against the dataset.

@jgospel if you think this is a bug, submit a support ticket. information that may be of interest: was this a beast mode built on a dataset view or directly on the dataset, did you share the beast mode to the dataset or just create it at the card level?

Hey @Ian, sorry for the delayed response, do you have a query (fourth screen) are you able to validate connector settings? (second screen)

@MarkSnodgrass kudos for the mega patient answers! I love that. @user026529 , altthough Beast Modes ARE NOT executed in MySQL they do generally follow MySQL syntax. If you're encountering a Syntax error, just google your function + MySQL and it will generally accurately describe the syntax you're supposed to use. There are…

you would have to export from Jupyer dataset with those categories and values then build the card in analyzer. https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Other_Methods/Jupyter_Workspaces_(Beta)

@IanMaddrell this is probably a configuration issue. Please attach screenshots and check your settings closely.

@BrianBeau I think the certification process is intended to be used to support this requirement.