Best Of
Snowflake Connector | Partition Functionality
Which Snowflake connector is best suited for efficiently utilizing partition functionality when working with datasets that need to be partitioned across multiple columns? For example, if a dataset contains sales data and needs to be partitioned by columns such as region and sales_date to optimize query performance and data organization, which connector would provide the most effective implementation for this use case?
hmadari
Re: View as user or view as role
This feature is extremely important to the successful adoption of Domo within our company. It would provide the ability to validate our security policies, greatly reduce the time spent trouble-shooting access related issues, and improve the user's overall experience.
reydeler
Re: View as user or view as role
This is a great idea! This would be helpful for validating PDP policies
Re: Python script not running
@DavidChurchman @GrantSmithThis is resolved. I did not look at the console tab.
Re: How to add gross profit row into profit and loss pivot table
Thank you for your comment.
Yeah, beast mode can calculate gross profit easily but I don't know how to insert this Gross Profit just below the Total Cost of Sales without joining a second table. Just like the following excel table shows, another row of Gross Profit should be added into pivot table. If I add the Gross Profit calculated by Domo beast mode to the pivot row, each row will have Gross Profit subtotal, which is not what I want to achieve.
RayRay_H
Re: Showing negative number as positive but also making sure the Total Row is summing correctly
Because how Domo processes the data with the Pivot table you can't have your data elements display positive but your total negative and vice versa. I'd recommend logging an idea in the idea exchange to allow for this.
Re: Income Statement
@jaeW_at_Onyx I was able to get to that part, but I am unsure how to create rows like Gross profit, where the calculation is not just sum, but subtraction of sum of cogs from sum of sales. Is there a way for me to create those different calculations for gross profit, operating income, income before taxes?
Re: How set default values for variables in workflow?
That hasn’t been available, but is actually being released to you next week. As of now you cannot, but next week you will. I’ll be releasing a video highlighting the new functionality.
Re: Python script not running
When you look at your Magic ETL's history, is the error thrown on the Python scripting tile or somewhere else?
What's your Python script?
Re: Python script not running
You'll need to reach out to Domo Support to see if they can get you a more detailed answer as likely something is happening in the backend.