Best Of
Re: How do I aggregate a Beast Mode to a number rather than a case statement?
In your 2nd statement, don't put your quotes around your numbers, that will make them strings. Try this instead:
(CASE WHEN `CustomerName` LIKE'%AGRODEX INTERNATIONAL SAS%' THEN .14 wHEN `CustomerName` LIKE'%ALTURISA GUATEMALA%' THEN .14 WHEN `CustomerName` LIKE'%ANGLISS HONG KONG%' THEN 3 WHEN `CustomerName` LIKE'%BEN FOOD%' THEN 3.20 WHEN `CustomerName` LIKE'%BENISAND MERCHANDISING%' THEN 5 WHEN `CustomerName` LIKE'%BIGOS S DE RL%' THEN .15 ELSE 0 END)
You could put a SUM function around this if that is what you are trying to sum.
Re: Help on recursive dataflow
Hi @user048760
Use a select Columns Tile to select your columns except for your delete after your filter so you don't include delete into your dataset. It's only used within the dataflow.
You can look at step 7 on https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL or look at step 9 for how the final version should look.
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: Domo Everywhere and Access Control
Hi @Tow, you can have your dashboards access settings designed for Users only via SSO. Have a read through this to get more information on 'User Based' sharing of content: https://domohelp.domo.com/hc/en-us/articles/360043437993-Sharing-Cards-and-Dashboards-Outside-of-Domo-Using-Domo-Embed.
Let me know if you're after something else.
amehdad
Re: How do we track if a date occurred within another date column?
I would create a beast mode to do this comparison:
CASE WHEN MONTH(columnA) = MONTH(columnB) and YEAR(columnA) = YEAR(columnB) THEN 1 ELSE 0 END
Then drag this field into your card and choose Sum for aggregation along with columnA and you should get your totals of when they are the same.
Re: How do we track if a date occurred within another date column?
An alternative beast mode is to use LAST_DAY (returns the date of the last day in the month) instead of MONTH and YEAR:
CASE WHEN LAST_DAY(`Column A`) = LAST_DAY(`Column B`) THEN 1 ELSE 0 END
If you're looking to count all of the occurrences and not just when the values are the same for each record you'd need to use an ETL and group your dataset by column B and get a count of records then join that to your original dataset based on the grouped by date and column A to get the number of occurrences.
Re: Importing Data into Domo from our Connectors
You can also utilize UPSERT within workbench as well to update / create records so you only need to pull in the changes assuming your data doesn't get deleted out of your tables. If they do you'd need to use partitioning.
Re: Reddit connector solution
Hi @Ainash
The two main options are writing your own custom connector within the Domo platform or utilizing a scripting language like Python and the pydomo SDK / package to import data into your domo instance after programatically pulling the data from the reddit ads API.
Custom Connector: https://developer.domo.com/docs/custom-connectors/connector-dev-studio
PyDomo SDK: https://github.com/domoinc/domo-python-sdk
Re: Getting Current User Profile Data
Hi @MosesWynn
You can utilize a Dynamic PDP policy for a trusted attribute. I've done it in the past using an employee ID to dynamically apply PDP when they're looking at specific pages.
Re: Domo Everywhere and Access Control
Have you tried using private embed instead of a public embed? Private requires users to be logged into Domo to view the report.
When you choose the Private option, users will need to authenticate to see the embedded content. Because the private embed option uses authentication, filters can be personalized via PDP or programmatic filters.