SharePoint列表数据中的SharePoint仪表板 [英] SharePoint Dashboard from SharePoint List Data

查看:65
本文介绍了SharePoint列表数据中的SharePoint仪表板的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,


我需要在SharePoint列表的基础上在SharePoint页面上设计仪表板。下面是列表数据。


我需要创建一个Dash Board,如下所示, 根据
获得价值(总和) 上提供的服务和以下分类


信息中心 -



SharePoint列表数据 -



在此列表中 - From和To Month是月份提供的服务 - 由用户填写。这是查阅列。


IMS,云和安全是默认情况下在另一个列表中定义的LOB。当我们填写项目ID然后LOB值到来。


累积  金额交易状态(查询列) 。


请帮我创建仪表板。如果可以这样做,请建议我使用SharePoint设计器工作流程或java脚本。谢谢




Ramakant Rathore

解决方案

嗨Ramakant。 SharePoint视图中有一些基本功能可能会有所帮助:



  • 总计 - 使用此功能可以对列或其他操作求和。
  • 组 - 组合相似的项目,然后为每个组创建总计视图

这是低技术。您在屏幕截图中寻找的内容需要代码。您可以使用REST API从列表中提取数据,然后使用JavaScript从列表信息中构建输出。



https:/ /blog.vgrem.com/2014/03/22/list-items-manipulation-via-rest-api-in-sharepoint-2010 /


Hi All,

I have a requirement to design a dashboard on SharePoint Page on the basis on SharePoint List. Below Is the List Data.

I need to create the Dash Board Like below,  get the Values (sum) on the basis of Service delivered on and Categorizes as below

Dashboard-

SharePoint List Data-



IN this List - From and To Month is service Delivered on month - Which would be filled by user. and here this is lookup column.

IMS , Cloud and Security are the LOB which are by default and defined in another List . when we fill the project ID then LOB Values comes.

Accrued Amount is Transaction Status(lookup Column).

Please help me in creating the Dashboard. Please suggest me if this can be done SharePoint designer workflow or java script is required. Thanks


Ramakant Rathore

解决方案

Hi Ramakant. There are some basic functions in SharePoint views that might help:

  • Totals - using this allows you to sum a column or some other operations
  • Groups - combines like items, which in turn creates a totals view for each group

That's the lowtech. What you're looking for in the screenshot would require code. You can use REST API to pull in data from a list and then use JavaScript to build the output from the list info.

https://blog.vgrem.com/2014/03/22/list-items-manipulation-via-rest-api-in-sharepoint-2010/


这篇关于SharePoint列表数据中的SharePoint仪表板的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆