“Data Last Updated On Date” Widget

Comments

7 comments

  • Avatar
    An Y

    Hi Liz

    We have a similar requirement for our dashboards, I was wondering if instead of dedicating a widget for this purpose we can display this info in the title of   a widget or utilize the space that the DataSource  'Last Build time'  takes on the screen. Any thoughts ?

     

    An

    0
    Comment actions Permalink
  • Avatar
    Hendrik Venter

    Is there any way to get the TIME component to display as well? This is very useful in cases where there is multiple cube builds per day

    Unfortunately it doesn't seem Sisense supports DateTime (Date AND Time in a single field) you always have to split them, which results in incorrect results a lot of time. 

     

     

    0
    Comment actions Permalink
  • Avatar
    Hendrik Venter

    Also, is there a way to display the date format in the correct format of DD/MM/YYYY? (Days / Months / Years). 

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Hendrik,

    first of all the refresh of data in ECube is always displayed in top bar above dashboard so maybe that would be sufficient. As o workaround for this issue i suggest creating a custom query in ECube which will extract a max date as a single string(store it as text), and then use SmartLable plugin to display it at the top of the dashboard. Hope it helps.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Hendrik Venter (Edited )

    Hi Michael

    Thanks for the quick reply. We use Sisense Embedded and hide all toolbars from the end-user - so they don't see the top bar with last refresh date.

    We've had mountains of issues with widget incompatibilities so been trying to steer clear of any custom widgets we don't have to use. I've already added a custom table in the cube with latest date, its now just a matter of getting it displayed in Date AND Time form (using the correct time format of DD/MM/YYYY) - I'll try the smart label in our dev environment, otherwise I'll stick with a plain table. Pity as I'd like to make the dashboards look a bit better.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Understood Hendrik. Then maybe try this script on top of a Text string, rather than date-time field? Once it is cast to string it should get past date limitations.

    0
    Comment actions Permalink
  • Avatar
    Eyal Diamant

    Hi

     

    I following your oreder and when i copy paste this string"MAX([Days in SomeDate])" to the value filed i get this error 

    0
    Comment actions Permalink

Please sign in to leave a comment.