jaeW_at_Onyx Coach

I don't think it's SQL correct syntax to subtract dates using date - date. you should use date_diff(end_date, start_date) OR convert your dates to unix_timestamp() and then subtract. see if that impacts the output.

Chris, I don't know the UI is behaving the way it is. As a work around could you just create beast mode to give you hours : minutes ...

Domo doesn't really support data in a ragged hierarchy (i assume your table structure is employee_id, emp_name, supervisor_id). You'd have to flatten your hierarchy into columns. L1 = CEO L2 = C-suite L3 = Managers L4 = Reports. Then you can create PDP policies based on those columns. it's a pain. At that point, instead of…

how many rows is 1gb. if we're talking in the low Millions, I would test out building a Date dimension before i invested the effort into building a custom app. also it's a bit of a hack, but you could create a beastmode on just the subset of cards you want the filter to apply to called Date_2 then filter on Date_2, it…

define "huge" @user037924 what you're asking for is not possible in base product without the redesigned I described. there is a beta feature called "Filter Views" (talk to your CSM) which adds the ability to change the date grain of your visualizations as a Page Level Feature cc @GrantSmith 

You could restructure your data such that you have the same data duplicated for days years months etc, you could theoretically filter on a column called 'period type' and then filter for day, month, year ... what exactly do you want to accomplish.

sounds like you're trying to do a category subtotal. you can implement that with a windowed function sum(sum(amount)) over (partition by category) you need to have the feature switch enabled. talk to your csm. If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.…

I don't think there's an easy way per-se to accomplish this. 1) create a rownumber called row_id using the Rank & Window Tile. 2) split your data using 2x SELECT tiles, with Row_ID in both SELECTS. such that SELECT 1 contains all the 'other metrics' and SELECT 2 contains the months of 'projected quanitty.' 3) in SELECT 2,…

No. You can implement in a DSV (dataset view) but there is no native way in analyzer. https://www.youtube.com/watch?v=eifSYZIcPzg&t=465s

yes. calculate the length of your string. then subtract the length of your string if you replace the search character with a blank. ex. length('mf_string') - length(replace( 'mf_string', 'M', ''))

 A table card might be an effective way of displaying a grip of metris succinctly alternatively the Spark Lines card can also show a densely packed set of metrics.

agree with @WHM 's commment... there really isn't a strong reason to export a million rows of data at a time... if you're trying to export your data mart for the sake of backing up your data mart in the JavaCLI there are tools explicitly designed for this task (save to S3 for example). also there are tools like writeback…

You can't build a CASE statement on your Aggregate in Analyzer / Beast modes even with the Beta feature @GrantSmith is referring to. Said beta feature ("Filter on Aggregates") will allow you to ... filter on aggregates, but it won't solve the problem of wanting to bucket activities based on an aggregate. This is a well…

To add a little nuance to it all. PDP policies control what an individual sees when they go to a dataset. Sharing a dataset allows a user to know that an asset exists in Domo. So ... when you share an asset with Group C you don't have to reshare with Groups A and B b/c you've already shared the asset. Additionally you…

In Domo you'll usually want to APPEND / UNION your data together not JOIN when you're combining transactions. Sales and Costs are a type of transaction. Alternatively you can think of Individual activity vs. Daily Total as different types of transactions. Either way, the answer is the same. UNION your data instead of…

@andres ... it's on the user to build the card that they want. i appreciate that the nuances of the differences between an HTML table card and a Megatable might not be clear.... but that's what the dev process is for. can you imagine being asked to document what features are supported in a pie chart versus features…

@user060355 ... be advised though... while showing the regression line in analyzer is interesting, it is very much dependent on the data that you see in your card. which of course implies, as soon as you add filters or interact w/ the card to apply filter, a new regression line will be calculated. it may make sense to…

http://www.silota.com/docs/recipes/sql-linear-regression.html @GrantSmith lol i'm half tempted to try to calculate this in a dataset view (which actually shouldn't be difficult) and then calculate the X and Y points as calculated fields in the DSV. Might have to build a view on a view... but then you could plot it as a…

if the datasets are of reasonable size you can do a cross apply on dataset A to dataset B (join where 1 = 1) then use a FILTER tile to remove rows that don't meet your JOIN criteria. It's not great, but it gets the job done.

you want to search multiple columns or the same column? b/c ATM you can defo use a filter card with checkboxes to many long text values. if you want to search across multiple columns you'd have to build a custom app for that b/c your app would have to 1) combine multpile columns / search across multiple sets of values,…

It's literally covered int the tutorial video ? you need to calculate rank in a dataset view (or ETL) then join it on to your activity.

@GrantSmith the user is describing an NPM package needed for building custom apps. not the java cli we're accustomed to using. @adrianiy have you tried installing validator? https://www.npmjs.com/package/validator

in order to use a connector. you must configure an account (credentials to that source system). THEN inside Domo, in order for another DOMO USER to refresh or rerun your SFDC (salesforce) connector, you must share the ACCOUNT with that USER. think about it. the account you use to access SFDC from Domo is functionally a…

You probably should not truncate your dataset. (unless we're getting into Billions of rows AND you're confident the data has no value.) Today you might not want that data, but in five weeks if you change your mind it'll be borderline impossible to recover the data you threw away without reloading it. I assume you're…

@GrantSmith is correct about the quotes and tildas. @tmullins is correct about the actual beast mode but has the incorrect quotes and tildas. CASE WHEN `PROVINCE_CD` IN ( 'BC' , 'AB' ) THEN 'WEST'ELSE 'EAST'END

could also write a script that generates a connector based on al ist of values in a CSV. but at that point why not sync Sharepoint with a local folder and then use workbench?

turn your visualziation into a table card and take everything off the axes except the beast mode. is it the same as the summary number?

Redshift dataflows can take anywhere from 0 to 15 minutes before it actually starts running. if you look at the details of the execution, you'll get a more accurate sense of the performance of your ETL once the data has been loaded into redshift. Similarly, after you run the etl the data has to be transferred back to Domo…

if the combination of row and column values don't exist, it won't show up in your pivot table. because your pivot table has no way of knowing that this combination of values 'should exist'. what you can do is UNION 'template' rows to your final dataset that includes each desired combination of rows/columns values, just…

to fill down data. for each column you want to track each time the row changes. so you need Prev_Value (use a LAG 1) then is_Change (case when Prev_Value != value then 1 then 0 then cum_sum of isChange in your previous example you should have 1 all the way from Text 1 to Text 2, then from Text 2 onward should be a 2 up…