Best Of

Re: Can you remove filtering capabilities for specific card level for Participants?

You can't conditionally show or hide different filtering options. If you're looking to restrict the records returned for specific users you can look into PDP to automatically do filtering so they won't be able to see other records.

GrantSmith

1

Re: Workaround to Pivot tables pushing non-valued categories to the bottom.

@Stuck To clarify, by "non-valued" do you mean the the value is zero, null, or an empty string? Regardless, you can get around this by hard-coding a value using a CASE or IFNULL function.

That's probably not the answer you're looking for, but this is by far the simplest way to accomplish what you need. You can still distinguish which values you're overriding based on the value you hard-code in while preserving functionality.

MichelleH

2

Re: How can I get rid of HTML table/cell borders?

Hey @GrantSmith thanks for getting back to me on this!

I found an interesting (but, limited) workaround that I thought I would share here. I knew that I could change the cell background color of an HTML table with a div tag, so I then thought, "What if I change the cell background color to match the default table border color?"

So, I took a screenshot of my table and uploaded it to a website that takes an image input and enables the user to pinpoint a specific pixel on the image and retrieve the hex code. I found the hex code of the default Domo table border color to be #cccccc (like a semi-dark grey). I then added the following code to the beginning of my Beast Mode:

CONCAT('<div style="background-color:#cccccc; border:10px white; border-collapse: collapse; color:black; margin:-10px; padding:10px">',

After the comma, you simply add in whatever Beast Mode code you had written before and then be sure to end the Beast Mode with ,'</div>') to close off the original CONCAT function.

This left me with an HTML table card that appears like a paragraph of text! The only caveat with this method is that you have to stick with the #cccccc hex code.

1234domo5678

4

Re: How do I remove the "Warning: Not All the Data is Shown" from a filter?

Yes, I often add the same field into the optional group by and choose to count.

You can accept your answer so that people know it is not an outstanding question and it will help others that run into the same issue.

MarkSnodgrass

5

Re: Filter is removing nulls plus specified value

@NateBI Nulls don't play well with logical operators. Null isn't the same thing as nothing, it really means that the value is unknown. Is null blue? SQL doesn't know so it treats it as if it meets the condition.

https://en.wikipedia.org/wiki/Null_%28SQL%29

You can use a formula rule to get around this:

IFNULL('status','') = 'Blue'

This will replace your NULL value with a blank which it can evaluate in the comparison.

Alternatively, you could use the formula:

'status' = 'Blue' or 'status' IS NULL