只选择12列返回 - Dashboard_PV [英] Select only 12 columns going back - Dashboard_PV
问题描述
此帖子类似于我发布的帖子（仅选择10列后退）关于动态选择一个月一个月回溯12个月的数据。这是另一个线程的qiote（＃3）：
This thread is similar to the thread (Select only 10 columns going back) that I posted regarding the dynamic selection of data going back one month at a time for 12 months. Here is the qiote fron the other thread (#3) :
基本上这是关于就这个月他们犯了多少错误来衡量就业的表现并将当前数字与之前的数字进行比较。例如，对于员工A，2008年3月的错误数为324，2008年2月的错误数为420，2008年1月的错误数为200，等等......一直追溯到2007年3月，看看如何错误随着时间的推移而增加或减少。此应用程序的用户希望能够通过从任何给定的月份进行选择并以每月增量回顾一年来进行此操作
Basically what this is about is measuring the performance of employess in terms of how many errors they made this month and compare the current figure with the ones made before. For example, for employee A the number of errors for the Month of March 2008 is 324, for february 2008 is 420, for January 2008 is 200, etc....going all the back to the month of March 2007 and see how the errors have increased or decreased over time. The users of this application want to be able to do this by picking from any given month and look back up to a year in monthly increments
这次，差异是如何呈现表中的数据。我从每月发布的一系列数据转储中构建了表。我选择了包含我想要的数据的列，称为PV，并将列重命名为它所在的月份。例如，如果我选择了与1月相对应的列，则元数据将如下所示：
This time, the difference is in how the data from the table is presented. I constructed the table from a series of data dumps that are issued monthly. I select the column with the data that I want, called PV and rename the column for the month in which it came. For example, if I took a column corresponding to the month of January, the metadata would look like this:
推荐答案
这篇文章是要注册的。
今晚我会做一些整理帖子添加链接并稍微调整格式。这可能是主要的参考点，因此非常重要。
初看起来好像你已经做了一个不错的尝试。现在迟到所以我今晚不会尝试找到任何解决方案。
This post is to register.
Tonight I will just do some tidying up on the post adding links and adjusting the format somewhat. This is likely to be the main reference point so quite important.
At first look it seems as if you''ve made a decent attempt from which to start. Getting late now so I won''t try to find any solutions tonight.
Richard，在我离开之前，如果你从其他数据源编造了Dashboard_PV，我建议你重新考虑布局。这将是一个真正的头痛，如果可能的话应该避免。
让我知道。
Richard, before I head off for the night, if you have made up Dashboard_PV from other data sources, I suggest you reconsider the layout. This will be a real head-ache to work with and should be avoided if at all possible.
Let me know.
这篇文章是要注册的。
今晚我会做一些整理帖子添加链接并稍微调整格式。这可能是主要的参考点，因此非常重要。
初看起来好像你已经做了一个不错的尝试。现在迟到所以今晚我不会试图找到任何解决方案。
This post is to register.
Tonight I will just do some tidying up on the post adding links and adjusting the format somewhat. This is likely to be the main reference point so quite important.
At first look it seems as if you''ve made a decent attempt from which to start. Getting late now so I won''t try to find any solutions tonight.
这很好，非常感谢
That''s fine, thanks so much
这篇关于只选择12列返回 - Dashboard_PV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
