Best Of
Re: Theme HEX codes
Hi @Jessica
Looking at the color rules it appears that it's using the same 6-color palette as the post you linked. There is a difference if you're using the diverging colors as those have 5 or 9 colors. I went through and pulled all the hex codes for them:
Here's a copyable list:
#FCCF84 #FBAD56 #FB8D34 #E45621 #A43724
#B7DAF5 #90C4E4 #73B0D7 #4E8CBA #31689B
#BBE491 #A0D771 #80C25D #559E38 #387B26
#DDC8EF #C5ACDE #B391CA #8F6DC0 #7940A1
#ABE4CA #8DD5BE #68BEA8 #46998A #227872
#FBB6DD #F395CD #EE76BF #CF51AC #A62A92
#FFFAC9 #FDECAD #FCCF84 #FBAD56 #FB8D34 #E45621 #A43724 #8E251D #661324
#ECF6FD #D9EBFD #B7DAF5 #90C4E4 #73B0D7 #4E8CBA #31689B #00537F #1F4161
#F7FAC9 #DDF4BA #BBE491 #A0D771 #A0D771 #559E38 #387B26 #345926 #223C2F
#FCBCB7 #FD9A93 #FD7F76 #E45850 #C92E25
#D1D1D1 #BABABA #A2A2A2 #7E7E7E #5A5A5A
Re: How to indicate story pages and regular pages on page list
I think you can use the Activity Log to determine which pages are a story page and which ones aren't. I just converted a standard page to a dashboard page and two events were created in the activity log: Organized Dashboard and Edited Dashboard.
You could create an ETL that would look for this event and then create a distinct list of pages with this event. You could then join to your full list of pages and be able to indicate which is a standard page and which is not based on the join results.
Re: How to aggregate CASE Statement values?
change your logic a bit so that you’re adding your different sums together since you want to add all the sums together based on your filters .
SUM(CASE WHEN test = 1 THEN forecast ELSE 0 END) + SUM(DISTINCT CASE WHEN test = 2 THEN forecast ELSE 0 END) + SUM(DISTINCT CASE WHEN test = 3 THEN forecast ELSE 0 END)
Sorry for the bad formatting. I’m on mobile and on vacation :)
Re: ETL Value Mapper
It sounds like it could be a bug, in which case I would recommend opening a case with Domo Support. I would also try creating a new ETL from scratch and see if the issue persists.
Re: Formatting Numeric Values within CONCAT functions to Currency
I recommend formatting it to currency with the concat function in a beast mode. If you try and do it in an ETL, then they would become strings and the card wouldn't be able to sum them when a user is interacting with the card. Here is a beast mode that will format it for you and abbreviate the millions and thousands:
CONCAT('$',
(CASE WHEN INSTR(SUM(`totalreported`),'.') = 10 THEN /*xxx million*/
CONCAT(LEFT(SUM(`totalreported`),3),'.',SUBSTRING(SUM(`totalreported`),4,2),'M')
WHEN INSTR(SUM(`totalreported`),'.') = 9 THEN /*xx million*/
CONCAT(LEFT(SUM(`totalreported`),2),'.',SUBSTRING(SUM(`totalreported`),3,2),'M')
WHEN INSTR(SUM(`totalreported`),'.') = 8 THEN /*x million*/
CONCAT(LEFT(SUM(`totalreported`),1),'.',SUBSTRING(SUM(`totalreported`),2,2),'M')
WHEN INSTR(SUM(`totalreported`),'.') = 7 THEN /*xxx thousand*/
CONCAT(LEFT(SUM(`totalreported`),3),'.',SUBSTRING(SUM(`totalreported`),4,2),'K')
WHEN INSTR(SUM(`totalreported`),'.') = 6 THEN /*xx thousand*/
CONCAT(LEFT(SUM(`totalreported`),2),'.',SUBSTRING(SUM(`totalreported`),3,2),'K')
WHEN INSTR(SUM(`totalreported`),'.') = 5 THEN /*x thousand*/
CONCAT(LEFT(SUM(`totalreported`),1),'.',SUBSTRING(SUM(`totalreported`),2,2),'K')
END))
Here are two other examples of how to do it.
https://dojo.domo.com/discussion/52677/domo-ideas-conference-beast-modes-number-formatting#latest
Re: Course Builder Videos
Here's my current find and replace list for the json. I don't have the multi video one, but if you search for amazonaws in your json files for your courses, you will know there is an issue there.
