locked
Editing Chart XML - Filtering out a single option set item RRS feed

  • Question

  • Hello,

    I have a scenario where I would like to exclude or hide a single item from and option set so it does not display in a chart.

    The exact item from the option set "leadsourcecode".

    I have been reading Microsoft's "Build queries with FetchXML" article and have tried to apply a filter to a charts XML but its not working.

    Here is what I have come up with so far:

    <fetch mapping="logical" aggregate="true">
              <entity name="lead">
                <attribute groupby="true" alias="groupby_column" name="leadsourcecode" />
    			<filter type='and'>
    			            <condition attribute='leadsourcecode' operator='ne' value='100,000,006' /> 
    			</filter>
                <attribute alias="aggregate_column" name="fullname" aggregate="count" />
              </entity>
    </fetch>

    I appreciate any feedback that anyone might have to help point me in the right direction.

    Thursday, November 5, 2015 3:00 AM

Answers

  • I fixed it!

    Turned out I just had to remove the commas.

    • Marked as answer by Matthew Eva Thursday, November 5, 2015 3:25 AM
    Thursday, November 5, 2015 3:25 AM