Applying filter on aggregated content

Supriya Sukhtankar on September 17, 2012

Hi,

We have a data feed which has columns like Approver Name, Owner Name, Item Count, Date, Pending Days (Approver Name, Owner Name, Date combination is unique).

We need to obtain the total item count for each approver. We tried using the aggregate function for Sum (Item Count) and it worked for us.

But, while rendering the mash app, we need to apply a filter based on the owner of the item and Date. How is it possible to perform the filtering on already aggregated data?

Notify Moderator

2 Replies

SS

Supriya Sukhtankar on September 17, 2012

Also, if the data feed is returning lots of data from the server, is it possible to restrict the display in table to only say 10 rows? How can that be acheived?

Like

Sign in
or register to reply.

Notify Moderator
MN

Murugavel Natarajan on September 20, 2012

Reply to Question 1

You can use 'User Input' section from the data feed for this scenario.

First you have to filter the data based on owner and date and then aggregate

Please refer to the attachment

Replae provider('User input-Text' widget) by owner(in your case) .

Then aggregate.

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.