Best Of

Re: Warning: Not all the data is shown

That seems a little dramatic, Domo it plenty useful for hundreds of other things, just because a limitation exists on the amount of rows shown on a table card doesn't make the whole platform worthless. I don't know whether it's a technical limitation they set because of how Domo handles that data being shown or they limit it due to browser performance degredation or something else but I usually take it as a hint that looking at thousands of rows of data isn't really the best thing for the end user to do. Are you expecting them to actually look through 10,000 rows of data? The whole point of Domo and other BI platforms is to take all of this data and present it in a meaningful, higher level way and then with the power of drilling down dive deeper into specific sections. So you build the cards so that when they get down to the table it is a smaller subset of data that hopefully is less than 1,000 rows. If it's more yes, you should export it out and perhaps use something like Excel to do further manipulation of viewing. What is your use case that you need a user to read all over 1,000 individual rows? Why don't they add a filter to reduce the amount of rows? It may be nice if the limit was raised to something over 1,000 but what's a realistic number you'd want? Why would you ever want a user to browse 100,000 rows in a table in a browser?

guitarhero23

3

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.

MarkSnodgrass

2

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.

GrantSmith

2

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

9

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

10

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.

MarkSnodgrass

2

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.

GrantSmith

2

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.

GrantSmith

2

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

GrantSmith

1

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.

GrantSmith

2