Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Advanced Features:

...

Anchor
text
text
Text Filtergrams

The Text Filtergram panel displays a list of each distinct text value that appears in your dataset. The bars running left-to-right provide a histogram view of the relative number of times each value occurs. The total number of unique values is listed in the bottom left side of the panel. From the list, you can select values to dynamically display in your dataset. The filtering actions you can take with the list are described below in the section "Filtering Options".

 

Overview of Text Filtergram Display

...

a. Currently Selected button in top left corner: when you make selections from the list, the button’s label changes to indicate your number of selections. Click the button to open a new panel that lists every selected value. From this panel you can continue to refine the text values you want to filter on in your dataset. The actions you can take from this panel are described below in the section "Filtering Options."

b. Sort list order: by default, the list of text values displays from highest to lowest count. To reverse the order to display least to most, click the triangle in the upper right corner above the count column. You can also sort the list alphabetically by clicking the triangle located above the list. The triangle’s orange color indicates which sort order (numeric or alpha) is currently applied to the dataset.

...

  • Show as Graph (the default view)
    This histogram displays a numeric histogram representing the distribution of numeric values in your dataset. The horizontal line, or x-axis, represents the range of values that occur in your dataset within this column. The height of each bar represents the count of each distinct value in the column. The scale along the left side, or y-axis, provides a measure for the count. The filtering actions you can take with the histogram are described below in the section "Show as Graph—Filtering Options". 
     
  • Show as List
    Click this tab to hide the numeric histogram and display the unique occurrence of every value in the column. From the List, you select values to dynamically display in your dataset. The filtering actions you can take with the List are described below in the section "Show as List—Filtering Options".
     


Overview of Numeric Filtergram Display

...

a. Currently Selected button in top left corner: when you make selections on the histogram, the button’s label changes to indicate your number of selections. Click the button to open a new panel that lists every selected Range and Value currently selected in the histogram. From this panel you can continue to refine the numeric values you want to filter on in your dataset. If you already know the ranges and values that you want to filter on in your dataset, you can click this button instead of using the histogram. From the new panel you can enter values and ranges to begin your filtering operations. The actions you can take from this panel are described below in the sections "Show as Graph—Filtering Options" and "Show as List—Filtering Options".


b. Log button in bottom left corner: toggles on a logarithmic scale (log) view of your data. By default, a linear view of the data is displayed in the filtergram. However, if you have a large numerical range in which one or a few points in the data are much larger than the bulk of the data, the log view adjusts for skewness in your data.


c. Show Zoom/Pan in bottom left corner: toggles on and off an overview tool used for viewing the relative position of values and ranges that you have zoomed into on the numeric histogram. Zooming and panning operations are described below in the section "Show as Graph—Filtering Options"

d. When moving your mouse anywhere over the Filtergram panel, the following buttons display:

...


c. Refine your selections: After making selections, click the "Show Selected Items" button in the top left corner to open a new panel where you can continue refining your filtering operations. The button's label updates to reflect the number of items you have currently selected. 

If you already know the exact ranges and values you want to use for filtering your dataset, you can skip making selections from the List. In this case the button's label is "No Items Selected". Click the button to open a new panel where you enter exact values and ranges. All of the filtering operations you can perform from the panel are described in steps d1-d5 in "Show as Graph—Filtering Options."
Additional operations: you can also Invert and Clear your selections, and perform a Search for specific values from the List. See steps e-g in "Show as Graph—Filtering Options," for details.


...

Anchor
date
date
Date/Time Filtergrams

...

  • Show as Graph (the default view)
     

    This histogram displays the distribution of date/time values in your dataset. The horizontal line, or x-axis, represents the range of date values that occur in your dataset within this column. The height of each bar represents the count of each distinct date value in the column. The scale along the left side, or y-axis, provides a measure for the count. The filtering actions you can take with the histogram are described below in the section "Show as Graph—Filtering Options".

  • Show as List
    Click this tab to hide the date/time histogram and display the unique occurrence of every date/time value in the column. From the List, you select values to dynamically display in your dataset. The filtering actions you can take with the List are described below in the section "Show as List—Filtering Options".
     


Overview of Date/Time Display
When moving your mouse anywhere over the Filtergram panel, the following buttons display:
 


a. Currently Selected button in top left corner: when you make selections on the histogram, the button’s label changes to indicate your number of selections. Click the button to open a new panel that lists every selected Range and Value currently selected in the histogram. From this panel you can continue to refine the date/time values you want to filter on in your dataset. If you already know the ranges and values that you want to filter on in your dataset, you can click this button instead of using the histogram. From the new panel you can enter dates and ranges of dates to begin your filtering operations. The actions you can take from this panel are described below in the sections "Show as Graph—Filtering Options" and "Show as List—Filtering Options".


b. Log button in bottom left corner: toggles on a logarithmic scale (log) view of your data. By default, a linear view of the data is displayed in the Filtergram. However, if you have a large date range in which one or a few points in the data are much larger than the bulk of the data, the log view adjusts for skewness in your data.


c. Show Zoom/Pan in bottom left corner: toggles on and off an overview tool used for viewing the relative position of values and ranges that you have zoomed into on the histogram. Zooming and panning operations are described below in the section "Show as Graph—Filtering Options".

d. When moving your mouse anywhere over the Filtergram panel, the following buttons display:

...


c. Refine your selections: After making selections, click the "Show Selected Items" button in the top left corner to open a new panel where you can continue refining your filtering operations. The button's label updates to reflect the number of items you have currently selected. 

All of the filtering operations you can perform from the panel are described in step d for "Show as Graph—Filtering Options."

Additional operations: you can also Invert and Clear  your selections, and perform a Search for specific values from the List. See steps f-g in "Show as Graph—Filtering Options" for details.



...

Anchor
boolean
boolean
Boolean Filtergrams

...