I would check as well to make sure the certification shows in your account, I would think yours would show as enrolled if you already took the course. I found mine by clicking the menu in the top left → my activities → certification.

I see it when I click certification too so maybe it does not show up until you need to do a re-cert.

@AbiO the screenshot I had was from the home page

@AbiO you should see the Domo Cert and Re Cert on the website

@ArborRose I am not sure I fully understand the ask but if you are just trying to look at the current report then you could do a group by to get the max date and then join that back to your data and filter when the date = max date.

Someone please implement this!! I would love to be able to have a custom message there instead of a generic button or even the ability to customize the link myself. We have an intake process for users needing access and hitting this button gives the user a false sense of completing this intake process.

@brandenmjenkins The screenshot I had was an example from a Variables dashboard in the community instance https://domo-community.domo.com/page/1880852133. Looking at the BMs in this card: https://domo-community.domo.com/page/1880852133/kpis/details/313814371I think its the comparison time range one, its very long though.…

@SS1108 If the service centers always map to the same profit center you could use a mapping table that joins into the ETL or you can do a beastmode/formula tile like below case when 'service' in ('XCS', 'JAS', 'GAF', 'YAG') then 'ABC' when 'service' in ('HIG','OPD') then 'XYZ' end

@kcaudell If you go to learndomo.domo.com there is a section at the bottom of the home page with all the course downloads. You can upload these courses into Course Builder nad then publish them to your Domo instance. Usually you can use Google Analytics tracking to track progress but with the switch to GA4 (as…

@LJ I think you need to remove or change the [] and the %

@Zel does it need to be in an ETL? You should be able to use a pivot table in analyzer to achieve this and then just use the default sorting arrows. If you do need to do it in ETL you would do a group by first with a count distance values and then a rank. Here is what the pivot table would look like just using Table 1 in…

@Brian_WPI Not sure if this will make a difference but check what the date range settings are. The graph shows Last 12 months by month, not sure what the table is doing but it shows Last 12 months. The bar might need to be changed to have default in the graph by or you may need to update the BM to calculate it over months.

@Shwane you might be able to use Variables to accomplish this. There is also a Searchable Filter Domo Brick.

@ArborRose The border feature is fairly new (couple months?) so that is good feedback to add to the idea exchange. Would an acceptable solution be to instead choose a color for the entire column instead of the border? That might be the only other way to establish some separation without going to a custom brick.

@jtrollinger Couple things to check first to narrow out a few options: Can you open up each date field where it says Last 12 weeks and make sure each one is using the same column and that all settings are the same. Try changing the by month to different options just to see how the numbers change. Remove the sort from the…

@Jazeppi sometimes I notice bugs in the Domo bricks that require me to just start over. I would try re making the brick and make sure it works and then make your changes to the JS code one step at a time by commenting it out and see if there is a particular section causing the bug.

it may be useful to show the screenshot of the cards from the analyzer view.

@jtrollinger does either of your cards have anything in the sort option? Sometimes that can mess with stuff. Also, check if your 2.84 card is filtering by anything else directly in analyzer.

Pivot tables also have border options and you would be able to create sub headings by putting different fields in the Columns sections.

@ArborRose I have not seen this with HTML tables but another table chart type in Analyzer called Mega table just got a border feature.

@SayyedHussain there is a Domostats dataset called Dataset Access that will give you the dataset ID and User ID along with what level of access they have (can edit, can share, etc.). You can combine that with some of the other Domostats datasets to get username and dataset name for a full look at dataset access.

@nathankilcrease yes, I was able to add the custom fields but for some reason none of the data is populating for the items of my new property ID. I set up a new GA4 connector and its bringing in data for my non GA4 properties.

@ColinHaze I think you either need the Create DomoApps or Use AppDB grant to edit a Domo Brick.

@Victoria_G1 I find that if someone put a space or nextline in the source data it may cause it to come through Domo as blank and not null. You can try to do a squash space in your formula and then a case statement that looks for both nulls and single spaces and replaces them with text like: case when COLUMN is null then…

@Charlie Bantoft here is more detail on how to do Fixed Functions. I find fixed functions allow for more flexibility then an ETL, especially if you want to do filtering on other fields.

@leaflove if you don't want to create a new field you could also do the same thing in your ETL. Using the formula tile just do ifnull(`Brand`, 'Blank') and then you can filter on Blank.

An alternative would be to incorporate a line to represent your goal that way you don't need as many bars. I do something similar for the same concept. I made an example in the community Domo instance that looks like this. I think having either the prior year or the goal as the line would make sense to the user and then…

@chelsea_ringl Grouped and Stacked bar comes to mind for me but you may need to change some of the settings for it. I think there is a way to customize how many bars you stack so you can have it only stack 2 and then the rest would not be stacked. You may need to do custom sorting so it appears in the right order and…

@D_Markley34 ah that makes more sense, this sounds like it would be a perfect use case for Column Masking once that becomes available.

@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think…