Outage Dashboard - Time range outages

AndersJensen

I am trying to configure an Outage Dashboard for a Utility company. I have a set of data of customer outages (one outage is basically for now a customer id, location information, an outage start and an outage end datetime field.

I would like a dashboard that shows a map of the outages that are open right now (no end datetime), and also a graph that shows the count of affected customers over time. 

Is this possible? 

#Outage #time management

XanderBakker

Yes you can. There are a few things to keep in mind. As far as I can tell, you cannot filter the layer for empty values in the field inside Dashboard. You can however, duplicate the layer in the web map and filter the layer there for empty values (sorry for the Spanish interface):

In your dashboard you can configure to show the count of that layer.

In addition you can also create a corresponding symbology that symbolizes the time an outage is open by applying symbology based on an Arcade expression (see: Use Arcade Expressions to Map Your Ideas | ArcGIS Blog ). in this case I used this expression:

<SPAN class="keyword token">var</SPAN> start_date <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>FechaHora<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> end_date <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>EndDate<SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Not Set"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">IsEmpty</SPAN><SPAN class="punctuation token">(</SPAN>end_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// No end date set, so outage is open</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// calculate time open (use appropiate unit, for instance minutes)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> current_date <SPAN class="operator token">=</SPAN> <SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> days_open <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>current_date<SPAN class="punctuation token">,</SPAN> start_date<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>days_open <SPAN class="operator token"><</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Less than a day"</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>days_open <SPAN class="operator token"><</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Less than a week"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>days_open <SPAN class="operator token"><</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Less than a month"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"More than a month"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// outage is closed, assign a single value</SPAN>
&nbsp;&nbsp;&nbsp; result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Closed"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It will create different classes of time that an outage is open and you can apply an appropriate symbology to it in order to visualize those outages that have been open for a longer time, will be visualized with a more pronounced (size, color) symbol.