
Dear community,
I have a funnel chart running of a view which I have added a numerical sorting field - this view sorts by this field by default.
The funnel chart however isn't sorting as I would expect. It doesn't appear to be taking into account the sorting of the view. I exported the chart and there is no apparent ordering logic in the XML script.
Please can you help?
Best regards,
Drew
*This post is locked for comments
I have the same question (0)Export your chart and edit the XML contents.
<fetch mapping="logical" aggregate="true">
<entity name="new_customentity">
<attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="statuscode" />
<attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="new_value" aggregate="sum" />
<attribute alias="_CRMAutoGen_aggregate_column_Num_1" name="new_customid" aggregate="count" />
<order alias="_CRMAutoGen_groupby_column_Num_0" descending="false" />
</entity>
</fetch>
To sort, add the order by as '<order alias...'