Best Of
Re: Get MySQL on latest version
Another significant addition to later versions is the JSON parser! Probably one of the most underrated functions added that would be especially helpful for most of our source datasets coming from connectors that cant flatten nested objects or more importantly, we bring in the data still nested to keep the row count low on each call.
Re: How to update node.js and Python version?
Hi @Rushabh, if you haven't already, it's also worth looping in Support [support.domo.com] to get your answers (or for them to escalate to Engineering/Dev team).
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: Export card data using Python, PyDomo
Hi @JR_Iron, have a look through this article [https://developer.domo.com/docs/dataset/import-and-export-data], including sample request codes in Python, to see if you can export your data that way.
amehdad
Re: Inconsistent positioning of Total Labels on Bar Chart
Hi @genaussie, after selecting "Show Total Label", there's an option to change the position from default to Outside, which will make those negative number labels appear at the top of the bar, or Outside Top, which will raise the labels above the x-axis.
Unfortunately, the label positioning is pretty limited currently. Let me know if you are after something else.
amehdad
Re: Is it possible to hide PDP symbol for PDF export (or remove from instance entirely)?
Hi @Ritwik, from what I understand there's no current or planned beta to hide the icon from view. But it's worth also checking with your CSM.
amehdad
Re: SSO Sign-in Problem with Domo Mobile App for Android
Hi @Tow, do you have any error messages? Looking at https://status.domo.com/, there was a minor incident early in the day which looks to have been addressed. It may take longer for the effects of the resolved issue to be felt in your instance so hopefully soon you can get back to normal operations.
amehdad
Re: Default landing page for group
Hi @dacorson, there's no option currently to enable different landing pages per group/users. As a workaround, you could set up a table on the default landing page that has URL links to the different folders/dashboards you want users to navigate to. Afterwards, you can apply PDP rules [https://domohelp.domo.com/hc/en-us/articles/360042934614-Creating-and-Deleting-PDP-Policies] so that certain users/groups would only see the appropriate links for them.
amehdad
Re: Default landing page for group
It has been requested here [https://dojo.domo.com/discussion/53076/individual-group-landing-pages] and perhaps other posts so feel free to upvote this and/or them.
amehdad
Re: Turnover calculation query
Hi @Abhijith, so you need two calculated fields for 'Exit' and 'Employed/Headcount'. Using the fields from the ETL, the Exit beast mode would like:
''' SUM(SUM('Terminated')) OVER (PARTITION BY YEAR('Last Day of Month'), MONTH('Last Day of Month') ORDER BY 'Last Day of Month')
You would then need to calculate the rolling average headcount for each month (year vs prior year), which I don't know how to code dynamically.
After getting those two working, you would combine to create the annual turnover rate calculation.
amehdad