<?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 SAS Visual Analytics - create parameter by aggregated measure in SAS Visual Analytics</title>
    <link>https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-create-parameter-by-aggregated-measure/m-p/899895#M17589</link>
    <description>&lt;P&gt;&lt;STRONG&gt;the problem:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;If the user selects only one element as a filter, a calculation must be made on the table, otherwise if he selects no element or more than one, another calculated field is created.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I tried to solve:&lt;/STRONG&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 1. I created a field that calculates the number of selected elements.&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 2. I created an if else:&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; IF ( 'count_days'n = 1 )&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; RETURN 1&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ELSE 0&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I would like to create a parameter on the value of this calculated field to use on my main table&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 25 Oct 2023 08:01:49 GMT</pubDate>
    <dc:creator>Federicoconti01</dc:creator>
    <dc:date>2023-10-25T08:01:49Z</dc:date>
    <item>
      <title>SAS Visual Analytics - create parameter by aggregated measure</title>
      <link>https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-create-parameter-by-aggregated-measure/m-p/899895#M17589</link>
      <description>&lt;P&gt;&lt;STRONG&gt;the problem:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;If the user selects only one element as a filter, a calculation must be made on the table, otherwise if he selects no element or more than one, another calculated field is created.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I tried to solve:&lt;/STRONG&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 1. I created a field that calculates the number of selected elements.&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 2. I created an if else:&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; IF ( 'count_days'n = 1 )&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; RETURN 1&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ELSE 0&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I would like to create a parameter on the value of this calculated field to use on my main table&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 25 Oct 2023 08:01:49 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-create-parameter-by-aggregated-measure/m-p/899895#M17589</guid>
      <dc:creator>Federicoconti01</dc:creator>
      <dc:date>2023-10-25T08:01:49Z</dc:date>
    </item>
  </channel>
</rss>

