Best Of
Re: Turnover calculation query
Hi @Abhijith, as you already have the total 'Employed' and total 'Terminated' from the initial ETL, there's no need for another ETL.
It appears you are after rolling aggregates, so I suggest you look into these great write-ups, as a start, from @GrantSmith:
https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals
https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages
amehdad
Re: Turnover calculation query
Before delving into your working, can I confirm that you have Window functions enabled, in your instance, from your customer success rep?
amehdad
Re: Is it possible to formatting the style of a report that is sent via email?
@lvtrujillot, I've added this to the Ideas Exchange if you want to help vote it up.
https://dojo.domo.com/discussion/53950/customisable-layouts-for-one-off-scheduled-email-reports
amehdad
Re: How to reactivate a dataflow disabled from inactivity?
Hi @user048760, there's more information around this here [https://domohelp.domo.com/hc/en-us/articles/4404652354583-DataFlows-Disabled-Due-to-Extended-Inactivity] but what could be happening is that the update is taking longer than expected, due to the size of data and/or joins, leading to a 'Failed while execution' message and then the dataset auto-disables.
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: Api fails for filters
Also how did you go with the 404 error? Did Support give reasons to why that was happening and how to resolve it?
amehdad
Re: Api fails for filters
Hi @sunny, have you checked if:
- The Referer URL is too long, or
- There are too many cookies sent in the request (so just clear your cookies before processing the request again)?
amehdad
Re: Api fails for filters
You can have your Customer Success Rep help to accelerate the responses once you log the Support ticket.
amehdad
Re: Api fails for filters
Hi @sunny, have you shared the dashboard with the account that created the embed client authentication? The programmatic embed in your site would have an authenticating token attached to it, which is associated with a particular Domo account.
amehdad