有没有一种方法可以将当前时间戳添加到Google Data Studio报表中? [英] Is there a way to add the current timestamp to a Google Data Studio report?

问题描述

我创建了一个简单的报告来跟踪为我们小学筹集的资金.只是一个饼图，它从司库维护的Google表格中选取数据. 现在有一个在屏幕上添加时间戳的请求(通过截屏并在各种社交媒体平台中共享以报告进度来共享该报告).

I created a simple report to track the funds raised for our primary school. Just a pie chart that picks data from a Google Sheets being maintained by the treasurer. There is now a request to add a timestamp on the screen (the report is being shared by taking a screenshot and sharing in various social media platforms to report progress).

经过一段时间的谷歌搜索之后，我找不到返回当前时间的函数.表格中的= now()之类的东西.但是，建议尝试在源数据中创建时间. 因此，我使用以下功能创建了一个字段，用于在Google表格中存储当前时间的值:

After some Googling I couldn't find a function that returns current time. Something like =now() in Sheets. However, it was recommended to try create the time in the source data. So I created a field that stores the value of the current time in Google Sheets using this function:

=(now()-date(1970,1,1))*86400

我还将表格设置为每分钟刷新一次.床单工作完美.

I also set the Sheets to refresh every minute. The Sheets works perfectly.

在Studio端，我添加了一个计算字段，以我喜欢的格式显示时间:

On the Studio side I added a calculated field to display the time in my preferred format:

TODATE(Amount,'SECONDS','%H:%M:%S on %d %b %Y')

同样，此转换效果很好.

Again, this conversion works perfectly.

问题在于时间刷新在报表端不起作用.无论我刷新数据多少次，它仍然不会从源中选择更新的时间.但是源表具有更新的时间.

The problem is that the time refresh doesn't work on the report side. No matter how many times I refresh the data it still doesn't pick the updated time from the source. Yet the source sheet has the updated time.

据我所知，必须手动触发工作表时间更新才能更新报告.

As far as I can tell, the worksheet time update has to be triggered manually for the report to be updated.

这否定了时间戳的全部目的.

That negates the whole purpose of the timestamp.

目前暂时不直接从Google Studio共享报告.尽管如此，我还是分享了报告.

Sharing the report directly from Google Studio is not a practical option for now. Still, I have shared the report.

推荐答案

尚无功能，但希望很快会出现(请参阅:

There isn't a function to do that yet but hopefully will come soon (see:https://issuetracker.google.com/issues/78200216 which is assigned) however with a little careful design, you could achieve it using date rather than timestamp utilising a date filter.

如果您的数据中没有日期字段，则只需将其设置为今天"即可.

If you don't have a date field in your data than you could simply set this to TODAY.

如果您有日期字段，请使用高级日期设置字段最早日期的开始日期和最大日期TODAY.

If you do have a date field then use the advanced date to set a start date of your field's earliest date and max date of TODAY.

然后，您可以使用一些形状/格式来掩盖不需要的内容.

You could then use some shapes / formatting to cover up what isn't needed.

本来很理想，但也许有一个止步差距?

Hardly ideal but maybe a stop gap?

这篇关于有没有一种方法可以将当前时间戳添加到Google Data Studio报表中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！