MarkSnodgrass Coach

Those cards using the dynamic textbox card type. In the analyzer, go to the Chart Properties and to General and then click on the plus sign to see all the different dynamic fields that are available to insert. I'm guessing Change Percent is the field you want to include. The key to the percentage working right is…

In the Filter tile, I am filtering out the rows that end up with Y, which is what rows get from your ELSE clause in your CASE statement. Have you tried implementing what I detailed out? I would suggest you do that and see if the results match what you expect.

Ok. Here is a screenshot of what I built that should get you what you want and I will explain the steps below. The first Add Formula just has your case statement in it and I created a column called Group. (Note: in your case statement, you are using <> ''. You'll know your data best, but I had to change it to IS NOT NULL…

Right. That is why I mentioned you will want to split off the data and then join it back to the main data and apply that value to the other rows with the same req id. If you are unsure how to do this, I can mock something up for you if provide some sample data.

@eshwarboini No problem. Glad I could help. If you can mark my response as accepted it will help others in the community.

Ok. Then it sounds like you just need the case statement portion of your formula and you just need to remove your group by line and it should do what you want it to do.

The formula tile doesn't recognize the GROUP BY term in your syntax. You also can't flag other rows based on one row in the formula tile. You would want to build your flag with your statement and then join the data back to itself to flag those other rows that meet that criteria. If you are unaware, you can split out a…

@eshwarboini There are actually two flex table chart types that you can choose from and they are not the same. You chose the flex table that is under the period over period chart type. You need to choose the one that is under Tables and Textboxes. This will have the additional field that you are not seeing.

That is strange. It shouldn't make a difference, but for consistency's sake, try adding quotes around your src value in your image tags. I noticed you are using quotes on all your other tag values. It's possible the browser you are using isn't rendering it properly. I'm using Chrome and it rendered the images the way you…

I think you should check your output dataset and verify there isn't additional HTML that is messing things up. I took your HTML in your example and pasted it into a Demo Webform and used the HTML table card and it showed the two images right next to each other in one cell.

Yes. One way to do this is to use create a beast mode and use the CONCAT statement to make it one field: CONCAT(' <a href="https://www.walshportal.com/walshintegrated/images/logo-white.png" target="_blank" rel="noopener noreferrer"><img height="20px"…

Have you gone to the History tab and to the right of the Successful/Failed text clicked on the 3 dots to view the details? This should tell you what step in the ETL process is having the issue. One common issue is a data type changing for a column in the source dataset that is being used for aggregation.

A solution that was recommended to me was to change the person's role to Social and reset their password. This puts them in a viewer type role and resetting their password obviously keeps them from logging in with their original password. You might also need to change the e-mail listed in Domo to keep them from resetting…

It looks like there is special consideration for sub-pages. This KB article breaks it down if you haven't looked at it yet.

You can create additional columns based on date calculations to get the range you want and then filter to that range and then use the rank and window tile to do your window functions. If you provide more details as to what you are doing, I might be able to provide a more specific solution.

You need to get a feature enabled that is not enabled by default. Ask your CSM to enable "Window Functions for Beast Modes". Once that is enabled you can calculate this number by creating a beast mode like this: COUNT('Supplier') / SUM(COUNT('Supplier')) OVER(PARTITION BY 'Subcategory')

You can use the DATEDIFF function. You would write it like this: DATEDIFF('Last Payment Date' , 'Auction Date')

You can add this as another WHEN statement: WHEN 'vessel' IS NULL THEN 'exclude' Also for your when `vessel`='' then 'exclude' statement, try changing it to: when TRIM(`vessel`) ='' then 'exclude' This will remove any spaces that are in the field.

Probably need a little more context as to what you are trying to do, but generally you could do this: In your card, set the date range filter to Previous Month Create a beast mode that uses the DAYNAME() function to return the name of the day of a given date. Drag that beast mode into your card and then drag it again and…

Did you look in the Domo Appstore for Marketo? There is a Marketo Dashboard that you can add to your instance that will build out some cards for you as well as the datasets behind it. There is also a Marketo Connector that has a number of different datasets that you can pull to get the information you need.

In order for the attachment to be included, that card has to be shared with that user. In order to share the card with a person, they will need to be a licensed Domo user.

If you are talking about using something like the Formula tile in Magic ETL, then yes. It would be written something like this: CASE WHEN fieldname IN (expr1, expr2, etc...) THEN 'True' ELSE 'False' END If your values for expr1, expr2 are all strings, then they would have single quotes around each string. Hope this helps.

@faisalnjit When you add a new page, you can decide which users can access which pages, this allows you to create page that is only viewable by people that are in charge of creating cards. This would be a development, or "dev", page. When a card is ready for production, or "prod", you can move that card to a page that your…

In the sorting properties, drag your date column in and sort by ascending, then drag in the column you are using for the series into the sorting properties below the date column and choose ascending. That should do the trick. If not, please provide screenshots to make it easier to see what might be going on.

You could do this in a beast mode and it would put it in the 24 hour format without the date: DATE_FORMAT(fieldname,'%T') or this to put it in the AM/PM format: DATE_FORMAT(fieldname,'%r')

@faisalnjit if you haven't installed the Domo Governance/Domo Stats cards and datasets in your instance, I would encourage you to do that. This will help you see which pages and cards are being viewed the most and which users are accessing them the most. As far as dev vs prod, I don't think there is one set best practice,…

They announced at Domopalooza that dashboards can be set to auto width instead of fixed width. I see the capability in my instance, so I assume it is deployed to everyone. Click on Edit Dashboard, then under Options, choose Display Mode and select Auto Width.

There is not a direct integration for pull requests, but you may be able to leverage the Domo CLI tool to pull of what you want to do. It is located in the Admin - Tool Downloads section of your Domo instance. You can read the KB article about the tool here.

Have you tried the Bullet Chart? That might be a good fit for what you are trying to do.

You can select all the items in your Magic ETL and then choose copy to clipboard and then paste it into any text editor and it will copy all the logic to the text file that you can save for later. You can then paste it back into another ETL if you wish to use it again later. The output dataset will remain intact if you…