ggenovese Contributor

It looks like your Month Number is "0" and that's what's causing the issue. Do you see any records in your data that might have a Month Number = 0?

You may want to look into Flex Tables as an option, but usually what I end up doing in these situations is use an HTML Table so that I can customize the Arrows, Colors, Rules, etc. Below is just a basic example, but you can see how the beast mode can get very complex with even simple examples: /* Growth Indicator */…

You could try to bring in your data with the eMoney API using a JSON No Code connector https://developer.emoneyadvisor.com/

You can use this formula and filter for 'INCLUDE' — First Saturday of the Month for the Last Six Months CASE WHEN DAY(`dt`) = DAY(DATE(DATE_FORMAT(`dt`,'%Y-%m-01'))+7-WEEKDAY(DATE(DATE_FORMAT(`dt`,'%Y-%m-01')))) AND `dt` >= DATE_SUB(CURRENT_DATE(), INTERVAL 6 Month) AND `dt` <= CURRENT_DATE() THEN 'INCLUDE' ELSE 'EXCLUDE'…

Another option might be to create a beast mode to rank each traveler and then use subtotals to collapse the rows for the travelers whose rank is greater than 25. Assuming you have a field named `Traveler` and a field named `Spend`, first create a beast mode called `Top 25 Ranking` — Rank Each Traveler up to 25 and then…

No problem! The REPLACE() function would work inside of either a Magic ETL or in a Beast Mode inside of a card. The function will strip out the pipes "|" and replace with SPACE and strip out the periods "." and not replace those with anything. If you want to go the ETL route you'd use an Add Formula tile, name it the same…

If you just remove the pipe symbols then you'd end up with a mix of "Company A", "CompanyA","Company B", "CompanyB" etc. so you'd need to replace pipe with a space. But if you replace the periods with a space then you'll have trailing whitespace. So I'd suggest you have two nested REPLACE() functions so that you can handle…

I don't think that it's possible, however a work-around might be to place your translated value column in the tool-tips so that when one hovers over the bar they can see the value in their home language.

If you make Following = 0 then you will get a running sum, it will sum all the preceding records in the partition and none of the following records. If what you were wanting was no frame at all, so the total for each partition placed on each row in the partition, then I find it's best to use a group by and join the sum…

Yes this is also really annoying for JSON connectors, so many options to reconfigure when all you should have to do is change an endpoint!

Hi @Arthi Annadi - You can view the impact of the policy, the knowledge base article I shared demonstrates that. Also, as an Admin, you can also view the impact of the policy by clicking the badge looking icon at the top of your dashboard and select the policy to preview. One note however, is that this functionality…

I reviewed the knowledgebase article and it looks as if you've set up everything correctly, have these datasets ran successfully since the update method was set to append? That's the only thing I can think of that might cause this. KB article I'm referring to:…

I feel that PDP is the best option given the requirements you listed

it looks like you're not using the replacement variable in your SQL statement it should look like this: SELECT id, name, source, dateAdded FROM tablename WHERE id > !{lastvalue:id}! ORDER BY id ASC and then make sure to seed your replacement variable with an id that you would like to start importing with, then once it runs…

Hi - Is sounds as if your data is not set up for this, I would recommend using Magic ETL. The steps would be: Add a Select Columns, choose your conforming dimensions and your Facebook specific columns rename Facebook Engagements as Engagements, rename Facebook Impressions as Impressions, etc. Add a Select Columns for…

I would suggest using PDP's to restrict what the users can see in the dataset https://domo-support.domo.com/s/article/360042934614?language=en_US

If Account Name is not common to both datasets that you appended together then that might explain why that's happening, because you'd have a row with the account name and then another row for the NULL account name. Or for that matter if the account names are even slightly different, extra spaces, or if one is upper case…

it's easy to miss! Hope that works for you!

Yes, in the config for the append tool you can choose the "Include All Columns" option

In Magic ETL you would append these two sources together into a combined output. The append tool will line up your columns by matching names so that you can then build a card off of the dataset that groups by Date, Member, Invoice and SUMs the Sales Amount and the Freight Amount.

Ah, thank you for that additional information. I mocked up a page and can confirm that I am seeing the same behavior. When the bar chart on the right has more than one week then I can click on the axis and filter the page to that week. However, when there is only one week showing then clicking on the axis no longer filters…

Hi - I shared a beast mode that you can use in a card, not an ETL

In your example, are the segments in your By Week card (Live, On Demand, etc) equivalent to the Business Group that's highlighted or the Pres_Name filter that's highlighted?

Having the date selector values available as system variables is exactly the kind of thing I was hoping for when I made this enhancement request, please vote for it if you're interested in seeing this functionality available.

The connector overview says "This connector is provided by Yext. Please direct all inquiries for support to Yext" Also, the Yext documentation for the Review Management API says "NOTE: Not all publishers' reviews will be included in the response. For more details, please contact your Account Manager." So you may have…

Without using the query option, I don't think so. However, you shouldn't have to load 3 years of data for every load. You can pull 3 years based on transaction date one, then set up a recursive etl, and then finally change your connector to incrementally pull in modified records with whatever window you feel is…

The link isn't working for me for some reason but I'd love to upvote it! Are ideas that are from 2017 no longer available to upvote on?

there's a FUZZY_PARSE_DATE() function in Magic ETL, I tested with the string '/3/31/24/' and it converted it to date without an error

If you haven't tried this already, the domo governance datasets would work in this situation. There is a Cards & Datasets report, it's pretty easy to build a card with links to the cards used by a particular dataset using the report. However, having the image of the card is really nice so making it a part of the UI would…

I think you have to do this in an ETL, because REGEXP_REPLACE() doesn't work for me inside of a card. LENGTH(REGEXP_REPLACE(`sample`,'[^A-Z]',''))