Inn Inn Excel有没有定期捕获单元的值的方式？
我正在处理一个运输仪表板，我正在尝试找到一种方法来记录每小时发货货物价值的每小时的日志，并根据它制作现场直线图？
从左侧开始，我有一个电源查询表，该表每5分钟从服务器上取下数据。 “今天？”列检查船舶日期是否与今天的日期相匹配，并过滤了昨天运送的商品，因此您只看到今天发货的商品。
在右侧的蓝色枢轴表中，我结合了船值 - 枢轴表显示了今天的当前发货价值（178,924.81英镑），并且过去几天的总计总计，这是在报告所致的范围内。这个可以忽略。
在此的权利下，我有一个代表今天目标的值。这是手动输入的，并在公司开放的17小时之间进行分配。每个小时，目标都会累积，因此到我们达到17小时时，目标应为525,000.00英镑。
在底部，我有当前的时间，每分钟都会更新。
我希望能够将当前时间与表格中的时间进行比较，如果小时匹配，请在累积列中显示发货值的“快照”。另外，我想在每个小时的转弯时拍摄发货值的快照，并相应地填充每一行，以便我们有一个记录我们每小时发货的数量，并与每个小时目标进行比较。
这可能吗？
谢谢，
I have a shipping dashboard I'm working on, and I'm trying to find a way to record an hourly log of the value of shipped goods every hour, and make a live line graph based on it?
Starting on the left, I have a power query table which pulls data off a server every 5 minutes. The "today?" column checks if the ship date matches today's date, and filters out goods that were shipped yesterday, so you're only seeing goods that were shipped today.
In the blue pivot table on the right, I have combined ship value - the pivot table shows todays current shipped value (£178,924.81), and the past days combined total, as far back as the report goes. This one can be ignored.
To the right of this, I have a value which represents todays target. This is manually entered, and split between the 17 hours that the company is open for. Each hour, the target accumulates, so that by the time we reach hour 17, the target should be £525,000.00.
Towards the bottom, I have the current time, which is updated every minute.
I want to be able to compare the current time to the time in the table, and if the hour matches, display a "snapshot" of the shipped value in the accumulate column. Alternatively, I would like to take a snapshot of the shipped value at the turn of each hour, and populate each row accordingly, so that we have a log of how much we shipped each hour, and compare with each hours target.
Is this possible?
Thanks,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论