ColemenWilson Coach

Last Week: CASE WHEN WEEK(`DateField`) = WEEK(CURRENT_DATE())-1 THEN 'In' ELSE 'Out' END MTD: CASE WHEN `DateField` > LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH AND `DateField` <= CURRENT_DATE() THEN 'In' ELSE 'Out' END QTD: CASE WHEN QUARTER(`DateField`) = QUARTER(CURRENT_DATE()) AND YEAR(`DateField`) =…

Yes! There is a Domo Governance dataset report called "Datasets" that has a field called `Type` that has this information. You would filter the data using the `Type` field to show only datasets who have Big Query as a source. The issue you will run into is dataflows. A dataset could have data from a Big Query data source…

In my experience with this connector, you can only see the Microsoft account logged in through Domo. We created a service account in Domo specifically for this purpose, and have a process to share content with that user in Microsoft so that it can be utilized in Domo. So I don't believe you would be able to see all emails…

Have you looked into the Domo for Office PowerPoint add on?

The DomoStats Dataset History report has a field called `Bytes Inserted` that could be used as well.

Hello, this knowledge article walks through instance time zone setting and how they affect dates:

You would use magic ETL. Use the group by tile and create max and min values. You could also use the formula tile and use MAX() and MIN(). You could also use a beastmode in a card and use MAX() and MIN(). There is also a calendar chart type. This knowledge article walks through how to use them:

Good catch @MarkSnodgrass, I was looking at it on my phone and the ticks appeared to be ' not `

Is there a particular reason you need them to be null? If they are numeric values you can set them to = 0 and if they are strings you can set them to = ‘’ it looks like you are working with percentages, so could you just set it to = 0?

Hmm maybe just eliminate line 3 and replace it with ELSE ‘’

Just use THEN ‘’ END

I’ve solved this by creating a beastmode (calculated field) that nulls out values that I don’t want displayed on lines and only keeps the ones I do. Then use that as a tooltip field and apply as your data label as @GrantSmith recommended.

You’re only wanting the labels on a single selected line but not on the other lines?

As a Domo admin I can see everything anyway so I am not sure why it would be a security issue. Agree with @JasonAltenburg that it should be a grant related to the admin role.

@fadhlirrahman you're welcome!

@creativeobs Checking in one last time to see if this issue was resolved

Here are the click steps for a dataflow dataset: Locate the dataset you want and click it. And here are the click steps for a non-dataflow dataset: Locate the dataset you want and click it.

There is a free calendar dataset available for download in the Domo Dimensions connector, you can search for it in the Domo appstore. It will allow you to create 0 values for days, weeks, months, quarters, or years so that when you plot the line chart there will be 0 values to show on the card. The steps are: 1. Create a…

CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END

What is odd is that usually checking that box will at least bridge the gap so there is no space. It won't plot a 0, but it will remove the gap.

To plot a 0 for gaps you will have to do some ETL work. You'll need to use a calendar dataset and populate it with your values but 0's for the years where applicable. This way Domo will have a value to read for 2019 (for example) which will be 0. For how to solve the many lines issue, is there a logical grouping for the…

@TC1199A and I met and determined that the data was likely being removed from a filter tile in the ETL. He will rebuild and if that wasn't the case report back here. While walking through the ETL I shared some things that Taylor and Davis found helpful and thought I would share them here for those that don't know: When…

If I am understanding your question correctly, you would use a beastmode and calculate those values then use those values on a multi-line chart. You'll need to request beta access to nested beastmodes from your CSM: MAX(`Completion Percentage`) MIN(`Completion Percentage`) AVG(`Completion Percentage`)

@TC1199A Happy to take a look at it with you if you'd like to schedule some time to walk through it:

You can create this beastmode and then use it as a filter on your card: CASE WHEN `yourDateField` <= LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH THEN 'In' ELSE 'Out' END

Once it is a part of the output dataset input (recursive) it shouldn't disappear unless you have some filtering in the ETL that would remove it. Could you provide a bit more details and maybe some screenshots or a screen recording showing the ETL?

To see the time between orders for a customer you can use the rank and window tile with a lag function. Order by order date and partition on customer ID. Let me know if you are still stuck!

It will update with a data refresh. But like I said before, you are comparing an Epic to a Task. They have different information and different descriptions. If you really want to you can override the value with a case statement. Something like: CASE WHEN LOWER(`Description`) LIKE '%communicable diseases on physical%' THEN…

Use the group by tile, set Member Number as the Grouping field and then select Add Formula and use something like the following: GROUP_CONCAT(DISTINCT CASE WHEN ` 3rd Party` IS NOT NULL THEN ` 3rd Party` END)

For the blank field you can copy and paste an empty character as the title so "Blank" wont be displayed. And for the "Blank" field you can just put '' as the value in the beastmode and the 5 shouldn't show.