jaeW_at_Onyx 🟤

About

Username
jaeW_at_Onyx
Location
Budapest / Portland, OR
Joined
Visits
479
Last Active
Roles
Member, Beta Premier, Beta Program
Points
2,508
Badges
37
Personal Portfolio
https://www.youtube.com/c/OnyxReporting_2
Social Media
https://www.linkedin.com/in/jaewor/
Location
Budapest / Portland, OR

Comments

  • @Jmoreno if you are using the full auth snippet I provided, you have to use your Domo password (not your identity provider password) AND you have to have direct sign on enabled. If you are not able to use that approach, @GrantSmith 's response was correct, you have to authenticate using x-domo-developer-token…
  • see my post at the bottom. you can't write the CASE statement AFTER aggregation and expect a result. COUNT(DISTINCT CASE when `Revenue Amount (Global)` > 100000 then `Contact ID` END) this might work if your revenue is a column on the dataset
  • you can write formulas in the GROUP BY tile too. but as @GrantSmith pointed out, a Formula tile cannot have any aggregations (MAX, SUM, COUNT)
  • usually if the dataflow isn't bugged (as @GrantSmith suggested), if the dataflow won't run it's b/c it's already running.
  • @BrianRowe / @GrantSmith Neither of you are 'wrong' but it is inaccurate to say "it doesn't do average of an average" i'd agree "it's misleading to take the average of an average" but it can be done. this distinction is important because in many situations, new developers get tripped up about logic that's applied before or…
  • it depends on how your data is shaped but either you'll define a series as the secondary axis or i believe you can pass a measure as the secondary axis.
  • Adrenaline is a homegrown sql database. It doesn't have a 'version' per se. Syntax will most closely resemble the syntax you're accustomed to using in BeastModes and the formula tile in Magic 2.0 What problem are you trying to solve?
  • https://domohelp.domo.com/hc/en-us/articles/360043436773-Microsoft-Sharepoint-Online-REST-Connector
  • @anthdell Magic 2 JOINs are case sensitive ... which can be annoying if you're coming from a SQL impelmentation that had different collation rules. another gotcha can be hidden spaces (make sure to trim and lowercase before the join.)
  • it might be a bug, but also, simplify your process. if the criteria for a pdp policy is based on an amalgamation of 18 columns, consider creating a column that represents the output of considering those 18 columns and key the policy off of a simplified column. this will allow you to separate 'bugs with pdp utility' versus…
  • @thwartted if you can't transform the data take a look at period over period charts or flexline charts
  • @MarkSnodgrass i love that! but it'd only work if you kept customer_id on the axis. so you'd see each customer and then be able to filter or see if they have the count = 3. but if you just wanted one number it wouldn't work. at this point it may be easiest to make a summary dataset with the granularity of one row per user…
  • @hello_data if you're getting into scripting outside of Domo I'd take a look at the Java CLI in addition to rdomo or pydomo. this might be a clean low code way to push data into Domo https://www.youtube.com/watch?v=kHSeSbSFS1Q I don't recall if the UPSERT example worked in the end but it does give you an idea of how you…
  • @EWold what's the problem you're trying to solve? It doesn't make sense to me (yet) to combine a lecture and lab (without adding columns) it seems like you'd be assuming that a student cannot attend a lecture and NOT a lab or vice versa. or perhaps get registered for different sections that usually aren't paired together,…
  • @Airwon48, no your description made sense. you currently can't have a filter enabled (which excludes data) and then filter on excluded data. That's why you'd use the default page filter, sorry forgot to link the KB, https://domohelp.domo.com/hc/en-us/articles/360042923914-Applying-Page-Level-Filters-with-Filter-Views users…
  • In a word, it's not possible. Domo does not support filtering across rows for "or" What you could do is create a pipe delimited list for all the datapoints per user eg. AllPoints = 'green|circle' then when you filter you can search for "green" and then search for "circle" and choose the one that overlaps. if you have too…
  • When you configure a card, if you're displaying multiple dates on the axis, you can choose which column you filter on based on the Date Range Field. Typically the field will default to the first field you show on the card.
  • To meet your first requirement, you can set a default filter for a page. If you're doing it in ETL you might have a "isMostRecentWeek" binary column (a 0 or a 1) and then by default always filter to 1. To accommodate your second requirement, we always recommend configuring a date dimension with a week column (i assume you…
  • @Joe_M if your table_cards and your filter_cards are built off the same dataset, then the filter cards will update based on the available data. in other words. if you have two filter cards [foods] and [time_slot] and you select time_slot = afternoon, the list of dishes available will be filtered by [times_slot] =…
  • to use AppDev Studio you may need direct signon enabled. https://domohelp.domo.com/hc/en-us/articles/360042934374-Understanding-and-Configuring-Domo-Single-Sign-On-Using-SAML#:~:text=Direct%20Sign%2DOn%20List.,from%20the%20Domo%20login%20screen.
  • @Ana I strongly recommend against building reporting logic into your connectors. reporting logic is something that would change regularly and should be something a little closer to the hands of the business analyst. extract your data from your source system as cleanly as possible, then build any reporting functionality…
  • @Jack_Kaye certification (imho) was not a thoroughly baked feautre, and @GrantSmith already pointed out some of the shortcomings. You could augment Certification with additional workflow steps. For example you could enable PDP on certified datasets. The upside there is that in order to create a dataflow on a dataset you…
  • @keeeirs10 ... domo support are correct but also not correct ;) in Domo, to see the configuration of a dataset in Domo, the account that was used to configure the connector must have been shared with you. because it wasn't ... you're unable to see the configuration of the connector. Domo are working on expanding…
  • @Raymond if you can get the files local you can use python + api's https://github.com/domoinc/domo-python-sdk or more likely the java cli https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool
  • yikes! that sounds awful. Unfortunately Domo doesn't really have strong tools for managing the creation of beast modes. you'll notice that there are grants that help you limit who can create a calculation shared to a dataset. but once they are there ... getting rid of them can be a bit of a pain. seems to me that training…
  • @Jmoreno yes, you do have to contact support / your CSM to have upsert available as a feature in your instance. by default the feature is not 'turned on.' once enabled, you configure upsert on a case by case basis. by default datasets are set up as REPLACE when you run a connector. UPSERT is a variation of APPEND. might…
  • @Arjuman in addition to posting raw code, it might be beneficial to describe what you're trying to accomplish and let the community know what shape your table is in. it'll certainly help in cases when your SQL is bugged and you're looking for support trying to make it work. (CASE when YEAR(`ResolvedDate`) =…
  • @LCash i wouldn't recommend it, but you could put your product actuals into separate columns using PIVOT in Magic 2.0 it may seem counter intuitive but stacking the data (date, category, metric) would actually be the best solution , because if you had data that was not preaggregated (if you had multiple product x sales in…
  • in the kindest way possible ... if you are having difficulties writing SQL maybe you should consider implementing your dataflow as Magic 2.0 which doesn't require you to code in SQL. select distinct Customer from( select Customer, count(distinct SalesOrder) as Purchases from ArTrnDetail where InvoiceDate between…
  • @Dr_Duru see roles. https://domohelp.domo.com/hc/en-us/articles/360043438953-Default-Security-Role-Reference#:~:text=The%20various%20default%20security%20roles,security%20roles%20available%20in%20Domo.