Toad World® Forums

TDA histogram error on numerics?

The histogram tool is great on text data, but seems to break down when analyzing the frequency of numeric data. Is anybody else experiencing this or am I missing something?

There’s a View filter default to Top 10 on the bottom of histogram. Please try toggle it to Top25 or Top 100 to see the low frequency values.

I have changed the View filter and the count of numeric values changes if I’m looking at the Top 5, Top 10 or Top 100. This does not occur if I’m looking at text data; that is, the count of the most frequent 5 text fields always stays the same, whether I’m viewing the Top 5, Top 10 or Top 100.

I have a few questions:

  1. What database was this on, and what was the datatype of the column?

  2. Can you send a couple of screenshots illustrating this happening?

  3. If you feel comfortable about it, can you provide a sample set of the data that this is happening on, or the DDL? You can send it to ryan.johnson@quest.com.

Thank you for your time