Data Refresh

[#1]

Hi guys,

I have multiple data files, which gets updated any time, my dashboard is scheduled to refresh on weekly basis, So issue is Last refresh date shows Dashboard refresh date, every week dashboard refresh date gets updated irrespective of data got updated or not. Users gets confused with that, they assume data got updated. Is there any way to show data refresh date in dashboard??

[NareshGuntur]

You can use ReloadTime().

It will give you the last reloaded time of the dashboard.

Cheers,

Naresh

[manojkulkarni]

In this case pick your Transaction or Fact QVD create time or get the max transaction time from your available data to show Last Update Date.

[#4]

ReloadTime() shows dashboard refresh time, i want to show data refresh time

[PradeepReddy]

at the end of  your script execution, create a variable to hold the maximum date of the Date Field(on which basis you are confirming the source data is updated or not).

use that variable to display the latest updated data.

[mithilesh17]

Hi,

Use two date fields on front end

One date is maximum of Transaction Date(or any other date field in your context), display the same as Till the date and display second date as ReloadTime() which is the date when your Dashboard is reloaded, name it last refreshed. No confusion whatsoever!

HTH

Regards,

[NareshGuntur · Accepted solution]

Try something like this

Test1:

LOAD FileTime() as Time, FileName() as Name

From E:\NewFolder\Data\*.xlsx;

Test2:

LOAD Max(Time) as NewTime Resident Test1;

So, your NewTime field will have the last updated data file. If you show this in the dashboard using a TextObject, users will understand if it is of last week or the latest week.

Hope this helps.

Cheers,

Naresh

[#8]

I believe you may have timestamp on your application. If yes, create set analysis expression on UI:

'Last Refresh Time: ' & Max({1}TimestampFieldName)

If you don't have timestamp field in your application or rollover the data to day or week level. write sql statements to get the latest timestamp from your fact table.

[miguelbraga]

Hey there,

Check my solution in the attached file

Regards,

MB

[HirisH_V7]

Hi,

Like this

The filetime() function does this nicely.

date(filetime('\\path\tofile\dailydata.csv'),'DD/MM/YYYY hh:mm') as DateModified

Hope this Helps,

PFA,

Hirish