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.