jaeW_at_Onyx Coach

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…

Working with Beast Modes is most similar to creating columns and calculated fields on a table or pivot table respectively with the extra challenge that you cannot use 'cell references' to refer to other rows of data (i.e. previous row) without 'special code'. Beast Modes / SQL are dissimilar to VBA insofar as you can't…

uh... i don't think you've provided enough information for people to give you a good answer. if you're applying date filters at the page level yes, it will filter your cards. So if you have a card that (for example) calculates the percent change between current month and previous month, and then you apply a page filter to…

Step 1. make sure your measure is aggregatable .... so instead of 'Open' / 'Closed' use a 0 or a 1 so we can take the SUM() or AVG() . For your reporting requirement, i think i would be VERY clear about the question I'm asking. are you asking: * "at the start of the week, how many projects were open?" or are you asking *…

Without knowing any more about your depth of knowledge in SQL, it sounds like you may want to brush up on the implications of what a LEFT JOIN does versus an INNER or OUTER join. Recall, a LEFT JOIN will keep all records on the left side and remove any records on the right that don't have a match (on Vendor Id). So in your…

That is interesting and definitely sounds like a bug that you should escalate to support@domo.com They'll have access to logs which will help identify why the behavior is different...

generally if the data does not upload in a recognized format, it implies that there is an issue with the data preventing CAST as date. but to verify. Have you and your colleague (with Windows and Mac) tried uploading the same file on your respective machines using the same method? I would be surprised if it made a…

There is a beta feature in development that will support this. talk to your CSM. I believe it's called filter groups.

I covered this topic a while back. https://www.youtube.com/watch?v=YgevJkjeFqw&t=1s Basically you need to structure your data 'the right way'. It's a bit of a hack but pretty flexible!

@bof this is super valuable feedback that I've seen several times. Please make sure to submit feedback in the Domo product via the rubix cube menu.