Best Of

🎊 Congratulations to our New Community Coach DataMaven!

It's evident that our community is beaming with truly brilliant individuals when we get to announce not one, but two new coaches on the same day! @DataMaven has been a member of the community for over six years, so it was only a matter of time till she joined the ranks. She has earned our highest admiration for being one of the community's longest running members and spending so much of her time and energy into answering countless questions over the years. Thank you, DataMaven, for sharing your wisdom with the community and congratulations on finally gaining the title of Community Coach!

Leave a comment down below congratulating DataMaven for this awesome acheivement!

GrantStowell

5

Re: Fix HTTP 413 Errors when logging into multiple instances

@MarkSnodgrass I am in the same boat. I usaully do a new incognito window. We can look into it but may be nature of some of the use of cookies. We are looking at adding a Switch Instance option to the navigation we are working on (like we have in Mobile app) so that might make this all a bit easier too.

BenSchein

2

🏆️ Introducing our Newest Coach, DavidChurchman

It's time to welcome a new coach into the fold! @DavidChurchman has worked long and hard to attain this prestigious title and it has finally paid off. This is the highest rank a community member can acquire and is a sure indicator of Domo knowledge and expertise. David has been a member of the community for about a year and a half, but he really started to shine as one of Domo's brightest back in August when he earned the title of Community Member of the Month. Since then, David has spread his wings and flown higher than any of us could have imagined. We're so glad to have you as a member of our community, David. Thank you for your dedication and selflessness.

Let's all give him a big round of applause for achieving this huge accomplishment by leaving a comment down below. 👇️ Way to go David!

GrantStowell

3

Re: Pivot table conditional formatting for text and column totals to the left

You can color just the text by sliding the opacity to 0 and then selecting one of the first 3 text options and unselect apply format to table row.

This video walks you through how to do it.

https://youtu.be/F4MjItncJbU

I think you would need to switch to a pivot table if you want total positions for both rows and columns

MarkSnodgrass

2

Re: Creating a marker and deduping in ETL

Yes, you could use a Group-by tile, select ID as your group. If your data is structured like this, where ID 1 is all 1s for the Marker column, then you could use "Average" as your aggregating function.

On the other hand, the way I'd approach this is I would create the marker column with a simple CASE WHEN Product = 'c' then 1 else 0 end. Then you could aggregate with a sum and get the same result.