Best Of

Hi @Meha

Have you tried plotting the durations using the total number of seconds then having your beast mode with SEC_TO_TIME as a tooltip to the set your data label or hover text to that tooltip?

@Joe_M If you could accept the answer so that others can more easily find it I'd appreciate it. You can click on "yes" at the bottom of the answer when it asks 'Does this answer your question?'

Agree with @GrantSmith . Here is an example where I use tooltip1 to store the count of a field an incorporate it into the hover text

Hi @LCash, alongside this thread and awaiting the advice of the technical adept users, reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be). 

Hi @Joe_M

The tool tip fields allow you to put additional information into your hover text or data labels without having to generate a new beast mode to display all of the information that you need. You can refer to them in the analyzer settings as %_TOOLTIP1/2/3 etc

Hi @AJ2020 ,@jaeW_at_Onyx and @GrantSmith ,

I did try to find a solution for the above posted problem and I was able to get it done using a HTML table. Below I am attaching a screenshot for the table card and beast mode using which I have created the card.

Beast Mode for Graph Column :

CONCAT(

    '<div>

      <div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">

      <b>0%</b></div>

      <div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">

      <b>20%</b></div>

      <div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">

      <b>40%</b></div>

      <div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">

      <b>60%</b></div>

      <div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">

      <b>80%</b></div>',

      /*<div style="background-color:#ffffff;Text-align:left;Width:',(`Budget` / `Budget`)*0 ,'%;float:right">

      <b>100%</b></div>*/

    '</div><br>','<div style="background-color:#224D75;height:10px;width:',(SUM(`Used`) / AVG(`Budget`))*100 ,'%"></div>')

Beast Mode for %Used Column :

case 

when (SUM(`Used`) / AVG(`Budget`)) * 100 > 100 then CONCAT('<font color=#fa5e5e>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')

  when (SUM(`Used`) / AVG(`Budget`)) * 100 < 100 then CONCAT('<font color=#226F78>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')

end

Do let me know if you find this useful.

-

Thanks,

Anas Ahmed