Best Of
Re: Powerpoint plug-in unable to change page filters
I believe that the page filters save per user. So you wouldn't be racing against your other users to export the cards. The Powerpoint plugin simply exports the view of the cards that you had last filtered for.
Re: Does ETL Support the 'IN' Function in a case when?
If you are talking about using something like the Formula tile in Magic ETL, then yes. It would be written something like this:
CASE WHEN fieldname IN (expr1, expr2, etc...) THEN 'True'
ELSE 'False'
END
If your values for expr1, expr2 are all strings, then they would have single quotes around each string.
Hope this helps.
Re: Domo and GitHub
@faisalnjit if you haven't installed the Domo Governance/Domo Stats cards and datasets in your instance, I would encourage you to do that. This will help you see which pages and cards are being viewed the most and which users are accessing them the most.
As far as dev vs prod, I don't think there is one set best practice, but often people will label datasets as DEV_datasetname, PROD_datasetname to help card designers know which datasets to use. On pages, you can set up Dev pages and only give access to certain people and then move them over to prod pages when it looks good.
There is also a certification process you can require in your instance to have a more formalized process in ensuring the data and cards are ready for production. That is found under Admin - Certified Content.
Hope this helps.
Re: Column Names with R plugin
This will take care of the extra period:
names(data) <- stringr::str_replace(names(data), '\\.\\.', '.')
Is that issue with the DomoR package?
jimmy
Re: Okta Integration
@faisalnjit have you had a chance to check out this KB article, brother?
https://knowledge.domo.com/Administer/Implementing_Single_Sign-On/Enabling_SSO_with_Okta
Re: I am trying to calculate the difference between values in the same column on 2 different dates
Hi @user03781
Have you tried using a LAG or LEAD window function? They'll get you the value from the row before or after respective
You can then take the rank difference between the two dates.
I did a write up on them here: https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages
Re: Schedule report to send out to email of my co-workers.
Unfortunately, CSV is the only file type the Scheduled Reports will be attached as. See the KB article:
You can still open a CSV file in Excel, though.
Re: Write back to a dataset
Hi @Jobur
No, it's a separate connector. (Data -> Cloud App -> Search for webform)
Re: Only include the first instance and ignore others in beastmode
I would recommend adding a first_sale_date field to your dataset. You could do this by using a group by tile and grouping by your cust_id and then calculating the min(`sale_date`) for each cust_id. You would then join that table back to your main table by joining on cust_id. This would give you the first_sale_date as a field for each line of data. I would then also calculate the DATEDIFF(first_sale_date,`signup_date`) within the dataflow as well.
The downside to this approach is if you are wanting to filter out certain products. If you want to be able to show the time from sign up to when the customer first purchases a shirt instead of just any purchase, and then also be able to change a filter and show how long it took them to buy shoes, then this approach would not work.
I offer this as a solution because I am not sure of how to accomplish it within a calculated field. Do you know if you have windowed functions enabled for calculated fields in your instance?