Counting data in table view rows

[Former Member]

Hi,

I have a BAPI that returns a set of data. Each row has a process_id and an activity_status.

I have 4 types of activity_status and I would like to count the number of processes for each type of status and return the result in a pie chart.

How can I manage to do that ?

Thanks a lot for your help.

Thibault

Edited by: Thibault Schalck on Oct 27, 2009 3:08 PM

[Former Member · Accepted solution]

Hi,

You can:

1) use the "Filter" operator to filter the relevant "Activity status" (therefore, you'll have 4 filters, one for each status),

2) connect each of those filters to a "Sigma" Operator, and set the drop-down near the "activity_status" field to "COUNT".