jaeW_at_Onyx Coach

@GrantSmith and @MysteriousDomo , just be careful with timestamp conversion. date functions in Analyzer may or may not calculate current_date based on UTC (as opposed to whatever timezone you're in. do confirm that your assumption about what Interval (24-7) returns is correct. also i don't believe you can use the BETWEEN…

@user30972 , you are correct, mid Spring, Domo changed functionality so that PARTITION on calculated columns, month(SoldDate) no longer functions.

@ST_-Superman-_ i had 2x options! but for good measure, here's a third. 3) i suppose you could preaggregate the data at the rep level and then add category metrics as columns. (but eww gross pre-aggregated data :P )

@JustinB by building your aggregation INSIDE the CASE statement you're applying the CASE statement after aggregation. (i know that sounds like i said the same thing twice... point being, what you're asking for is "after i aggregate the data, i want to substitute the results with a number and then i want to aggregate…

@walker_page , the credentials you use to access the mysql database determines which data 'Domo can see'. it's the same as if you login to mysql with any other IDE, the credentials determine your level of access in the database. so the solution, in your case, is not to 'control Domo's access' so much as change the level of…

a LEFT JOIN will only match values from your webform that actually exist in your Transactional Data. Make sure to validate that the new values you added exist on the LEFT side. When you update a webform, it can sometimes take a few seconds even minutes before the actual data is updated in Domo / VAULT (storage layer). Make…

@Martellooooo , this is dangerous and can lead to heartache down the road. As @GrantSmith indicated, Domo stores (and therefore expects) data to arrive in UTC. If the data isn't in UTC as it enters Domo, then i guess... sure transform it to UTC, but be wary of daylight savings. in the Viz layer, Domo adjusts the data to…

you need that LEAD() window function we did in MySQL + CASE when Status = B

@Joe_M there a handful of solutions 1) remember drilldown can go to a card built against a separate dataset 2) take your entire dataset, UNION it to itself, then fill the Salesperson column with "Group Average", then set up PDP policies such that I have access to my own data and "Group Average". I see myself compared…

Append the dataset onto itself and replace the 'country' with 'Average'. Write a beast mode, case when country = 'average' then avg(amount) else sum(amount) end

if i had to guess i'm betting money that your API (from Adobe doesn't update the data every two hours and instead has a delay in the data that's reported via API. Domo will extract the data from the API that's available. That's standard functionality across all connectors so you can be reasonably confident this isn't an…

Adithya a screenshot of how you set up your beast mode would help. I suspect you have Q1,2,3,4 on the axis. If so then you canot use your beast mode because in Q2 i need to know the data that was in Q1,3 and 4 in order to answer the question. therefore you must use a cumulative sum (which is a window function) to begin…

@loganherzog send a support ticket. sounds like a bug.

@PatM Domo does sometimes role out ... let's call them quality of life improvements ... without saying anything. drop a screenshot and i'll check on my side, but also ask your CSM

@Jessica talk to your CSM, this is a dataset that Domo can make available to clients (it may be a premium / addon)

Being able to add tags based on dataset attributes that are accessible via DG datasets would aid in automating governance activities

@nicangelica , at the moment you should restructure your data to get the desired outcome. to calculate that avg dynamically w/o pre-aggregating your data or doing funky math, your best choice is to: 1) APPEND a version of the dataset to the table where the metric is not duplicated to the full dataset where the team column…

@Liliana the error is exactly what it says on the tin. failed to convert data '$0.00' to type BigNumber for column 'Gross charge' you can't convert $0.00 int a number because of the $ you have to remove the $ from your data before you try to convert it into a number.

@Jessica to use Workbench you login. The information about generating an access token dated back in Dec2018 is ... partially correct. Yes, you can revoke access tokens in Admin - Security - Access Tokens. That's true. But to generate a token for WB, you just login. Sandbox and Prod have different URLs and are separate…

@user074136 some cards under "general settings" have an option to "transpose" the data. but in general 1) don't preaggregate your data using SQL, this will limit your ability to filter your data. instead try to use beast modes in analyzer as a surrogate for SQL aggregation 2) in one column, percent and currency are both…

@GrantSmith you're right. I think if it were me I would ListAgg all products purchased by email onto one row and then do a CASE with a LIKE with MySQL. either that or Group By and combine strings in Magic 2. From there you could create a binary isProduct 1 and isProduct 2 using a CASE statement in a formula tile.

Have you seen the content from DP21 on using PyDomo? https://www.domo.com/domopalooza/resources/managing-users-groups-with-pydomo https://www.domo.com/domopalooza/resources#/all/all/data-governance/all/all/2021

@faisalnjit there's a setting when you configure your connector for how long the data is held in cache before refreshing. Different connectors will handle it different ways, but this is not a card setting.

interesting. you'd need a dataset that tells you the last time the dataset ran and the number of rows that were updated on the last execution (have a look in DomoStats and DataGovernance). keep in mind, the stats datasets are only up to date as at the last time you executed the dataset, so you'd need to update the…

@user046467 , if you only care about Product 1 and 2, then count ( distinct CASE WHEN product in ('1', '2' ) then email end )

heh i can't believe the system doesn't already work this way... that said, with custom roles it looks like you can limit who has permission to share. but this would be binary. either you can share or you cannot as opposed to having it on a per dataset level.…

@user018766 you're in luck, i've done a video on user interactions with large datasets :P with 1B rows you do want to start making good decisions on how you structure your data. I still recommend joining your data using dataset views, just limit the columns you're including. 30 columns is fine.

are you trying to sum sales? or count distinct appearances of an email? (google count distinct it may be what you need). what do you want your final report to look like?

@MarkSnodgrass and @user018766 Yes, if you want Sankey, Domo has it ... definitely google-able... lol. The part you might have challenges with is making sure the data is structured the correct way. Domo Sankeys do not support loops. Ex. user starts in group 1, goes to group 2 goes back to group 1. You can visualize where…

The easier to read variant. CASE WHEN `Vessel` like '%RB%' THEN 'Exclude' WHEN `Vessel` like '%roll%' THEN 'Exclude' WHEN `Vessel` like '%adv%' THEN 'Exclude' WHEN `Vessel` = '' OR `Vessel` is null THEN 'Exclude' ELSE 'Include' END