topic Dashboard - Today Date Unless data is blank in ArcGIS Dashboards Questions

Dashboard - Today Date Unless data is blank

RickeyFight — Wed, 20 Oct 2021 19:38:29 GMT

I am looking for help with a script to display only todays data unless todays data has not been displayed yet. If that is the case display yesterday data.

I am thinking it would be if today > 0 display today data if not display today-1

Re: Dashboard - Today Date Unless data is blank

jcarlson — Wed, 20 Oct 2021 19:47:33 GMT

Are you doing this in a data expression? Or working with an existing layer? The former is possible, but the latter probably isn't.

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Wed, 20 Oct 2021 20:53:20 GMT

@jcarlson

I am trying to do this in a data expression.

Re: Dashboard - Today Date Unless data is blank

jcarlson — Wed, 20 Oct 2021 21:33:30 GMT

Ah, well that's not too bad. It's very similar to the example shown here.

// Get layer var portal = Portal('org-url') var fs = FeatureSetByPortalItem( portal, 'itemID', 0, // or whatever the layer index [ 'your', 'fields', 'some_date_field' ], false ); // Get most recent date, convert to SQL-compatible string var maxDate = Text(Date(fs, 'some_date_field'), 'YYYY-MM-DD'); // Return records for max date return Filter(fs, "some_date_field = @maxDate")

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Wed, 20 Oct 2021 22:03:06 GMT

Thanks for the link.

One issue I have is that I have pre added dates for the year so I cannot pick the max date but maybe I can get it to work with todays date.

Re: Dashboard - Today Date Unless data is blank

jcarlson — Fri, 22 Oct 2021 15:00:53 GMT

// Get layer var portal = Portal('org-url') var fs = FeatureSetByPortalItem( portal, 'itemID', 0, // or whatever the layer index [ 'your', 'fields', 'some_date_field', 'some_value_field' ], false ); // Filter records with empty values (future dates) var filt = Filter(fs, "some_value_field IS NOT NULL AND some_value_field <> ''") // Sort filtered records for most recent first var sorted = OrderBy(filt, "some_date_field DESC") // Return top record return First(sorted)

@RickeyFightyou're right, that was it. Though the AND was probably part of it, too. I've edited this code so that the OrderBy references filt instead of fs.

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Thu, 21 Oct 2021 14:52:31 GMT

@jcarlson

// Filter records with empty values (future dates) var filt = Filter(fs, "REEDER_Percent_FULL IS NOT NULL REEDER_Percent_FULL <> ''") // Sort filtered records for most recent first var sorted = OrderBy(fs, "Date_ DESC") // Return top record return First(sorted)

This is what I have so far.

I am getting this error:

Execution Error:Expected "*", "+", "-", "/", "AND", "OR", [ \t\n\r], or end of input but "R" found.

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Thu, 21 Oct 2021 20:28:29 GMT

@jcarlson

I am now getting data to display but it is still showing the Null data. How does the var filt apply to the sorted layer?

Re: Dashboard - Today Date Unless data is blank

jcarlson — Fri, 22 Oct 2021 13:58:08 GMT

You need an "AND" before the second statement in your SQL.

"...IS NOT NULL AND REEDER_Percent_FULL..."

EDIT: Change that to AND.

Re: Dashboard - Today Date Unless data is blank

jcarlson — Fri, 22 Oct 2021 13:59:14 GMT

I edited my reply below, but I think we want an "AND" in the SQL statement, not "OR". Something that has a value of '', that is, an empty string, will still satisfy the "IS NOT NULL" condition, allowing it through. My mistake!

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Fri, 22 Oct 2021 14:56:01 GMT

@jcarlson

Thank you for your continued help on this.

I am not sure the "AND" is the issue. I added the change and this is what I get. I think the problem is that the "filt" var is defined but then not put into the result. I would think that the "sorted" var would need to reference the "filt" var at some point.

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Fri, 22 Oct 2021 15:35:31 GMT

@jcarlson
I get this now

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Fri, 22 Oct 2021 15:40:52 GMT

@jcarlson

var portal = Portal("PortalID"); var fs = FeatureSetByPortalItem( portal, "Numbers", 1, [ "Date_", "W_F_MGD", "E_F_MGD", "TOTAL_W_E_MGD", "TID_FLOW_MGD", "REEDER_Percent_FULL", "TAP_FLOW_MGD", "PLANT_PRODUCTION_MGD", "last_edited_date" ], false ); // Filter records with empty values (future dates) var filt = Filter(fs, "REEDER_Percent_FULL IS NOT NULL OR REEDER_Percent_FULL <> ''") // Sort filtered records for most recent first var sorted = OrderBy(filt, "Date_ DESC") // Return top record return First(sorted)

Here is my full code minus the portal login info

Re: Dashboard - Today Date Unless data is blank

jcarlson — Fri, 22 Oct 2021 15:42:54 GMT

Hmmm. Try throwing in some Console commands to output some intermediate things, try to see where it's failing.

After ln 18: Console(fs)
After ln 23: Console(filt)
After ln 26: Console(sorted)

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Fri, 22 Oct 2021 16:03:45 GMT

@jcarlson
I think you were almost right.
This is what I got to work

// Filter records with empty values (future dates) var filt = Filter(fs, "REEDER_Percent_FULL IS NOT NULL") // Sort filtered records for most recent first var sorted = OrderBy(filt, "Date_ DESC") // Return top record return First(sorted)

If you modify your post I will mark yours as correct

Re: Dashboard - Today Date Unless data is blank

jcarlson — Fri, 22 Oct 2021 16:06:07 GMT

Always tricky to debug to without having access to the data. Glad you got it working!

Re: Dashboard - Today Date Unless data is blank

RickeyFight — Fri, 22 Oct 2021 16:08:04 GMT

@jcarlson

I got it to work once. When I test I get the results I want but the script picker now gives me this error