MarkSnodgrass Coach

@b_rad Ahh... sorry about that. In Magic ETL, click and drag your mouse over all the tiles you want to highlight. Once they are all selected some options show up on the left side. Choose copy to clipboard. Then, go to your other Magic ETL and press ctrl+v to paste those into another ETL.

@b_rad let me know how the dataset via e-mail works out. For your beast mode, you can do this with a rank & window tile and a formula tile. In your rank & window tile, in the first part create sum of metric1 and metric2 by choosing SUM and unbounded and following 0. Something like this: Order it by something and then…

@b_rad if you select everything in the code block above that contains {content-type .... and then press ctrl+c to copy and then go to your data center and create a new Magic ETL and then press ctrl+v it will create all the tiles for you. It can't create the input and output datasets, so those will appear greyed out, but…

Cards can't directly be added as input datasets in Magic ETL. You could get tricky and use the Scheduled Reports and Dataset via e-mail to get around this. Try creating a dataset via e-mail connector and then take the e-mail address that is generated and go to your card and set up a scheduled report to e-mail the card data…

I put together some test data and was able to do what you want to do. My test data had an ID column, a date column and a value column, which is the constant that will be repeated after the first entry. Here's a screenshot of my ETL: Also, you can copy and past this line into a blank ETL and it will have all the information…

I believe you need to click the refresh button within the add-in to have it pull the most recent data.

You might want to look into the PowerPoint add-in for your slideshow. It gives you more control on the number of cards you can include on a slide. You can download the add-in in Admin -> Tool Downloads https://domohelp.domo.com/hc/en-us/articles/360043437953-Using-the-Domo-PowerPoint-Plugin

Try clicking on Run Preview and see if that helps the ETL recognize what columns actually exist. You can also use the expanded formula editor and double-click the column in the list to add it to the formula editor to ensure there are no typos.

That series does make it challenging. Have you considered just using your date field and then in the date range filter, choose to graph by month? It will angle the values when space is tight and it works properly with a series.

Try creating a beast mode called something like YearMonthNumeric with this as the formula: YEAR(`date`)*100 + MONTH(`date`) and then put this in the sorting. It should end up looking like this:

Try putting your actual date field in your sorting properties. This should break up June, July and January getting combined as well as the years in the right order.

You could pull the first character from the month name to get that like this: LEFT(MONTHNAME(CURRENT_DATE()),1) That would get you what you want. If you are using this along the x-axis, it might be helpful to create a beast mode with the month number and put that in your sorting, so that they are in chronological order.…

I think your issue is around the double quotes in parts. Here is an example of how I did one similar where ClaimNumber is my variable name: CONCAT('<a href="https://mydomoinstance.domo.com/page/954056803?pfilters=[', '{%22column%22:%22ClaimNumber%22,%22operand%22:%22IN%22,%22values%22:[%22', `ClaimNumber`, '%22]}', ']"…

You can combine these two datasets very easily in Magic ETL using the Join tile. In Magic ETL, add both datasets (your royalty dataset and your metadata dataset) as input datasets. Then add the join tile and join them on track title. You can then use the select columns tile to select the columns from the metadata dataset…

I would suggest you open up a ticket with support so you will be the first to know when there is a fix for this.

You will have a really hard time wrapping this up in a beast mode since you need to look at multiple rows of data, which requires a feature to be turned on called "window functions in beast modes". Your CSM can enable it for you. Even with it turned on, it's going to be very difficult to put together and maintain. I would…

@user082291 Glad I was able to help. If you can mark any answers as accepted that helped you, that will help others in the community.

The data table that is below the chart that you are working on inside Analyzer is just there to help you see the data that you are working when developing a card. When you select additional columns, it only persists while you are editing the card at that time. Once you save and exit, it will revert back to just showing the…

When you are on a page, click on a card title to view it full size. Scroll down below the card visualization and you will see the dataset that is powering the card. Click on that. This will take you to the data center and to the information about that dataset. From here, you should see the 3 dots in the upper right and can…

When viewing a card, if you click on the name of the dataset below the card, it will take you to the data center dataset page. From there, you can click on the 3 dots in the upper right corner and choose Export Data.

Can you break it up into two datasets an then join it back together in Magic ETL?

It sounds like your Netsuite data is transactional level, and your Adaptive data is monthly. You need to aggregate your Netsuite data to monthly prior to joining with your Adaptive data. You can do this with a group by tile prior to your joining tile. You will need to join on department and month/year, not just department.…

What did you see when you clicked on the data tab of the dataset and scrolled through all the rows? Are they showing there?

On the overview tab of the dataset, how many rows does it say are in the dataset? If you click on the Data tab and scroll to the bottom do you see those rows? If it isn't showing and you double-checked the cell range of import, it might be worth opening a support ticket. Another option would be to upload it again, but then…

You can "remove the header row" by making the header row color and the header font color the same. If your background is white, you can change the font color to lightest grey and turn the opacity to 0. There is not a way to remove the gridlines, unfortunately. You could look into the DDX bricks that are now available in…

@jaeW_at_Onyx is well-versed in this area. Jae, do you have some thoughts you can share to @Ben_Dunlap ?

You can make a table card as your drill path instead of letting users go to the raw table view and put the columns in the order that you want. When allowing users to drill to the raw table view, I've noticed it will put columns that were part of the drill path selection first, followed by other columns. There is not a way…

Have you tried to rebuild your MySQL dataflow in Magic ETL? The latest Magic ETL runs extremely fast and I would expect it to handle 7m in under a couple minutes. You can also do formula rules in the filter tile so that you could filter to month to date at the beginning and then do the rest of your work if you found you…

@mattwelykholowa glad that worked for you. If you can mark the answer as accepted, that will help others in the community.

I was unable to connect to an xlsx spreadsheet in Google using the spreadsheet ID, but I could using the Discovery option and then selecting it by clicking on the 3 dots next to the Choose File. It only seems to find files in the root directory, though, but that could be how my connector was initially set up. I did find…