Best Of
Re: Subtracting Dates Based on Other columns
Hi @user027926, you'll need a combination of window and date diff functions in order to calculate the difference between the two dates. You will need to ask your Customer Success Manager to "enable window functions in beast modes" in order to make use of this.
A bit of food for thought also, doing something like (CASE when 'Order' = 2 then 'Date Ordered' END) - (CASE when 'Order' = 1 then 'Date Ordered' END) won't work as beast modes are calculated on a row basis. With this beast, either there will be values from Order 1 or 2 but won't have both captured. As a result, you'll have a value and NULL per row and also subtracting null from anything will give null, resulting in a blank output.
amehdad
Re: Domo - delete data
I would add that after writing it to another dataset, you can request for those rows to be deleted via Domo Support.
amehdad
Re: Some content is too tall to export
Hi @DP_DynamicData, you can email the page. The stories/dashboards turn out quite nicely when in the email format. You would email to yourself first and then, after some optional editting and messaging, you can send through to external users.
To address the message you get, you can add border elements to sub-divide your dashboard. This would make it easier to know which heights of tables etc need to be reduced.
amehdad
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