[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Need Query for histogram

I need the proper syntax for a histogram. Name of table: tblinprocess, field, timestamp. How do I get the totals I need for a histogram. Thank you for the response.
0
marlind
Asked:
marlind
1 Solution
 
miqrogrooveCommented:
Marlind, there are probably several ways to attack this problem.

As you know, a statistical histogram requires not only the input data, but also "bins" specified by sizes or ranges.  Could you describe for me how you want the bins arranged, how you will determine that arrangement, and will it change dynamically?

A histogram with static bins can probably be designed using one or two queries with both IIf statements and Sum functions.

A dynamic histogram system will need to have the bins pulled from a second source and will require a more complex query, or possibly even some programming code.

Also, if you would, describe the end product you need.  If you need a histogram chart, then perhaps designing a PivotTable or exporting data to Excel would be a better approach than using queries at all.

-- Miqro
0
 
marlindAuthor Commented:
Those are good questions. Let me put some thought into the questions and get back to you.
Thank You.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now