Questions tagged [aggregation]
A set of content, features or data composed of many distinct parts or compiled from different sources.
42 questions
0
votes
0
answers
9
views
Display group aggregate and value in a column (with multiple Aggregated columns)
This is further to the Question and Answer in the below Post.
Display group aggregate and value in a column
How to Display if More than one column is aggregated. I have Invoice Value, Paid Value and ...
1
vote
1
answer
81
views
Dynamic list from site in hub
I have a main communication site acting as hub : Projects
I have several teams sites in this hub : Project A, Project B, Project C,...
in the main site Projects, I have a list that shows different ...
1
vote
1
answer
250
views
Newsfeed aggregation - extend time range
We got SharePoint 2016 on premise with May 2018 patch level. Our Newsfeed aggregation on the personal sites today is showing followed content of the last 7 days if you click "show more" on the bottom ...
- 1,107
1
vote
0
answers
498
views
CSOM (HighTrust) SP2013 Group by aggregate giving duplicates
Hi I've been reading about group by in SharePoint 2013 CSOM from this article here.
https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint
I've recently upgraded to 2013 and though ...
- 197
1
vote
1
answer
112
views
Compile data from multiple sources into a SharePoint List
I have data stored in a local network database (SQL Express, connected to our MRP system), Excel files on a local file server, and on Teamwork.com project management site. I would like to combine data ...
0
votes
1
answer
123
views
List aggregation formatting problem
I'm a bit of a SharePoint beginner, so please forgive me if this is a very basic question.
I have a parent site with a number of identical team sites below it. The requirement is that each team site ...
1
vote
1
answer
73
views
Roll-up data from a restricted subsite to parent site
One of my Site Owners has requested a feature to roll-up data from a restricted list.
The list is located in a restricted subsite. They want a short summary to roll-up to the parent site.
They don´t ...
- 11
1
vote
2
answers
1k
views
Roll up large amount of data from multiple lists
I have a site with several hundred of lists and over 100,000 items in total. I need a content roll up of the data to track the amount of items created per month/year.
I already took a look into:
...
- 443
1
vote
1
answer
114
views
Aggregating 25 lists into one main list
I've been asked to create 25 lists and sub-sites for each department in my organization and then roll all those 25 lists into 1 master list.
I'm currently using SharePoint 2010 Standard. I don't ...
- 1,488
2
votes
2
answers
199
views
Aggregating User's Tasks in SharePoint 2013
I have been scouring the internet for that past several weeks trying to come up with a solution, but I am lost.
I need a web part that can do two things:
Display all incomplete tasks for a specific ...
- 43
1
vote
1
answer
196
views
SPSiteDataQuery for Task List not working
I am creating a visual web part for aggregating all task in all webs of a site collection
I am using SPSiteDataQuery to get all tasks but it does not work for Task list
i.e.
Task List
query....
- 1,382
2
votes
2
answers
462
views
Modify Aggregation Panel view
how can I modify aggregation panel items? I need to hide Title of current calendar (see picture below).
I've got Sharepoint Online 2013. I try it in Sharepoint Designer. But I don't want to hide all ...
- 179
1
vote
2
answers
317
views
Best practices for creating views or separate lists?
Is there a best practice that can be said for whether to add a tag and have users filter on it or just create a separate list?
We have many groups in our SharePoint application that all have many ...
- 559
2
votes
1
answer
601
views
WorkManagement API TypeError: this.get_context is not a function
I have one requirement to show the aggregated task list as a webpart in any page of SP 2013 on premise, where user will see the assigned task list directly without going onto my site. After some ...
- 2,307
0
votes
1
answer
674
views
Why is my list total showing as "Count= undefined"?
I'm updating a view on an existing list programmatically but I can't get the aggregation to work correctly. I'm setting it as follows (the values are pulled from an xml site definition):
if (...
- 409
0
votes
0
answers
613
views
Combined Tasks List Data View Web Part - SharePoint Designer 2013
I am looking to create a list that will show all outstanding tasks from multiple Task lists that are in multiple site-collections in Sharepoint Online/Office 365. I am aware that there are 3rd party ...
- 404
0
votes
2
answers
64
views
Aggregation as a separate step from Presentation
I am wondering if anyone knows of any (SharePoint 2010) COTS or OOTB ways of doing list aggregation/rollup that can be done separately from the Presentation layer?
Context:
I have used a number of ...
- 1
5
votes
2
answers
39k
views
How to show additional fields within the Content Query Web Part
I'm trying to use the Content Query Web Part to display all the tasks within a site collection, I've attached images of the Web Part properties and final output below.
I'm looking for information on ...
- 94
1
vote
0
answers
122
views
Set default Value of List Lookup Column based on Site Name
I've built a series of Project Sub-sites, each with a Task list that includes the Project Name. The sub-site name is also the project name. How can I set the default value of the Project Lookup ...
- 1,021
8
votes
2
answers
1k
views
Is it possible to have different timeline views against the same list?
Using a single task list, from our testing it seems that the add to timeline/remove from timeline functions store state across the site list rather than against the view.
Is it possible to select a ...
- 303
1
vote
2
answers
779
views
View aggregations programmatically
I have a view in my list,
I defined aggregations in my view: sum and average of several columns.
Now I want to get programmatically the aggregations results.
How can I get it?
- 694
1
vote
2
answers
1k
views
Constructing a link in a dataform webpart
I've setup a DataFormWebPart which aggregates tasks from subsites. The user doesn't only want to view the tasks, there should be an option to edit / open them as well. So I need a way to at least ...
- 1,274
0
votes
1
answer
2k
views
Summing a column on a DVWP with 2 levels of grouping with incorrect subtotals
I am working with SharePoint 2007, and have been charged with making a report based on external data (SQL Server). It is a high level look at list of tickets in particular statuses. I decided to go ...
- 66
2
votes
1
answer
1k
views
Universal Task List
I suspect I am over-complicating this issue. At least it seems like such an obvious need that I would expect an obvious, pre-existing solution.
Specifically, we want the user to be able to ...
- 101
0
votes
1
answer
324
views
Effectively Querying Subsite RootFolder.Properties
I'm storing some data in the RootFolder.Properties for a bunch of subsites, sub-subsites and sub-sub-subsites. On the parent site(s), I want to roll up that data, security trimmed for the user. (All ...
- 868
0
votes
1
answer
187
views
Aggregating lists based on content type
We've got some lists that we plan to aggregate using a content query web part (CQWP) later, using a custom content type. The content type will be used on numerous sites within a site collection, but ...
- 4,405
1
vote
1
answer
619
views
Advanced filtering in the ContentByQueryWebPart
I have a webpartpage with two CQWPs. I want the first to show all pages for the current site, and I want the second to show all pages for the subsites of the current site.
As I can see, there's no ...
- 2,538
1
vote
2
answers
175
views
RSS from the whole Sharepoint portal
It would be nice to have an RSS feed from the whole Sharepoint portal, all lists, webs which a current user has access to.
Any ideas?
- 5,750
4
votes
2
answers
265
views
RSS enabled web part
We are rolling up content from multiple site collections and are looking for a way to allow a RSS feed from that rolled up content. Any ideas on implementation of a RSS option for a custom webpart? ...
- 710
2
votes
1
answer
628
views
aggregate data source and pseudo join?
Is it possible to use the aggregatedatasource to show all "parents" and theirs "children" where at least one "children" is created by the current user ?
To be more clear, imagine the following :
...
- 7,508
0
votes
2
answers
1k
views
Site Aggregator web part in SP2010 does not show new tab
I am unable to find "new tab" after adding Site Aggregator web part.
Does anyone know how to do it?
- 3,185
2
votes
1
answer
4k
views
Aggregating SharePoint lists
We are designing a system with a national level, regional level and a sub-regional level.
We plan to implement this with a site structure with sub-sites and sub-sub-sites.
The sites at the lowest ...
- 2,227
4
votes
1
answer
2k
views
Content Query Web Part not rendering calendar list description field
We have a SP2010 site that we are making extensive use of the CQWP (Content Query Web Part) on. When I point the CQWP at a specific list it displays description value fine. The problem is when I point ...
- 535
5
votes
5
answers
4k
views
Tasks Roll up across Farm, site collection
We have OOTB "task lists" in many sites used by the same set of users.
We have a farm with "x" site collections and "x" sites with-in them without any changes to the default content type.
We would ...
- 626
2
votes
3
answers
207
views
SP 2007 - creating a 'blogfall' of all recent blog posts from mysite blogs
I want to aggregate into one webpart the posts made by staff on their mysite blogs.
This basically allows me to present the internal musings of staff to all staff. What I am trying to do is elevate ...
user2546
0
votes
1
answer
2k
views
XSLT for summing Number column where there are cells with no value
This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
- 123
2
votes
1
answer
1k
views
Content aggregation: Same document library in several subsites into one big document library in main site
Let's say I have a main site collection with three subsites each having one document library:
MainSite
SubSite1 (myDocLib)
SubSite2 (myDocLib)
SubSite3 (myDocLib)
I want three subsites for security ...
- 4,775
0
votes
1
answer
781
views
How do I filter on a sum in a group footer? (Data View Web Part)
I have a DVWP that displays groups of data. For each group, I've got a sum of one of the columns. This sum exists in the group footer in a template called dvt_1.groupfooter0.
<xsl:variable name="...
- 145
2
votes
1
answer
356
views
Summary of recent events web part
How can I acumulate recent changes on one single start page. I want to see latest changes
as a single stream, with things coming from various lists like news, forums, document libraries etc etc
and I ...
1
vote
2
answers
5k
views
How do I create DVWP showing multiple lists with latest item from each list?
We have a MOSS site which is using a DVWP to pull in from multiple subsites' list items to display as a calculated field KPI set (just as Christophe has suggested on his forum page).
This works great,...
2
votes
2
answers
681
views
How do I query several lists with the Object Model and merge the results?
Is it possible to with the Object Model query several lists at the same time and get the result merged together? Something like linked sources in SharePoint Designer?
I have created a web part that ...
11
votes
6
answers
32k
views
How to aggregate events from multiple calendars to master calendar?
Across a site collection, various sites maintain their own calendars. Meanwhile, users have requested that events for those subgroups be aggregated and displayed on a master calendar.
Question: Out-...