Best Of
Re: Best practices for performance with the Snowflake federated connector
Hi @danidiaz, how did you go with this?
There's a recent article that sheds some light on how to set up a Snowflake Federated Connector [https://domohelp.domo.com/hc/en-us/articles/360049429094-Snowflake-Federated-Data-Setup] and mentions that "You can create Cards using Analyzer from this [Federated] DataSet, but ETL, SQL DataFlows and DataSet Alerts are not available to operate on Federated DataSets."
If you are after something more specific, to address a business problem/scenario, then it's worth bringing up in the Dojo along with some anonymised/sample data, so that we can help.
amehdad
Re: Percent of total line chart
Yes there is, in your chart, go to Chart Properties -> Data Label Settings -> Click the plus sign on Text to reveal a list -> Click on %_PERCENT_OF_TOTAL
amehdad
Re: Recommendation for Social Media Scheduler that Integrates Easily with Domo
Hi @user027926, while there could be a workaround (for example, if Sprout has a data warehouse export that can feed into Domo automatically via csv), ask your customer success rep and/or Support [support.domo.com] to have them look at it as well (and escalate to Dev for their input as well).
amehdad
Re: Connecting Woo Commerc
Hi @KenTravels, this is a good first place to start to understand the steps of setting up: https://domohelp.domo.com/hc/en-us/articles/1500000161782-WooCommerce-Connector.
Did you have a particular question or issue around connecting?
amehdad
Re: Inconsistent positioning of Total Labels on Bar Chart
Hmm yeah that's odd. It's worth reaching out to Support [support.domo.com] to have them look at it as well.
amehdad
Re: How do I open the datasource editor
Thanks Mark. There was no edit option. What got me where I needed to be was to select details in the wrench, then select 'settings' from the ribbon at the top. (The one that says overview, data, cards, settings, etc ...) Settings brought up the interface I was looking for. It allowed me to edit my connector.
jtallent
Re: Total Row on a tale card is giving incorrect values
Hi @Saketh, so the total row for the card is calculated after the beast mode is calculated, meaning what you see happen is it’s adding your percentages instead of calculating your total percentage.
To go about getting a true total row, you'll need to use an ETL to group your data together and sum all your columns using a Group By tile, then using an Add Constant tile, put the value of Total in your label field, and then append this row to your original dataset.
amehdad
Re: Powerpoint Plugin - Cards on my slides get sent to front every time I refresh
Admittedly, the knowledge guide on the plugin provides no help for your issue.
If you haven't already, you should reach out to Support [support.domo.com] as they can see "under the hood", so to speak, and better advise on what is causing the 'summary numbers' objects to not be in fixed position.
amehdad
Re: Beast Mode Validated but not working
Hi @beatricetan21, the error is occurring because there's an aggregate function (i.e. SUM) on top of another aggregate function (i.e. SUM or COUNT DISTINCT), which isn't possible to process in a beast mode.
What you should do is set up your two SUM and one COUNT DISTINCT portions as 3 separate calculations before Analyzer (for example, as a calculated field in the ETL [https://domohelp.domo.com/hc/en-us/articles/360044258533-Writing-Formulas-in-the-New-Magic-ETL]) and then write your beast mode using the newly created measures.
amehdad
Re: Shouldn't a co-owner of a data set have the same permissions for that data set as an owner?
Hi @user015090, it's worth checking the role of that user in 'Governance'. I know that 'Admin' roles can be able to revert data back to a previous update but double check on the other roles such as:
'Privileged', 'Editor' or 'Credential Owner'
on whether one of the actions that can be seen when the user goes to Dataset -> History -> Action (Spanner symbol) is 'Revert to this point'.
amehdad