https://community.esri.com/t5/arcgis-dashboards-questions/show-rows-in-columns-and-count-occurrences/m-p/1407136#M9383 <P>I am starting with Aracade in dashboard and I have a table with data in column 1 with the sectionals and another column with marital status, as shown below:</P><TABLE width="223"><TBODY><TR><TD width="133">Dirección Seccional</TD><TD width="90">Estado civil</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>CAUCA</TD><TD>UNION_LIBRE</TD></TR><TR><TD>MAGDALENA MEDIO</TD><TD>CASADO</TD></TR><TR><TD>CUNDINAMARCA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>SEPARADO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>NARIÑO</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>UNION_LIBRE</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SEPARADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR></TBODY></TABLE><P>I need to create a new data expression to display the sections by marital status as columns that count the amount for each marital status, and it should look like this:</P><TABLE width="577"><TBODY><TR><TD width="147">SECCIONAL</TD><TD width="70">CASADO</TD><TD width="89">SEPARADO</TD><TD width="75">SOLTERO</TD><TD width="101">UNION_LIBRE</TD><TD width="95">Total general</TD></TR><TR><TD>AMAZONAS</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD><TD>4</TD><TD>6</TD></TR><TR><TD>ANTIOQUIA</TD><TD>100</TD><TD>4</TD><TD>51</TD><TD>41</TD><TD>&nbsp;</TD></TR><TR><TD>ARAUCA</TD><TD>11</TD><TD>2</TD><TD>11</TD><TD>6</TD><TD>&nbsp;</TD></TR><TR><TD>ATLANTICO</TD><TD>54</TD><TD>7</TD><TD>29</TD><TD>23</TD><TD>&nbsp;</TD></TR><TR><TD>BOGOTA</TD><TD>215</TD><TD>40</TD><TD>147</TD><TD>82</TD><TD>&nbsp;</TD></TR><TR><TD>BOLIVAR</TD><TD>7</TD><TD>2</TD><TD>5</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>BOYACÁ</TD><TD>88</TD><TD>24</TD><TD>55</TD><TD>30</TD><TD>&nbsp;</TD></TR><TR><TD>CALDAS</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CALI</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CAQUETA</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CASANARE</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could someone help me with this need? Or has someone already done a similar development to guide me?</P><P>&nbsp;</P> Mon, 08 Apr 2024 14:42:45 GMT RodrigoAbadia 2024-04-08T14:42:45Z https://community.esri.com/t5/arcgis-dashboards-questions/show-rows-in-columns-and-count-occurrences/m-p/1407136#M9383 <P>I am starting with Aracade in dashboard and I have a table with data in column 1 with the sectionals and another column with marital status, as shown below:</P><TABLE width="223"><TBODY><TR><TD width="133">Dirección Seccional</TD><TD width="90">Estado civil</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>CAUCA</TD><TD>UNION_LIBRE</TD></TR><TR><TD>MAGDALENA MEDIO</TD><TD>CASADO</TD></TR><TR><TD>CUNDINAMARCA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>SEPARADO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>NARIÑO</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>UNION_LIBRE</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>SOLTERO</TD></TR><TR><TD>MEDELLIN</TD><TD>CASADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>SEPARADO</TD></TR><TR><TD>ANTIOQUIA</TD><TD>CASADO</TD></TR></TBODY></TABLE><P>I need to create a new data expression to display the sections by marital status as columns that count the amount for each marital status, and it should look like this:</P><TABLE width="577"><TBODY><TR><TD width="147">SECCIONAL</TD><TD width="70">CASADO</TD><TD width="89">SEPARADO</TD><TD width="75">SOLTERO</TD><TD width="101">UNION_LIBRE</TD><TD width="95">Total general</TD></TR><TR><TD>AMAZONAS</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD><TD>4</TD><TD>6</TD></TR><TR><TD>ANTIOQUIA</TD><TD>100</TD><TD>4</TD><TD>51</TD><TD>41</TD><TD>&nbsp;</TD></TR><TR><TD>ARAUCA</TD><TD>11</TD><TD>2</TD><TD>11</TD><TD>6</TD><TD>&nbsp;</TD></TR><TR><TD>ATLANTICO</TD><TD>54</TD><TD>7</TD><TD>29</TD><TD>23</TD><TD>&nbsp;</TD></TR><TR><TD>BOGOTA</TD><TD>215</TD><TD>40</TD><TD>147</TD><TD>82</TD><TD>&nbsp;</TD></TR><TR><TD>BOLIVAR</TD><TD>7</TD><TD>2</TD><TD>5</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>BOYACÁ</TD><TD>88</TD><TD>24</TD><TD>55</TD><TD>30</TD><TD>&nbsp;</TD></TR><TR><TD>CALDAS</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CALI</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CAQUETA</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CASANARE</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could someone help me with this need? Or has someone already done a similar development to guide me?</P><P>&nbsp;</P> Mon, 08 Apr 2024 14:42:45 GMT https://community.esri.com/t5/arcgis-dashboards-questions/show-rows-in-columns-and-count-occurrences/m-p/1407136#M9383 RodrigoAbadia 2024-04-08T14:42:45Z https://community.esri.com/t5/arcgis-dashboards-questions/show-rows-in-columns-and-count-occurrences/m-p/1407575#M9389 <P>To complete the above request, I have the following script, but I cannot get the counts.<BR />I ask someone can help me, thank you.</P><DIV>&nbsp;</DIV><P>&nbsp;</P><LI-CODE lang="javascript">var fs = FeatureSetByPortalItem(Portal('https://www.arcgis.com'),'xxxx',0,['*'],false); var value_counts = { "AMAZONAS": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "ANTIOQUIA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "ATLÁNTICO": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "ARAUCA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "BOGOTÁ D.C.": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "BOLÍVAR": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "BOYACÁ": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CALDAS": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CAQUETA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CASANARE": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CAUCA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CESAR": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CUNDINAMARCA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CHOCÓ": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "CÓRDOBA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "HUILA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "GUAJIRA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "MAGDALENA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "META": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "NARIÑO": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "NORTE DE SANTANDER": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "PUTUMAYO": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "QUINDÍO": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "RISARALDA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "SAN ANDRÉS": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "SANTANDER": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "SUCRE": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "TOLIMA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "VALLE DEL CAUCA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "VAUPÉS": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0}, "VICHADA": {'CASADO': 0,'SEPARADO' : 0,'SOLTERO' : 0,'UNION_LIBRE' : 0} }; for (var i in fs){ var split_array = Split(i['est_civil'], ','); var choiceArray = []; for (var index in split_array) push(choiceArray, split_array[index]) for(var i in choiceArray){ var value = choiceArray[i] if(IsEmpty(value)) {continue} if(i == [0]) value_counts[value]['CASADO'] = value_counts[value]['CASADO'] + 1 if(i == [1]) value_counts[value]['SEPARADO'] = value_counts[value]['SEPARADO'] + 1 if(i == [2]) value_counts[value]['SOLTERO'] = value_counts[value]['SOLTERO'] + 1 if(i == [3]) value_counts[value]['UNION_LIBRE'] = value_counts[value]['UNION_LIBRE'] + 1 } } var Dict = { 'fields': [ { 'name': 'SECCIONAL', 'type': 'esriFieldTypeString' }, //{ 'name': 'Average','type': 'esriFieldTypeDouble'}, { 'name': 'CASADO','type': 'esriFieldTypeInteger'}, { 'name': 'SEPARADO','type': 'esriFieldTypeInteger'}, { 'name': 'SOLTERO','type': 'esriFieldTypeInteger'}, { 'name': 'UNIÓN LIBRE','type': 'esriFieldTypeInteger'}], 'geometryType': '', 'features': [] }; var index = 0 for (var value in value_counts){ Dict.features[index] = { 'attributes': { 'SECCIONAL': value, 'CASADO': value_counts[value]['CASADO'], 'SEPARADO': value_counts[value]['SEPARADO'], 'SOLTERO': value_counts[value]['SOLTERO'], 'UNIÓN LIBRE': value_counts[value]['UNION_LIBRE'] // 'Average': value_counts[value]['Average'] } } index++; } return FeatureSet(Dict);</LI-CODE><P>&nbsp;</P><DIV>&nbsp;</DIV><DIV><SPAN>I get the following output:</SPAN></DIV><DIV>SECCIONAL CASADO SEPARADO SOLTERO UNIÓN LIBRE FID <TABLE><TBODY><TR><TD><SPAN class="">"AMAZONAS"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD></TR><TR><TD><SPAN class="">"ANTIOQUIA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">1</SPAN></TD></TR><TR><TD><SPAN class="">"ARAUCA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">2</SPAN></TD></TR><TR><TD><SPAN class="">"ATLÁNTICO"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">3</SPAN></TD></TR><TR><TD><SPAN class="">"BOGOTÁ D.C."</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">4</SPAN></TD></TR><TR><TD><SPAN class="">"BOLÍVAR"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">5</SPAN></TD></TR><TR><TD><SPAN class="">"BOYACÁ"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">6</SPAN></TD></TR><TR><TD><SPAN class="">"CALDAS"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">7</SPAN></TD></TR><TR><TD><SPAN class="">"CAQUETA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">8</SPAN></TD></TR><TR><TD><SPAN class="">"CASANARE"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">9</SPAN></TD></TR><TR><TD><SPAN class="">"CAUCA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">10</SPAN></TD></TR><TR><TD><SPAN class="">"CESAR"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">11</SPAN></TD></TR><TR><TD><SPAN class="">"CHOCÓ"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">12</SPAN></TD></TR><TR><TD><SPAN class="">"CUNDINAMARCA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">13</SPAN></TD></TR><TR><TD><SPAN class="">"CÓRDOBA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">14</SPAN></TD></TR><TR><TD><SPAN class="">"GUAJIRA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">15</SPAN></TD></TR><TR><TD><SPAN class="">"HUILA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">16</SPAN></TD></TR><TR><TD><SPAN class="">"MAGDALENA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">17</SPAN></TD></TR><TR><TD><SPAN class="">"META"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">18</SPAN></TD></TR><TR><TD><SPAN class="">"NARIÑO"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">19</SPAN></TD></TR><TR><TD><SPAN class="">"NORTE DE SANTANDER"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">20</SPAN></TD></TR><TR><TD><SPAN class="">"PUTUMAYO"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">21</SPAN></TD></TR><TR><TD><SPAN class="">"QUINDÍO"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">22</SPAN></TD></TR><TR><TD><SPAN class="">"RISARALDA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">23</SPAN></TD></TR><TR><TD><SPAN class="">"SAN ANDRÉS"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">24</SPAN></TD></TR><TR><TD><SPAN class="">"SANTANDER"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">25</SPAN></TD></TR><TR><TD><SPAN class="">"SUCRE"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">26</SPAN></TD></TR><TR><TD><SPAN class="">"TOLIMA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">27</SPAN></TD></TR><TR><TD><SPAN class="">"VALLE DEL CAUCA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">28</SPAN></TD></TR><TR><TD><SPAN class="">"VAUPÉS"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">29</SPAN></TD></TR><TR><TD><SPAN class="">"VICHADA"</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">0</SPAN></TD><TD><SPAN class="">30</SPAN></TD></TR></TBODY></TABLE></DIV> Tue, 09 Apr 2024 19:00:03 GMT https://community.esri.com/t5/arcgis-dashboards-questions/show-rows-in-columns-and-count-occurrences/m-p/1407575#M9389 RodrigoAbadia 2024-04-09T19:00:03Z