Echelon Contributor

Yes, I run my historical datasets once a day, with an append.

It should be as simple as placing the Effort Number into the Sorting section, and sort ascending...non aggregate I would think.

Here's an example that might help you think it through: for our org, we have about 3 products. But 90% of our focus and business is on product #1. To have a data output that focuses by product, is helpful so that every time a new card is created from scratch, you don't have to add in that 1st layer filter of Product = 1.…

I think the problem is adding the two cases together. This is what I came up with: (CASE when `Data Source` = 'Collected' then COUNT(DISTINCT `Message Key`) end) + (CASE when `Data Source` = 'Delivered' then COUNT(`Data Source`) end) Both cases work fine separately, but when I add in the " + " operator, the results are…

Putting this out there for any future users, but I was looking at some of my datasets and it seems to have still not been working correctly. I've gone through the Recursive so many times, my head is spinning. BUT, I think I have found a much easier alternative with the recent Domo update of "Rank and Window". By appending…

This is as probably as good as it gets: https://www.sports-reference.com/cfb/

This is NOT the same thing, but the NEXT best thing that I've been able to do, is through the ETL create separate datasets that pass a date field into a new field with a common name such as "Card Filter Date". Then, create a Page with separate Cards that look at each of the datasets that I want represented... So a dataset…

Good thought, but we are well below our API request threshold. Hmm...

Please see and Upvote the idea here! https://dojo.domo.com/t5/Ideas-Exchange/Report-Scheduler-Schedule-Export-of-Cards/idc-p/23440#M4508

Create a Beast Mode field, and use the below...update with your company information: CONCAT('<a href= URL',`Id`,' target = new> TEXT </a>') Where: * URL = everything including and between the https:// and the .com in your Salesforce URL bar * Id = the field in your dataset that is representative of the Salesforce…

@DaniBoy@CaseyMorgancould you please give us your thoughts on this? Or should I reach out to my Account Rep?

I don't see how this solves anything Caleb. In Beast Mode, I can easily create formulas that would label or count if a Date Field equals say, the Current Date. But there is no way to build on a card, and filter by "Current Date". There must be an ability to have an overarching Date Range Filter, than always forcing that…

Hi @DaniBoy Everything seems to be working as of now. Will reach back out to my Account Rep if it looks off again. Thanks.

This did it - I'm 99% sure I'm pulling in the correct data now...only 1% not sure, because the rows don't EXACTLY match between what's directly in Salesforce, and what is being spit out through the ETL. But, I think it must be just from lag time between the systems. Thanks so much for the help!

I did find that, and it has definitely got me in the right direction. One piece that I can't figure out though, is how does the de-duplicating determing which row to remove and which to leave? What I need to do, is to update the Table that I am creating, and replace it if there is an updated version of a row, with new…

This sounds exactly like my problem, MattE. It seems there needs to be an over-arching calendar of some sort - I have different Sales Data that I need to display on one card, for performance in different metrics for a given month.

Well, I feel silly now. Thanks for the guidance!

@DaniBoy@btmany updates on when this feature will be available?