shummer Member

Comments

  • Gotcha Sridhar, I think the best solution would be to use a combination of a beastmode and the color rules on a table card. 1. Create a beastmode that works as a flag for current date. It will look like this: case when `date_column` = CURDATE() then 'color me' end 2. You can then add this beast mode to your table, and…
  • Hi Sridhar, If I understand your question correctly, something like this in a beastmode might work: case when `date` <= CURDATE() then CONCAT('<div style="background-color:#bbe491; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', `date`, '</a></div>') end Is that what you're looking for?
  • I think that because you're creating an aggregated value based on an aggregation of other values (Novice, Transitional, and Expert) you're best off to do the aggregation in a data flow instead of a beast mode. I think a beast mode to accomplish this would be almost nearly impossible to write and manage. Best of luck!
  • Hey Lara, You may want to try the uncollapse columns feature in ETL. You can find more information about that here: https://knowledge.domo.com?cid=etlactionseditcolumns The Uncollapse Columns action lets you "pivot" or de-normalize data in tables using key-value pairs, transforming a single column with multiple rows into…
  • Hi user01263, To answer your questions: 1. Yes the alert will trigger if the number increases by more than 1 2. Currently, there is no functionality for alerts that show specific row changes within a card. The only option currently available is to set up alerts based on the summary number in a table card. Hopefully, that…