Data expression not returning same feature for different elements in Dashboard

RickeyFight

So I am using a Data Expression for each of these elements within the dashboard.

The expression is:

 

 

var portal = Portal("");
var fs = FeatureSetByPortalItem(
  portal,
  "",
  1,
  [
    "Date_",
    "W_F_MGD",
    "E_F_MGD",
    "TOTAL_W_E_MGD",
    "TID_FLOW_MGD",
    "REEDER_Percent_FULL",
    "TAP_FLOW_MGD",
    "PLANT_PRODUCTION_MGD"
  ],
  false
);

// Find the most recent date from the date field to filter the FeatureSet for the latest record
var maxDate = Text(Date(Max(fs,'Date_')),"YYYY-MM-DD");
return Filter(fs, "Date_ = @maxDate");

 

 

 

I do not know why the Gage has the latest information but the Indicators and pie chart are pulling from a few days ago. 

Here is the result when I test the Expression:

 

 

jcarlson

Just to check, expand the date format to include the time. Since your timestamp is midnight, odds are it's adjusting the value for your time zone. If you were in UTC+6, then a midnight timestamp would show up as the previous date at 18:00.

You could use ToUTC to return the timestamp in the UTC value to avoid this.

 

Text(Date(ToUTC(Max(fs,'Date_'))),"YYYY-MM-DD")