ggenovese Coach

Having an export button would be great, until then as a workaround you can select all the tiles in your Magic ETL and then click "copy to clipboard" this will give you the json of your ETL that you can paste into a file for version control purposes

You can do this with period over period charts without the need for a specialized beast mode

@Arthi Annadi - I'm not sure if any table cards provide hover text out of the box. You may want to look into DDX Bricks, or search the app store for custom pivot table apps. Another option would be to pivot your data in an ETL so that you can use an HTML Card instead of a pivot table but this has limitations as well. In…

Glad that worked for you! Pivot Tables do not provide a method for adding hover text so I think color coding using color rules may be your best option

The values section is meant for aggregation, because it is possible that when your Rows and Columns intersect that there may be more than one value present. When you place your text field in the values section you're only provided with Count as the method of aggregation, however, if you create a beast mode with the value…

One option is to select the options you want to be the default, and then save it as the default filter view for all users on the page

A couple things to note from the knowledgebase article on drill paths that may be root cause of the issue: Calculations you create using Beast Mode are inherited when you drill from one view to another using the same DataSet. However, calculations are not inherited when you drill to a different DataSet. You cannot create…

Anything you create manually will not interact with the Date Range filter, keep that in mind because it could cause issues. It might be helpful to uncheck "Allow Global Date" filtering on your cards. If you go this route, I would recommend creating a variable and then have a beast mode that uses the variable and then place…

There's a LAST_DAY() Function that gives the last day of the month for a given date: LAST_DAY(STR_TO_DATE(CONCAT(`Year`,`Month`),'%Y%m'))

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…