ColemenWilson Coach

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: https://calendly.com/cwilsondomo/15min

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.

Can you share a screenshot of what you are seeing?

Yep blank column is the easiest. You can hide totals for any column so just hide totals for the blank field to prevent the counts from showing.

Hi Muhammad, I am not referring to filter views. I am referring to filter cards which look identical to the screenshot you've provided. You can change the colors on these filter cards to use your company design/colors. https://domo-support.domo.com/s/article/360043428973?language=en_US

Is there a reason you are using DDX bricks for the filters instead of filter cards on the page?

Reviewing the screenshot again I see that OMEG-159 is an Epic. The purple icon with the lightning bolt indicates that this is not a ticket, but an Epic. So that is why you are seeing a different description. In Jira, a ticket and an epic can have the same ID.

Is she receiving other alerts? Can she view in the Domo the card powering the alert? Lastly, can you have her go to the card, select alerts for that card and then check that she has the email logo selected (blue) as shown below:

This is awesome! Thanks Ellibot! 🤖