<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Filter not filter text columns in ArcGIS Dashboards Questions</title>
    <link>https://community.esri.com/t5/arcgis-dashboards-questions/filter-not-filter-text-columns/m-p/1063584#M4618</link>
    <description>&lt;P&gt;Guys,&lt;/P&gt;&lt;P&gt;I'm facing a problem with dashboard filters.&lt;BR /&gt;&lt;BR /&gt;I've built an Arcade expression that returns me two columns of two different layers.&lt;BR /&gt;Some of them has equal names, I was thinking that filtering one column with other it will return just the match between them, but not, Dashboard returns me none.&lt;BR /&gt;&lt;BR /&gt;Do you have some advice?&lt;/P&gt;&lt;P&gt;the code:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;var fs = GroupBy(&lt;BR /&gt;FeatureSetByPortalItem(Portal('My portal'), 'my feature', 0, ["*"], false),&lt;BR /&gt;["Alvo"],&lt;BR /&gt;[&lt;BR /&gt;{name:"Contagem", expression: 'Alvo', statistic: "COUNT"}&lt;BR /&gt;]&lt;BR /&gt;);&lt;BR /&gt;var fs_geof = GroupBy(FeatureSetByPortalItem(Portal('my portal',"my feature, 14, ["*"], false),&lt;BR /&gt;["Target_Geof"],&lt;BR /&gt;[&lt;BR /&gt;{name:"Alvo", expression: 'Target_Geof', statistic: "COUNT"},&lt;BR /&gt;]&lt;BR /&gt;);&lt;BR /&gt;var combinedDict = {&lt;BR /&gt;fields: [&lt;BR /&gt;{ name: "Alvo_ET", type: "esriFieldTypeString" },&lt;BR /&gt;{ name: "Alvo_Geof", type: "esriFieldTypeString" },&lt;BR /&gt;{ name: "count_total", type: "esriFieldTypeInteger" },&lt;BR /&gt;],&lt;BR /&gt;geometryType: "",&lt;BR /&gt;features: [],&lt;BR /&gt;};&lt;BR /&gt;// Loop through each of the three FeatureSets and store attributes into a combined dictionary.&lt;BR /&gt;var i = 0;&lt;BR /&gt;for (var m in fs) {&lt;BR /&gt;combinedDict.features[i] = {&lt;BR /&gt;attributes: {&lt;BR /&gt;Alvo_ET: m['Alvo'],&lt;BR /&gt;count_total: SUM(m['Contagem']),&lt;BR /&gt;},&lt;BR /&gt;};&lt;BR /&gt;i++;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;for (var p in fs_geof) {&lt;BR /&gt;combinedDict.features[i] = {&lt;BR /&gt;attributes: {&lt;BR /&gt;Alvo_Geof: p['Target_Geof'],&lt;BR /&gt;count_total: SUM(p["Alvo"]),&lt;BR /&gt;},&lt;BR /&gt;};&lt;BR /&gt;i++;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;var geral = FeatureSet(Text(combinedDict));&lt;/P&gt;&lt;P&gt;var filtro = Filter(geral, 'Alvo_ET');&lt;BR /&gt;var filtro2 = Filter(geral, 'Alvo_Geof = filtro');&lt;/P&gt;&lt;P&gt;return filtro2&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the result of my filter:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunoGomesdeSouza_0-1622556195569.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/14698i66CBE206598D596E/image-size/medium?v=v2&amp;amp;px=400" role="button" title="BrunoGomesdeSouza_0-1622556195569.png" alt="BrunoGomesdeSouza_0-1622556195569.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 01 Jun 2021 14:03:40 GMT</pubDate>
    <dc:creator>BrunoGomesdeSouza</dc:creator>
    <dc:date>2021-06-01T14:03:40Z</dc:date>
    <item>
      <title>Filter not filter text columns</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/filter-not-filter-text-columns/m-p/1063584#M4618</link>
      <description>&lt;P&gt;Guys,&lt;/P&gt;&lt;P&gt;I'm facing a problem with dashboard filters.&lt;BR /&gt;&lt;BR /&gt;I've built an Arcade expression that returns me two columns of two different layers.&lt;BR /&gt;Some of them has equal names, I was thinking that filtering one column with other it will return just the match between them, but not, Dashboard returns me none.&lt;BR /&gt;&lt;BR /&gt;Do you have some advice?&lt;/P&gt;&lt;P&gt;the code:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;var fs = GroupBy(&lt;BR /&gt;FeatureSetByPortalItem(Portal('My portal'), 'my feature', 0, ["*"], false),&lt;BR /&gt;["Alvo"],&lt;BR /&gt;[&lt;BR /&gt;{name:"Contagem", expression: 'Alvo', statistic: "COUNT"}&lt;BR /&gt;]&lt;BR /&gt;);&lt;BR /&gt;var fs_geof = GroupBy(FeatureSetByPortalItem(Portal('my portal',"my feature, 14, ["*"], false),&lt;BR /&gt;["Target_Geof"],&lt;BR /&gt;[&lt;BR /&gt;{name:"Alvo", expression: 'Target_Geof', statistic: "COUNT"},&lt;BR /&gt;]&lt;BR /&gt;);&lt;BR /&gt;var combinedDict = {&lt;BR /&gt;fields: [&lt;BR /&gt;{ name: "Alvo_ET", type: "esriFieldTypeString" },&lt;BR /&gt;{ name: "Alvo_Geof", type: "esriFieldTypeString" },&lt;BR /&gt;{ name: "count_total", type: "esriFieldTypeInteger" },&lt;BR /&gt;],&lt;BR /&gt;geometryType: "",&lt;BR /&gt;features: [],&lt;BR /&gt;};&lt;BR /&gt;// Loop through each of the three FeatureSets and store attributes into a combined dictionary.&lt;BR /&gt;var i = 0;&lt;BR /&gt;for (var m in fs) {&lt;BR /&gt;combinedDict.features[i] = {&lt;BR /&gt;attributes: {&lt;BR /&gt;Alvo_ET: m['Alvo'],&lt;BR /&gt;count_total: SUM(m['Contagem']),&lt;BR /&gt;},&lt;BR /&gt;};&lt;BR /&gt;i++;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;for (var p in fs_geof) {&lt;BR /&gt;combinedDict.features[i] = {&lt;BR /&gt;attributes: {&lt;BR /&gt;Alvo_Geof: p['Target_Geof'],&lt;BR /&gt;count_total: SUM(p["Alvo"]),&lt;BR /&gt;},&lt;BR /&gt;};&lt;BR /&gt;i++;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;var geral = FeatureSet(Text(combinedDict));&lt;/P&gt;&lt;P&gt;var filtro = Filter(geral, 'Alvo_ET');&lt;BR /&gt;var filtro2 = Filter(geral, 'Alvo_Geof = filtro');&lt;/P&gt;&lt;P&gt;return filtro2&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the result of my filter:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunoGomesdeSouza_0-1622556195569.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/14698i66CBE206598D596E/image-size/medium?v=v2&amp;amp;px=400" role="button" title="BrunoGomesdeSouza_0-1622556195569.png" alt="BrunoGomesdeSouza_0-1622556195569.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 01 Jun 2021 14:03:40 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/filter-not-filter-text-columns/m-p/1063584#M4618</guid>
      <dc:creator>BrunoGomesdeSouza</dc:creator>
      <dc:date>2021-06-01T14:03:40Z</dc:date>
    </item>
  </channel>
</rss>

