MarkSnodgrass Coach

Unfortunately, you can't have a drill path card be dynamic in what columns are displayed at this time. A workaround is to build a dashboard and then build cards around your main card that would show the different variations that you want. You would can then configure your main card not to drill, but to interact with the…

Well.. I suppose you could do something in MySQL by using the information_schema table during the process. You could google mysql dynamic column names and see if that is what you would want to do. However, having new column names all the time will require you to update any cards tied to that dataset. The cards won't be…

It seems like you could look at the number of distinct days and the sum of the hours and then divide it and see if it is greater than or less than 7 to determine if it is full. If you did this as a beast mode in the card, this would give you flexibility to allow the user to select different date ranges. Your beast mode…

It seems like your columns names are locked into what they should be renamed to regardless of what the current date is. Wouldn't you just use the Select Columns tile in Magic ETL and change the columns there? FC1 -> Apr-22 FC2 -> May-22 FC3 -> Jun-22 ....

Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns…

If you are using Domo Workbench you can set the column type to string on the schema tab. If it is coming from somewhere else, you can add the zero back in Magic ETL by using a formula tile and the LPAD function like this: LPAD(zipfield,5,'0')

Makes sense. So the base url is specific to the form that was created. For everyone's benefit out there, it is easiest to do a test entry and attach a file and then copy the URL that is being used for that form and then the final number at the end is the file id, which is stored as a value when the form is submitted. Use…

@DanielShurina690 great job figuring that out. How did you determine your base URL? https://dd887... It seems like that might be different for every Domo instance and it's not clear what that is based on.

Try moving your count distinct to the very outside like this: count(distinct (CASE WHEN `BRAND` = 'A' THEN (case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`,`BRAND`)end) WHEN `BRAND` = 'B' THEN (case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`, `SubBrand`)end) END)) 

We have form builder, but haven't used the attachment feature yet. I just played around with it and I don't see how you are supposed to view attachments. I see a documentid column, but it is unclear what url you might add that to in order to view the uploaded document. I will be curious as to what the answer is for this.

Great to hear @svetlana . If you can mark my answer as accepted, that will help others in the community.

You can use some of the slicer cards that are found under the filter chart types to do some of your filtering. You can then change the interaction of those slicer cards by editing your dashboard, clicking on Edit Content on the slicer card and choose change interaction. In here, you can select which cards should respond to…

@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…