Query regarding self service portlets

Kaushik Datta 5 months ago

Hi,

We have a few queries regarding the self service portlets:

1. We are in 10.0.4 version. We see that only SUM function is available out of the box in the Self service portlets. We want to have the COUNT function to be available. For. e.g. how many change requests ssociated with each projects based on statuses. The current group function in SSP is doing the sum of request IDs. Is there a setting available to enable count?

2. Most of the graphical views in SSP expect one axis to have values and the other as attributes. Is it the expected behavior? We want to have attributes in both the axis. Can it be done using SSP?

Thanks,

Kaushik

0 Etienne Canaud 5 months ago

Hi Kaushik,

1) The workaround for getting "Count" instead of "Sum" is to add a new numeric column to your Self-Service portlet Datasource called "Item Count" that returns "1". This way, summing the "Item Count" column will actually count the number of rows.

2) How could you have a non-numeric value on Y axis for charts such as bar chart? What chart are you thinking of that could have text attributes on both axis exactly? Could you share an example?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

PPM User Discussions

Verified Answers

Query regarding self service portlets

Resources