jaeW_at_Onyx Coach

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

@swagner , here's the writeup for doing it in MySQL before Domo got clever and released the Formulas tile. Complete with video explanation :P

@user018766 "if I include a user details for every activity, the dataset will be too large" how do you know that statement is true? by too large do you mean "too many columns" or "too many rows"? because from the Domo architecture perspective, neither statement is true. "I have an operation where a million rows are…

@joshpropp welcome to the Dojo! good to see you. Do create a dummy account and share content with groups that said dummy account is a part of. While Login As would be nice, given that people can share content with individuals, if you're testing your security setup, being able to control the access you've deployed vs. the…

@MarkSnodgrass i don't think the user is talking about dataflows. but to your question, @mward_meetveracity , that query gets translated into DQL (domo query language) which then gets passed as a query to the Adrenaline data layer. given that Adrenaline dataflows and dataset views are relatively robust, it's probably safe…

case when max(amount) = max(max(amount)) over () then 1 else 0 end would identify the day with the max amount. but i feel like this would give you the max max on every date. only downside of doing it in ETL is you have to carefully consider, do you want the max for all time or for the range of data you're looking at (which…

Without hacking Domo, you can only APPEND or UPSERT data during ingest (not after ETLs have been constructed). That said, if you get crafty you can alter a dataflow to APPEND instead of REPLACE (but not UPSERT) In this video i got the dataflow to APPEND but was unable to get it to UPSERT as desired.

AFAIK the feature Grant is describing is binary. it's either turn off all email communications from Domo or not. I'm pretty sure that's not the experience you want for you users, and certainly not something you can toggle regularly. There is a setting when you manually create a user in Domo to disable the email (i believe)…

@AnwarBham and @GrantSmith On paper I understand the request, in execution that's a pretty impossible ask. Given that in an ETL a field could be generated by one or hundreds of inputs (formula tiles, group by, JOINs, regex) it's pretty difficult to ask where a field was used. also a field could be called anything, you…

@AtitW I don't know the answer to your question, but trying building a dataset view (beta, ask your CSM) or just use ETL to subset your data.