创建折线图 [英] Creating a Line Chart

问题描述

大家好，

我正在尝试根据包含2个字段的表格构建数据透视图：version_number和date_created。如何创建一个S曲线枢轴图，显示随着时间的推移创建的版本号的累积总和，从min（date_created）到Max（date_created）的每周时间间隔

解决方案

大家好，

我正在尝试根据一个包含2个字段的表构建一个数据透视图：version_number和date_created。如何创建一个S曲线枢轴图，显示随时间推移创建的版本号的累积总和，从min（date_created）到Max（date_created）

1. 每个version_number是否都有相应的date_created并且这两个值都是顺序的吗？请发布一些样本数据，以便我们可以更清楚地了解您所描述的内容。
2. 每周期间的版本号累积总和表示什么？
3. 它会可能更容易创建一个由版本号，版本中包含的每周间隔和运行版本号总计组成的表。然后可以轻松绘制数据。这是你的想法吗？

1. 每个version_number是否都有相应的date_created并且这两个值都是顺序的吗？请发布一些样本数据，以便我们可以更清楚地了解您所描述的内容。
2. 每周期间的版本号累积总和表示什么？
3. 它会可能更容易创建一个由版本号，版本中包含的每周间隔和运行版本号总计组成的表。然后可以轻松绘制数据。这是你的想法吗？

ADezii，每个[ver_number]是一个独特的文本类型字段（例如ABC-123-XYZ）和具有相应的[date_created]日期类型字段，并且'不是顺序的。

版本号的累积总和表示在该日期间隔之前创建的[ver_number]的总数。

我想我想要的是从该表创建一个查询，它会给我2个字段：Date字段，其中包含每周间隔日期和[ver_number]的总数，直到相应的日期间隔。

ADezii，每个[ver_number]是唯一的文本类型字段（例如ABC-123-XYZ），并具有相应的[date_created]日期类型字段，并且'不是顺序的。

版本号的累积总和表示在该日期间隔之前创建的[ver_number]的总数。

我想我是什么想要是从那个表中创建一个查询会给我2个字段：具有每周间隔日期的日期字段和在相应日期间隔之前创建的[ver_number]总数。

您能发布一些样本数据，比如12条记录吗？

Hi all,
I''m trying to build a pivotchart based on a table that has 2 fields: version_number and date_created. How do I create an S curve pivotchart that would show the cumulitive sum of version numbers created as time progresses in weekly interval from min(date_created) to Max(date_created)

解决方案

Hi all,
I''m trying to build a pivotchart based on a table that has 2 fields: version_number and date_created. How do I create an S curve pivotchart that would show the cumulitive sum of version numbers created as time progresses in weekly interval from min(date_created) to Max(date_created)

1. Does each version_number have a corresponding date_created and are both these values sequential? Kindly post some sample data, so that we may get a clearer picture of what you are describing.
2. What does the cumulative sum of Version Numbers for a weekly period indicate?
3. It would probably be easier to create a Table consisting of Version Numbers, weekly intervals contained within a Version, and a Running Version Number Total. The data could then be easily plotted. Is this what you have in mind?

1. Does each version_number have a corresponding date_created and are both these values sequential? Kindly post some sample data, so that we may get a clearer picture of what you are describing.
2. What does the cumulative sum of Version Numbers for a weekly period indicate?
3. It would probably be easier to create a Table consisting of Version Numbers, weekly intervals contained within a Version, and a Running Version Number Total. The data could then be easily plotted. Is this what you have in mind?

ADezii, each [ver_number] is a unique text type field (ex. ABC-123-XYZ) and has a corresponding [date_created] date type field, and the''re not sequential.
Cumulative sum of Version Numbers means the total number of [ver_number] created up until that date interval.
I guess what I want is to create a query out of that table that would give me 2 fields: Date field which has weekly interval dates and total number of [ver_number] created up until the corresponding date interval.

ADezii, each [ver_number] is a unique text type field (ex. ABC-123-XYZ) and has a corresponding [date_created] date type field, and the''re not sequential.
Cumulative sum of Version Numbers means the total number of [ver_number] created up until that date interval.
I guess what I want is to create a query out of that table that would give me 2 fields: Date field which has weekly interval dates and total number of [ver_number] created up until the corresponding date interval.

Could you post some sample data, say 12 Records?

这篇关于创建折线图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！