How to add "Data last updated" in the Looker studio report

[KerstinD]

Hi!
In the left bottom (below the dashboard) there's a small text telling when the data was last updated.
I would like to present this info in the dashboard so the all users can se it clearly.
Anyone knows how to do?
(Tried to find it at Looker support pages but this page looks kind of broken: https://support.google.com/looker-studio/thread/109447438/how-to-add-data-last-updated-date-in-the-r...)
Kind regards
Kerstin

[LUIS_CARDOZO]

Hola Kerstin, eso no se puede lograr  debido a la actualización de datos de looker que viene por defecto ( 15 min, 1H, 4H y 12H ), lo que podrias hacer es agregar si tenes la ultima fecha de tus registros entonces indicas  cuando fue el ultimo insertado en tu base de datos, usando una Tarjeta de resultados y colocando el valor en MAX( Fecha hora )

[KerstinD]

Thank you very much Luis, 
I used Google translate to understand and I think I got it :), but where do I reach the possibility to choose these? (15 min, 1h, 4h, 12 h). My source is Piwik Pro with their own connector so it should work with 15 minutes or even more often.. but when I look at the data source settings I only got a link.. no possibility to choose anything. Guess I am at the wrong place...
I would really appriciate some tips.
Kind regards
Kerstin

 

[hijrdn]

There are a few options for presenting this info:

#1 - If your data is updated whenever your report is opened or the "refresh data" button is selected, here's a solution:

• Create a table with a single dimension. The formula for that dimension should be: CURRENT_DATE TIME(). I am in EST, so I used >>CURRENT_DATETIME("EST")<<.
• Remove metrics. Change Number of Rows from Pagination to "Top N".
• Remove headers, row numbers, & any other formatting so that you ONLY have the text from the formula.

#2 - If your data is not updated consistently, see if your dataset has a timestamp. Then write a formula to display the most recent timestamp from within (I'm guessing that won't work because you asked this question).

#3 - I use a more customized solution where my DWH team generates two CSV files which feed in via SFTP + 3rd Party Connectors. One CSV files contains the data + updates. The second CSV file has the date-time of when the data was generated (just before it was published). I use that custom time-stamp in a broken down table.

There are probably other solutions that could work the that I've never needed to explore.

[KerstinD]

hijrdn, Thank you so very very much! 🙂
This (#1) solved my problem when the data source is a Google Sheet! (image 1)
Anyhow.. when the data source is Piwik Pro.. it works fine as long as I have another dimension together with the new "Current time" dimension. (image 2), but when I delete the dimension "Website name" something goes wrong. (image 3).

Unfortunately your video is very small and blury for me.. I do not know why.. maybe you show something there which I've missed...
I do not expect you to solve this for me... but you seem smart so if you know how to solve it I would be very grateful 🙂
Kerstin
(The specially made dimension (Current time) turned into the type date.. i guess that is as it should be?)

[hijrdn]

My little GIF did not have a solution for this.

Possible Solution: create a metric/calculated field for the table which is >>max(Current Time)<<. Use the new calculated field as your dimension instead.

If that doesn't work, try >>if(Website Name = "your website name", Current Time, 0)<<. Set your aggregation to max & see if that returns the value w/o website name displayed.

Back-Up Solution: create a background colored square/rectangle shape, place it over the portion of your table with the website name you want to hide. Select the table & shape; select Arrange>Group. Fake column removal!

[LUIS_CARDOZO]

Hola Kerstin , podes usar lo que dice Hijrdn en una tarjeta de resultado seleccionando el valor en MAX,  lo probe y funciona: