Could we show the last run "date and time" of dataset on Dashboard?

user041053
user041053 βšͺ️
edited March 22 in Card Building

I want to show to my team members and other users, When the dashboard is refreshed last time.

Please suggest how I can do it?

Tagged:

Answers

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    Hi @user041053

    You can utilize a single value text card with your data source and select the maximum timestamp of your dataset. You'd just need to make sure to include your timestamp in your dataset. You could utilize a dataflow to add the current date time as a timestamp for when the dataset is updated.


    Alternatively, you could utilize the Domo Data Governance connector to pull the DataSet information which would have the "Dataset Last Updated Date/Time" field which would contain when the dataset was last updated prior to this governance dataset updating. This would mean if your dataset updated after the governance dataset is updated then it wouldn't reflect the correct last updated date and time.

  • Salmas
    Salmas βšͺ️

    Hey @GrantSmith

    Is there any way to get the last execution state of all the dataset as 'Success' or 'Failure' or 'Running' from the Domo Governance Dataset. I wanted to see which datasets are successfully ran and which are failed.

    Looking forward for a solution!

    Thanks

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    There is a DataFlow History report you can pull which has prior executions for each dataflow using the DomoStats connector. There's another version for DataSet History as well in the DomoStats connector.

  • Salmas
    Salmas βšͺ️

    Hi

    I was looking for a execution state for datasets only. I got the status of dataflow from Domo Governance, but looking for the same for dataset from Domo governance only

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    DataSet History from DomoStats is what you want. If you're interested in only the Domo Governance then you'd need to join to the DataSet datasets based on the data source ID to then be able to filter for just the governance type connector datasets.