SusieQ — Dojo Community

/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */

Help Center

Community

Comments

Ingenious. Thank you!

in Alerts - Notify when Text Changes Comment by SusieQ October 2022
Thanks for the reply! We installed on sandbox for all users. We uninstalled and reinstalled and it seems to be working now. No idea why.

in Salesforce Connector (Domo Connector Package) Comment by SusieQ February 2020
Yes! The case statement worked. Thanks so much!

in IFNULL - Replace Blank with Text Comment by SusieQ April 2019
Good thought! I applied your formula, but no luck. It still appears blank in the table without the text. I also double-checked my report source and there are no extra spaces. Any other ideas are welcomed, I am willing to try!

in IFNULL - Replace Blank with Text Comment by SusieQ April 2019
This worked! Brilliant. Thank you! Also, I took your suggestion and used the current date. For anyone who is reading this post, the solution for me was: COUNT(case when YEAR(`Last Login`) = year(CURRENT_DATE()) then `Last Login` end) I used the Progress Bar chart type and got the results needed.

in Count Number of Log Ins this Year (2019) Comment by SusieQ March 2019

/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */