"X Days Until Y" card
I'm looking for a way to add a card to an Operations Dashboard, Sites, or Hub site that will dynamically count down the days until an event. It looks like it should be possible if I use an Indicator in Operations Dashboard because of the example they have on this page.
I can't figure out how to put in a formula that will dynamically subtract today's date from the date of the event and put that count of days in the Indicator.
That helps -- I wasn't able to make sense of the documentation, but you've clarified how it is supposed to work.
I wonder my problem is that Portal 10.7.1 doesn't support date fields in Indicators? When I click the drop-down to choose a field for my reference value, it tells me that I have "No matching options" in the feature:
I don't have any numeric fields in this feature class -- just text and dates -- so I'm guessing that it's looking for a short, long, or double field.
EDITED TO ADD: Looks like dates aren't supported, if this post on Geonet is correct. If that's the case, I wonder how they did the card in the example in my screenshot? There has to be math involved somewhere, or the ticker wouldn't be dynamic.
Hi @AmyRoust,
As you noted in your post, this is possible by using an Arcade expression in an Indicator widget on a dashboard. In order to do this, you need to modify an existing Indicator widget and use an expression similar to the example below:
var startDate = Today();
var endDate = Date(2021,9,28);
var daysLeft = DateDiff(endDate, startDate,'day');
return {
middleText: daysLeft,
middleTextMaxSize: 'large',
bottomText: 'Days left...!',
}
This will calculate the difference between today's date and the end date that you specify in days and shows the results on your Indicator. These dates can be defined static dates or from the attributes of a feature layer or table used in your dashboard. Notice that when using the Date function, months are defined by 0-11 instead of 1-12 (e.g. 9 is October).
Best,
MJ
