jaeW_at_Onyx Coach

you don't delete records with partitioning so much as replace a volume. This is a google-able topic, but this might give an idea: https://www.tutorialgateway.org/table-partitioning-in-sql-server/ Flags / Options in the javaCLI when you upload data will allow you to define partition column and values. so just use 'help' in…

@user00563 ... please reread previous comments and revisit the previously linked KB article. https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/04Security_Role_Reference#:~:text=The%20various%20default%20security%20roles,security%20roles%20available%20in%20Domo. Construct your grants based on what you want…

https://www.youtube.com/watch?v=Xb4QgKYgaqg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn This tutorial outlines the concept!

@MosesWynn , I'm interested to know what you were expecting to get out of a certification. (I'm not trolling, it's defo information that should get passed back to Domo and Carolynn and team). I think the idea is to build up a community as well as have a verifiable credential that makes you a bit more marketable as you go…

@Joe_M always test to be sure. but if functionality changes, without a documented reason, then it's worth reporting to support.

@SLam reread my responses. The items to check are all there.

'you can APPEND New_Data and Historical_Data, then use WINDOW&RANK to ROW_NUMBER your data, PARTITION BY phoneCall_ID and Order by TimeStamp.' Make your partition at the granularity of the data (dateTime it sounds like) order by timestamp.

I think you need to be clear about what you're trying to restrict. Assume EVERYONE can access a tab called 'admin.' But not everyone can see the same options / do the same things in the admin tab. So, what exactly are you trying to limit? You describe several unrelated things...

I know i'm late to the party, but @MartinB it's just basic math. CONCAT(ROUND(1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%') If you have 1/3 ( = .33333333) and you wrap that in round( 2) you'd get .33 so when you multiply by 100 you'd get 33. if you wanted 33.33 then you do round(4).

your scenario is unclear. please define what one row means in your input dataset. if i had to guess the granularity is one row per phone call. and it sounds like the phoneCall date can be updated after the first recording of the phone call. If that is correct you can APPEND New_Data and Historical_Data, then use…

restructure your data. such that your columns are Activity Type, User, Unit, rowCount Current, John, Unit 1 , 1 Start , Jonn , Unit 4, 1 Current, Jane, Unit 3, 1 Start, Jane , Unit 2, 1

Domo doesn't support parameterized queries the way you're thinking. But you can hack a solution https://www.youtube.com/watch?v=wmMrnPO9ivY

I don't recommend doing your POP calcs in ETL as it will limit extensibility. https://www.youtube.com/watch?v=CDKNOmKClms&t=205s Instead, my recommendation would be to stack the data as demonstrated in this tutorial.

https://www.youtube.com/watch?v=ysUHYaICYD8 It's a bit nerdy, but you can build a dataflow that recursively appends historical comments to a dataset, and then output that dataset as a webform. This will remove the manual element of copying in the historical data into a dataset, while retaining the ability to modify or…

Hnrgh... well ... no. you can't conditionally run execution. What you could do is count the number of errors and export that with your first pass ETL (although, I would probably just integrate both ETLs into one stage). if you have a recursive dataflow in place you could set the rule "if countOfErrors = 0 then ... replace…

To boil it all down. A filter can only apply on the values in the column. I.e. you can create a filter that says I want all values that are BETWEEN or LESS THAN or GREATER than start date or end date. You could ask your users to apply filters on two columns. Start Date is Less than X and End Date is Greater Than Y. I don't…

interesting. the assumptions you described sound correct to me. to troubleshoot. create an (empty) group. share content to the group. then add a user to the group and confirm that they see the content. if yes, verify your workflow by resharing content with the group instead of individuals and see if the user gets access.…

you need to build a (dimension) table that for each day says what the end (and start) of the fiscal month is. then JOIN that data to your transactions. after that, dateDiff is a piece of cake.

There is a beta feature in development called Filter Groups that will bring you the functionality you're describing. In the immediate term, to support having a 'group average' while allowing filtering down to an individual you have to get clever with how you structure your data. You can - add group average as a column per…

https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/04Security_Role_Reference#:~:text=The%20various%20default%20security%20roles,security%20roles%20available%20in%20Domo. It is possible to enable custom roles so you can make and manage a bespoke set of grants, talk to your CSM for details.

I do not believe Pivot Tables support HTML formatting, so any conditional formatting would have to be applied via color rules in the UI.

Ultimately the answer is 'yes, sort of'. But it's much more nuanced. The files in Domo's Vault (where your dataset gets stored and backed up) is most akin to file-based datalakes. Think Amazon S3 or Dropbox even. Because data is functionally stored as a text file, you can't really ask to "delete a record" because ... it's…

Line or Bar is determined by the ORDER of the series. ex. "the 1st series will be a bar, and the 2nd series will be the line." (or vice versa). For graphs you can swap line or bar by either Changing the sort order of the series (which i believe applies in your use case) or for other chart types, swap the order that items…

Just make sure to include year with @MarkSnodgrass solution. To make a sort-able column I'd recommend generating an integer Year() * 100 + Month() * 10 + CASE WHEN ... then 1 else 2 END GOAL: 2020011 or 2020012

you can trigger dataflow execution via the JavaCLI. you can use windows task scheduler or logic built into a script to decide whether to trigger execution based on day of the month.

So much to chew on here. 1) don't JOIN on a CASE. Implement your date calculations as separate columns so it's easier to see what you're doing and troubleshoot. It's Salesforce and SQL, performance 'does not matter', so the time to generate an extra table is negligible. (or you could use ALTER and UPDATE commands if you'd…

Try removing the input dataset. Save. Reload. Does the output dataset rename? (remember you can always revert to a previous version of an ETL). Also, you can alter your dataflow definitions using the javaCLI https://www.youtube.com/watch?v=ysUHYaICYD8&list=PLUy_qbtzH0S4eYAu13c-NMnyOuxJwspzh&index=1

You can accomplis this by setting up a LEFT JOIN where the left table has a list of every date, and the right table has your transactional data. I would however encourage you to evaluate what value this adds to your data model / analysis because I don't think modeling the data this way adds much value. If i had to guess…

No what you're specifically asking for is not possible (AFAIK). maybe with some premium features (ask your CSM) but probably not. What you could do to make it less confusing is assign ownership of pages you export to customers to a 'generic admin account' at orgs I work with they have a "Domo Admin"' or "Content Admin"…

Sure. In and Analyzer table card, filter on LeftTable.State and put RightTable.isActive on the axis. keep in mind, depending on what else you have in your card, you will either return one row per row in your dataset (i.e. you'll see isActive many times) OR if the table defaults to aggregating, you'll have one row for each…