Best Of

Re: Dynamic Column Names in Tables

This would also be helpful in the following scenario…

Let's say we have revenue data in a table from the past 10 years by client, by month. If we create a card and use the 'Last…13 month' date range it filters out any clients that do not have revenue in the last 13 months instead of showing them at $0.

With dynamic column names we could create 13 columns for each of the past 13 months and then set the date range filter to 'All Time' allowing all us to see all clients that have had revenue at any time and how they have done recently.

DK2

1

Domopalooza Live Stream

Does anyone know if there is going to be live stream of Domopalooza presentations?

b_rad

2

Re: Replace personal identifiable information with avatar

There are various ways I could think to tackle this. In one scenario, I wrote a bingo program where I randomly selected from a thousand avatar images that I had created using AI. I stored a few thousand and made sure they balanced out demographically - race, gender, etc. If my data knew the gender and race, it fit the avatar accordingly. Sort of a lengthy process though.

Another way I have done this is with simple silhouette avatars. I only had about a dozen representing genders, and some generics features like long hair, short hair, curly hair, etc.

I have also done it with an avatar generator. Where I let the user select from four panels. A head, torso, legs, and feet to comprise a custom avatar. You can do the same using random numbers from 0 to the number of images you have created for each panel.

I think the easiest approach is to create a set of avatars, and name them all with a number value in the filename. Then use a random number to pull a random image. The more images you have, the less chance of duplication.

Here's my batch file code for renaming all files in a folder. Where it shows prefix, change that to the prefix you want in the filename. In this case, the result would be something like "asian_female_01.png", "asian_female_02.png".

ArborRose

1

Re: Sandbox - Dataflow scheduling

Ken_Boyer

1

Re: How do I search for rows containing specific text and replace the information in that row?

You can use a formula tile and a case statement to set the value:

CASE WHEN REPLACE(`City`, '.', '') ILIKE '%st george%' THEN 'St. George' ELSE `City` END

You can have multiple different WHEN clauses to handle other scenarios.

ILIKE is the case-insensitive version of LIKE where you're matching based on a string with the % serving as a wild card.

GrantSmith

2

Re: Configuring Card for Last Time Federated Dataset Refreshed Based on Browser Time Zone

Hi everyone,

I was thinking of using this solution https://community-forums.domo.com/main/discussion/55095/date-and-time-of-last-update-on-the-dashboard and then with a little javascript, I will be able to adjust to the timezone.

Is this feasible?

random_user_098765

1

Re: DP Feature Release preview

Will we be able to embed an app studio app using Domo Everywhere the way we can share dashboards, or do apps only exist within Domo?

DavidChurchman

1

Re: HappyReturns API

Thanks Mark! I am new to API's, trying to learn everything I can. If I use the JSON Webhook connector, do I use a tool like Postman to create the Subscription with the URL provided in the connector?

jkmahoney

1

Re: Group By Question

You have two options.

Keep with your group by but only group based on the Bill ID and then use a join tile to join that back to your original dataset based on the Bill ID, this will put the total on every record with that same bill ID
The other option is to utilize a Rank and Window tile which will do something similar if you utilize a Bill ID partition with a SUM aggregation.

GrantSmith

1