Charting

Charting

Displaying dataset last refresh

Is there a way to display the latest dataset refresh date/time stamp when viewing card or while running slide show?

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Comments

  • When viewing a card you could see it at the bottom of the page. In a slideshow I'm not sure. The column that has that is Domo's default _BATCH_LAST_RUN_ but you can't use it as a summary number. I'm assuming you're talking about a publication when you saw slideshow so in that case I don't have a slick answer for you

     

    Domo Update 1.JPG



    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • guitarhero23 ,

     

    Thanks for the reply.  Yes, I am referring to charts (not table cards where I can add _BATCH_LAST_RUN as a column).  I understand you can’t display it as a summary number (just like you can’t display calculated fields, which would be a convenient way to do this).  Thanks for confirming.  Appreciate it.   Maybe Domo can take this as a suggestion and allow calculated fields to be displayed in the summary. 

  • Contributor

    concatsummary.png

    Assuming you have the timestamp in your data you can put it in the summary number through use of the concat() function in a beast mode.  Screenshot above.  One thing to note is that you lose all formatting using the concat() function so you will see additional functions to format the numeric value with a comma.

     

    Beastmode function below.

     

    case
    when sum(`daily_admissions`)>99999 then concat(left(sum(`daily_admissions`),3),',',right(sum(`daily_admissions`),length(sum(`daily_admissions`))-3),' Skier Visits<br><div style=''font-size:12px''>Last Updated: ',DATE_FORMAT(max(`lastupdated`), '%m/%d/%y %h:%i %p'),'</div>')
    when sum(`daily_admissions`)>9999 then concat(left(sum(`daily_admissions`),2),',',right(sum(`daily_admissions`),length(sum(`daily_admissions`))-2),' Skier Visits<br><div style=''font-size:12px''>Last Updated: ',DATE_FORMAT(max(`lastupdated`), '%m/%d/%y %h:%i %p'),'</div>')
    when sum(`daily_admissions`)>999 then concat(left(sum(`daily_admissions`),1),',',right(sum(`daily_admissions`),length(sum(`daily_admissions`))-1),' Skier Visits<br><div style=''font-size:12px''>Last Updated: ',DATE_FORMAT(max(`lastupdated`), '%m/%d/%y %h:%i %p'),'</div>')
    else concat(sum(`daily_admissions`),' Skier Visits <br><div style=''font-size:12px''>Last Updated: ',DATE_FORMAT(max(`lastupdated`), '%m/%d/%y %h:%i %p'),'</div>')
    end


    -----------------
    Chris
  • Thanks!  Appreciate the suggestion.  

This discussion has been closed.