https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/116318.aspxThu, 18 May 2017 14:58:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116318Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116318.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=116318So - what I am saying is that you should submit all your forms to a single library, then in another form (or whatever, web part, Excel, etc) use a data connection to THAT library to return all the data & then aggregate it.https://www.infopathdev.com:443/forums/thread/116317.aspxThu, 18 May 2017 13:19:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116317NameerSupra0https://www.infopathdev.com:443/forums/thread/116317.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=116317I have created a data connection between to form libraries. One library will have graphs + a field that aggregates the data (well call it field1), the other has the form in which the business case is chosen. However the only option i can find is when i submit my business case form, it just creates a new form in the graphs form library. Doesnt simply update field1. And even that doesnt work, i get an error stating a file with the same name already exists when i try to submit. There is no file with the same name, and i check marked the overwrite option anyways. How would i be able to make the business cases aggregate in a column in excel?https://www.infopathdev.com:443/forums/thread/116314.aspxWed, 17 May 2017 23:18:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116314Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116314.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=116314I'd guess you would promote the stage to the library the form submits to, then you could create .... something .... with a data connection to that library to aggregate the data / chart as desired? Power BI maybe, or even just Excel?https://www.infopathdev.com:443/forums/thread/116310.aspxWed, 17 May 2017 13:53:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116310NameerSupra0https://www.infopathdev.com:443/forums/thread/116310.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=116310My form has a drop down for the stage a business case is at (i.e initiated, completed, etc.), and i want a graph on the front page of my SharePoint site to display how many business cases we have at each stage. So each form submitted should relay this information to another app/page/form with a counter for each stage that can then be graphed. How should i go about this?