https://community.esri.com/t5/arcgis-dashboards-questions/data-suppression-in-serial-charts/m-p/1406643#M9378 <P>Does anyone have any advice on how to best represent suppressed data in serial charts?&nbsp; I am building a dashboard app in the AGOL environment and while I have had success with data suppression using elements/widgets that support Arcade, I haven't been able to find a good solution for serial charts.</P><P>I've imported the data as numeric with suppressed values as -1, as I am not permitted to upload these values at all-- even if they're hidden.&nbsp; I was hoping serial charts would allow the creation of a custom label/alias that would read "&lt;5" for these values, but I haven't been able to find that option if it exists.&nbsp; I'm also currently using a line graph because this is trend data-- but the best I've been able to do is make zero the minimum y-axis value so that the line doesn't dip below the axis.&nbsp; This works, but it leads to discontinuous lines as shown below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ReedSherrill_0-1712347779040.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/100264iA2AFB6AE29B75DF5/image-size/medium?v=v2&amp;px=400" role="button" title="ReedSherrill_0-1712347779040.png" alt="ReedSherrill_0-1712347779040.png" /></span></P><P>&nbsp;</P><P>I'm ok with converting this to a bar chart to avoid the disjointed look, but I still need a label solution to indicate that 'empty' parts of the chart are suppressed values, as opposed to zeroes (which will be labeled as such).</P><P>Does anyone have any recommendations for this?&nbsp; I have already taken advantage of the elements that do support Arcade, but charts are necessary for my use case.&nbsp; I have already tried building this in experience builder, but ran into other problems that couldn't make it through my office's internal review process.&nbsp; This is my last stop before building it out in Tableau.</P> Mon, 22 Apr 2024 18:47:23 GMT ReedSherrill 2024-04-22T18:47:23Z https://community.esri.com/t5/arcgis-dashboards-questions/data-suppression-in-serial-charts/m-p/1406643#M9378 <P>Does anyone have any advice on how to best represent suppressed data in serial charts?&nbsp; I am building a dashboard app in the AGOL environment and while I have had success with data suppression using elements/widgets that support Arcade, I haven't been able to find a good solution for serial charts.</P><P>I've imported the data as numeric with suppressed values as -1, as I am not permitted to upload these values at all-- even if they're hidden.&nbsp; I was hoping serial charts would allow the creation of a custom label/alias that would read "&lt;5" for these values, but I haven't been able to find that option if it exists.&nbsp; I'm also currently using a line graph because this is trend data-- but the best I've been able to do is make zero the minimum y-axis value so that the line doesn't dip below the axis.&nbsp; This works, but it leads to discontinuous lines as shown below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ReedSherrill_0-1712347779040.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/100264iA2AFB6AE29B75DF5/image-size/medium?v=v2&amp;px=400" role="button" title="ReedSherrill_0-1712347779040.png" alt="ReedSherrill_0-1712347779040.png" /></span></P><P>&nbsp;</P><P>I'm ok with converting this to a bar chart to avoid the disjointed look, but I still need a label solution to indicate that 'empty' parts of the chart are suppressed values, as opposed to zeroes (which will be labeled as such).</P><P>Does anyone have any recommendations for this?&nbsp; I have already taken advantage of the elements that do support Arcade, but charts are necessary for my use case.&nbsp; I have already tried building this in experience builder, but ran into other problems that couldn't make it through my office's internal review process.&nbsp; This is my last stop before building it out in Tableau.</P> Mon, 22 Apr 2024 18:47:23 GMT https://community.esri.com/t5/arcgis-dashboards-questions/data-suppression-in-serial-charts/m-p/1406643#M9378 ReedSherrill 2024-04-22T18:47:23Z