Best Of
Re: Combine Dynamic by OrgID and Simple Filters in Domo Publish
Figured this out. When setting up data permissions, it is possible to add a second policy for the same dataset. In this case, I have one policy that filters dynamically by Org ID, and another that just filters to the state data I needed.
Re: Multi-Value Gauge Showing 0 Change
Looks like the ReportDate just needed to be sorted by Ascending, not Descending.
Re: Highlighting data x location which does not meet a specified target
Hi @Patricia_Zavisky ,
You just have to go to General under Chart Properties and go to Hide columns and select the column number your formula is in. So I'd suggest making that your first column and just choosing to hide column 1
I made a video for you showing how to do this:
Let me know if it works
Re: Not sure why I am getting a SQL Error
There is an extra space after your text for `Template Schedule Date `. Try removing that?
Re: Date Format formula
Here's the article with all the different codes for date formats:
DATE_FORMAT(`MyDateColumn`,'%m/%d/%Y %h:%i %p')
lowercase %h for 1-12 and uppercase %H for 0-23
Re: Table Total Row and Beast mode Aggregation
Hi @VictorLuiz ,
Just making sure, your dates are dates and not datetimes right? So if you go to the dataset that powers these cards, is that column DateTime a date or does it show hours and minutes too? That might be the issue for the 2nd question. I think I need to see more about the 1st question to understand.
Re: Concat Formatting
you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.
Re: how do you add the remarks in DOMO beastmode?
Sometimes I feel like the Domo community are all about to ask the same question at the exact same time. lol Thanks for the answer guys!
