访问分区功能：有没有办法让它显示没有计数的bin类别？

发布于 2024-09-27 14:40:12 字数 545 浏览 2 评论 0原文

我正在尝试使用访问分区函数来生成用于生成直方图的箱，以显示我的利用率百分比数据集的频率分布。但是，分区函数仅显示具有计数的类别的类别箱范围（例如0:9、10:19 等）。我希望它最多显示 100。

示例：使用此函数：

% Utilization: Partition([Max],0,100,10)

完整的 SQL 是：

SELECT Count([qry].[Max]) AS Actuals, Partition([Max],0,100,10) AS [% Utilization]
FROM [qry]
GROUP BY Partition([Max],0,100,10);

给我：

Actuals  |  % Utilization
4        |   0:  9
4        |  10: 19
4        |  20: 29

但我希望它为没有 90:99 以内的值的范围显示 0。这可以做到吗？

提前致谢

原文

I'm trying to use the Access Partition function to generate the bins used to generate a histogram chart to show the frequency distribution of my % utilization data set. However, the Partition function only shows the category bin ranges (e.g. 0:9, 10:19 etc) only for the categories that have a count. I would like it to show up to 100.

Example:
Using this function:

% Utilization: Partition([Max],0,100,10)

The Full SQL is:

SELECT Count([qry].[Max]) AS Actuals, Partition([Max],0,100,10) AS [% Utilization]
FROM [qry]
GROUP BY Partition([Max],0,100,10);

gives me:

Actuals  |  % Utilization
4        |   0:  9
4        |  10: 19
4        |  20: 29

but I want it to show 0s for the ranges that don't have values up to 90:99. Can this be done?

Thanks in Advance

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

司马昭之心 2024-10-04 14:40:12

我能想到的唯一方法是使用一个附加的 Bins 表，其中包含您想要说明的所有 bin：

SELECT Bins.[% Utilization], t.Actuals FROM Bins
LEFT JOIN
     (SELECT Count(max) AS Actuals, 
             Partition([max],0,100,10) AS [% Utilization]
      FROM qry
      GROUP BY Partition([max],0,100,10)) t
ON t.[% Utilization]=bins.[% Utilization]

The only way I can think of doing this is with an additional Bins table that contains all the bins you wish to illustrate:

SELECT Bins.[% Utilization], t.Actuals FROM Bins
LEFT JOIN
     (SELECT Count(max) AS Actuals, 
             Partition([max],0,100,10) AS [% Utilization]
      FROM qry
      GROUP BY Partition([max],0,100,10)) t
ON t.[% Utilization]=bins.[% Utilization]

回复收藏 0 原文

~没有更多了~