Issues with TOPN Ranking for Combined Analysis
We are trying to create a report that shows the top 10 tasks created based on a single specific value entered into 1 of either 2 pick-lists on our task page layout which contain the exact same values.
We are combining these values using a UNION which has one criteri (activity history) a with pick-list 1 and # of closed activities and another criteria (activity history) which has pick-list 2 and # of closed activities.
At the Result Columns level, we have added an additional field or column with formula TOPN(SUM(SAW_1 BY SAW_0),20). We are then using this in a pivot table as a measure and creating a bar graph which lists the top 10 values.
We are combining these values using a UNION which has one criteri (activity history) a with pick-list 1 and # of closed activities and another criteria (activity history) which has pick-list 2 and # of closed activities.
At the Result Columns level, we have added an additional field or column with formula TOPN(SUM(SAW_1 BY SAW_0),20). We are then using this in a pivot table as a measure and creating a bar graph which lists the top 10 values.
0