Best Of
Re: Facebook Ads Advanced connector - values do not match FB Interface
Hi @user17472, have you checked this issue through with Domo support [https://domo-support.domo.com]?
amehdad
Re: Stop code: System_service_exception (the new blue screen of death)
Definitely reach out to Support [support.domo.com] so they can be across this incident and have a deeper look on their end (via the dev team)
amehdad
Re: OneCloud - DOMO REST API
So there's the steps outlined in the OneCloud BizApp article requiring client ID and secret from the setup to be completed on the OneCloud end. But in order to leverage the APIs in Domo (in this case, importing in data), it will require you to obtain an access token. You can learn more about the steps to do on Domo end here: https://domohelp.domo.com/hc/en-us/articles/360042934494-Managing-Access-Tokens & https://developer.domo.com/docs/authentication/quickstart-5
amehdad
Re: INVITER report
@nj-John-mirc, using the 'Activity Log' dataset, you can then refer to Action and Object_Name fields to get the list of instances an 'Invite' action has taken place and who were involved. You'll need to filter to the Admin names as the record for new user invite occurs twice (i.e. One under the new user name and one under Inviter admin user).
amehdad
Re: Issues with Moz connector
The KB article indicates that you are going to need to work with your Doom CSM and support in order to get it configured as the connector isn't completely ready. I would reach out to them to get it configured.
Note: The user interface for building this connector is not yet available in our Connectors listing in the Data Center, meaning you will not be able to configure the connector on your own. However, we at Domo are more than happy to configure the connector for you so you can begin using it to pull your data into Domo. Please don't hesitate to reach out to your CSM or Domo Support. For contact information, see Getting Help.
https://domohelp.domo.com/hc/en-us/articles/360043431633-Moz-Connector?cid=moz
Re: INVITER report
I would check the Activity Log dataset which is available through the DomoStats connector. I see there is an event type of invited.
Re: Get MySQL on latest version
This needs to get implemented. MySQL 5.6 is over 8 years old. Even the latest version MySQL 8 is 3 years old.
Re: Checkbox Selector not showing all values?
That's great to hear @Joe_M . If you have the option to accept answer on my response, that will help others in the community.
Re: Is there a way to only show certain totals in a Pivot Table total column?
Unfortunately, there isn't. The closest thing is at the subtotal level and the option to suppress single item subtotals. Another option is to create a beast mode for your value field and replace values with null on items you don't want totaled and use that field as your value instead.
Re: Magic ETL Nested Case Statement
In your specific category column is Unknown entered exactly like that? Meaning does it have a capital U? These can be case sensitive and it can often be easier to wrap an UPPER() function around your specific category field and then have your like statements be all uppercase. Your Then or Else statement does not need to be uppercase, so you can still have the resulting output however you like.