Dashboard Filters
Outline
When you select a dashboard, the available filters and their current values are listed across the top of the dashboard, under the dashboard name. These filters apply to all the reports shown on the dashboard.
Note: To hide the filters, click the hide filters icon in the dashboard’s top right corner. Click it again to redisplay the filters.
Use the available filters to dial in the dashboard to just the information you need. Keep in mind that reports only display 500 rows or less, so if you are drilling into a number that's higher than 500, your detailed results will be incomplete. Narrow your filters to display complete results.
Use Linked Filters
The available values for some filters are dependent on each other. For example, when you choose a value for the Panel Type filter, the options for the Panel Name filter are limited to only panels with the type you chose. It works the other way, too: Choosing a Panel Name filter value limits the Panel Type filter values to just the type of the panel you chose. When you choose a new filter value, a link icon appears in the Filters section next to all other filters whose available values have changed because of this choice.
Understand Date and Time Filter Options
All date filters on hc1 dashboards provide the same options. Understanding the nuances of these options is important so that you know what data is included or excluded when you apply a filter.
Absolute Filters
To compare the data shown in hc1 to other systems, we recommend choosing absolute date and time filters where you use the calendar control to set the filter value:
- For “is on the day” or “is in range” operators, click the calendar control. Use the arrows to change the month and click the day you want. Note that “is in range” includes data from the first and last days you specify.
- For “is before” or “is on or after” operators, choose absolute, and then click the calendar control.
- For “is in the year,” type the four-digit year in the box.
Relative Filters
When you are looking at recent trends, choose filters that are relative to the current date and time. These filters require choosing an operator, a numerical value, and a unit of time. Make sure to choose a unit of time that corresponds to the level of precision you need to answer your data question. Put another way, choosing 2 days will not return the same data as choosing 48 hours.
For the “is in the last” operator, type a numeral in the first box and choose a unit of time of the current date, so “is in the last 3 days” would include 2 days ago, yesterday, and today. To exclude partial units of time, choose the option that starts with complete, as in complete days. For example, “is in the last 3 complete days” would include 3 days ago, 2 days ago, and yesterday.
For “is this,” “is previous,” or “is next,” keep in mind that days, weeks, months, quarters, and years are measured according to the calendar:
- A week is a calendar unit that starts on Monday and ends on Sunday. Choosing the “is this week” filter would show 2 days’ worth of data if you did it on a Tuesday and 4 days’ worth of data if you did it on a Thursday. Choosing “is previous week” on Monday would return data from the most recent 7-day period (last Monday through yesterday), but choosing “is previous week” on Friday would return data from 11 days ago through 5 days ago (two Mondays ago through last Sunday).
- A month could be 28 days, 29 days, 30 days, or 31 days, depending on the year and time of year.
- Quarters start on January 1, April 1, July 1, and October 1.
- This year is a range from January 1 of the current year up to the current date.
Running “is any time” is essentially no date filtering because it matches any value. This option is not recommended because your results are likely to be incomplete because the full results dataset is likely to exceed the maximum number of rows, depending on what other filters you have applied.
Change Filter Values
To change filter values:
- Click the box under the name of the filter you want to change. A small window opens with the controls for that filter.
- Choose an operator from the leftmost picklist.
- In the right-hand boxes, set a value by typing the name and choosing from the search results or using the other controls that appear when you set the operator. Note that value searches aren’t case-sensitive.
- To add alternate (OR statement) filter criteria, click + after the filter and choose an operator and filter value.
- Click anywhere outside the filter window to close it.
- Click the update button to update the dashboard with the new filter values. When the filters have finished updating, the icon will change to a reload button and display how long it has been since the filters were reloaded.
The update button changes to a cancel button while the dashboard updates. If you change your mind and want to keep the dashboard the way it was, click the x.
To remove or clear a value:
- Click the box under the name of the filter you want to change. A small window opens with the controls for that filter.
- Click X next to the value or OR statement you want to remove.
- Click the Update button.
To reset all dashboard filters to the default values right away, click the dashboard actions menu icon and choose Reset Filters. When you log out of hc1, all the filters are reset to their default values.
Use Saved Filters
You can use the Saved Filter Options menu to save, manage, and apply sets of filter values on a dashboard. Depending on which option you choose, different controls will be displayed. When you have finished using an option, you can hide the saved filter controls by clicking the Cancel button. If you just want to close search results, click outside the dashboard.
Create a Saved Filter
To save a set of dashboard filter values:
- Navigate to the dashboard you want to save a filter for.
- Select the filter values you want to save.
- From the Saved Filter Options list, choose Save New Filter.
- In the text box, type a name for your filter.
- Click Save. The filter name appears in the list.
Note: Saved filters are designed to be available only to the user who created them and only on the dashboard where they were created.
Rename and Delete Saved Filters
To rename a saved filter:
- Navigate to the dashboard where you want to apply the filter.
- From the Saved Filter Options List, choose Manage Existing Filter.
- Click in the search box and choose the saved filter you want from the list. If you have a lot of saved filters, start typing a word in the filter name to narrow down the list, and then choose your filter from the search results.
- Click in the text box and edit the name to be what you want.
- Click Rename.
- In the Confirmation box that appears, click Yes.
To delete a saved filter:
- Navigate to the dashboard where you want to apply the filter.
- From the Saved Filter Options List, choose Manage Existing Filter.
- Click in the search box and choose the saved filter you want from the list. If you have a lot of saved filters, start typing a word in the filter name to narrow down the list, and then choose your filter from the search results.
- Click Delete.
- In the Confirmation box that appears, click Yes.
Apply and Update Saved Filters
To apply a filter you have saved:
- Navigate to the dashboard where you want to apply the filter.
- From the Saved Filter Options List, choose Apply Saved Filter.
- Click in the search box and choose the saved filter you want from the list. If you have a lot of saved filters, start typing a word in the filter name to narrow down the list, and then choose your filter from the search results.
- Click Run.
To update a saved filter:
- Navigate to the dashboard where you want to apply the filter.
- From the Saved Filter Options List, choose Apply Saved Filter.
- Click in the search box and choose the saved filter you want from the list. If you have a lot of saved filters, start typing a word in the filter name to narrow down the list, and then choose your filter from the search results.
- Change the filter value selections as needed.
- Click Update.
- In the confirmation box that appears, click Yes.
Resources
![](https://cdn.exceedlms.com/uploads/organizations/favicons/577/small/hc1-color-5.png?1672779326&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL29yZ2FuaXphdGlvbnMvZmF2aWNvbnMvNTc3L3NtYWxsL2hjMS1jb2xvci01LnBuZz8xNjcyNzc5MzI2IiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1Nzg1MjQzfX19XX0_&Signature=YamETxMZlUAOdh~vwjaibIETrw8v3OZrsDTS77d61CSePDCpSbwlBUUcoqbBmfyqPr-LyxxKYnRaQuM0YlECehZZGHlwyB3~1dXQHeHw6dHSgHYsUdeAJtlDhdqjqmGPkP~BHoqiQaBAufq6-28dezQHfqgVHvvnre2TU-vr6U42UbIs4Hsy87keEVedAlH39-8r~uzXE-3s5SFk8lCqOkvyfOgo5a9NdwhuWSUvbw4rZcqB8TYyG5WfOs18Wvjgv5O58zY0FqCijJLnRGFiWRu1Gl09v20cBwH41UQB6eiCnp6uHrQn31VHoB~8R5tASHUwYd4bHKPqr6K2dOZnQg__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Dashboard Basics
![](https://cdn.exceedlms.com/uploads/resource_recommended_pictures/targets/4207723/activity_preview/knowledge-base.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX3JlY29tbWVuZGVkX3BpY3R1cmVzL3RhcmdldHMvNDIwNzcyMy9hY3Rpdml0eV9wcmV2aWV3L2tub3dsZWRnZS1iYXNlLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcyNTg0NzM2MX19fV19&Signature=YnGHXKmi1pWGxIu~BNr1hk-6D0y0j7DC4I7BHNcV7Y0B~h68AAPC-EjlK2nf3Ncu~LXnr26UL1UDNEVtsdpplZvy7Qb0V~BrVkDudk1igDMYqdu4PkEX03fPMM4R3Ff-663BFy366bbNzCC2UaVCiwt3fmGa0GcYbEfNv-HJ7hKLyg8LUWYHbZDHOOMutTq8GZh9jyS-IZepcjdjNEDLL17DzYZh3RALpSG6ddyHtPvzv4eDrTlYKmUKNS4apzA0niU-RvaUxP-dOZhJDJTwNK9aym0H7dYjs2ClZqjXLS45KCWQSEuzNw1UUbnBc0PwHJPTuyRau1kgXTcXC6~Jgw__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
![](https://cdn.exceedlms.com/uploads/organizations/favicons/577/small/hc1-color-5.png?1672779326&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL29yZ2FuaXphdGlvbnMvZmF2aWNvbnMvNTc3L3NtYWxsL2hjMS1jb2xvci01LnBuZz8xNjcyNzc5MzI2IiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1Nzg1MjQzfX19XX0_&Signature=YamETxMZlUAOdh~vwjaibIETrw8v3OZrsDTS77d61CSePDCpSbwlBUUcoqbBmfyqPr-LyxxKYnRaQuM0YlECehZZGHlwyB3~1dXQHeHw6dHSgHYsUdeAJtlDhdqjqmGPkP~BHoqiQaBAufq6-28dezQHfqgVHvvnre2TU-vr6U42UbIs4Hsy87keEVedAlH39-8r~uzXE-3s5SFk8lCqOkvyfOgo5a9NdwhuWSUvbw4rZcqB8TYyG5WfOs18Wvjgv5O58zY0FqCijJLnRGFiWRu1Gl09v20cBwH41UQB6eiCnp6uHrQn31VHoB~8R5tASHUwYd4bHKPqr6K2dOZnQg__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Dashboard Basics Video
![](https://cdn.exceedlms.com/uploads/resource_recommended_pictures/targets/4207603/activity_preview/hc1-academy-video-cover-1.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX3JlY29tbWVuZGVkX3BpY3R1cmVzL3RhcmdldHMvNDIwNzYwMy9hY3Rpdml0eV9wcmV2aWV3L2hjMS1hY2FkZW15LXZpZGVvLWNvdmVyLTEucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1ODQ3MzYxfX19XX0_&Signature=Ufi0cHlBT~9n3uafwjT8HuvXsPcOFg4zhTQJ0tqCIHCFtIWzpbCFxbTmRTotn52dC9FCIoL93QJ7y~85XvbjjyC~a8sGuYsLE3ooK3wmPbe~tDmGreMCIuXVnBlr8-g1EePpdrHtcPNylDEiklpeAFMxo0InVoE6~CWCSbyXLSSChp7lygM7eCUisK6hdAnoNQ5QdpqSNWR3dvB5-pTOvMrhVZFLYF77PYXGhIwLllRgE6p08rV11Zvy9zVtA6b108ywBsUyBSWczb7QMhM1tupbF4cq6yRlSPFLW11U8H7CnBfYYWoIDlrPnuCowwk33S5JwkWzs4BBIiKnbRD8rw__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
![](https://cdn.exceedlms.com/uploads/organizations/favicons/577/small/hc1-color-5.png?1672779326&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL29yZ2FuaXphdGlvbnMvZmF2aWNvbnMvNTc3L3NtYWxsL2hjMS1jb2xvci01LnBuZz8xNjcyNzc5MzI2IiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1Nzg1MjQzfX19XX0_&Signature=YamETxMZlUAOdh~vwjaibIETrw8v3OZrsDTS77d61CSePDCpSbwlBUUcoqbBmfyqPr-LyxxKYnRaQuM0YlECehZZGHlwyB3~1dXQHeHw6dHSgHYsUdeAJtlDhdqjqmGPkP~BHoqiQaBAufq6-28dezQHfqgVHvvnre2TU-vr6U42UbIs4Hsy87keEVedAlH39-8r~uzXE-3s5SFk8lCqOkvyfOgo5a9NdwhuWSUvbw4rZcqB8TYyG5WfOs18Wvjgv5O58zY0FqCijJLnRGFiWRu1Gl09v20cBwH41UQB6eiCnp6uHrQn31VHoB~8R5tASHUwYd4bHKPqr6K2dOZnQg__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Dashboard Overview Webinar (Recording)
![](https://cdn.exceedlms.com/uploads/resource_recommended_pictures/targets/4207609/activity_preview/events-1.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX3JlY29tbWVuZGVkX3BpY3R1cmVzL3RhcmdldHMvNDIwNzYwOS9hY3Rpdml0eV9wcmV2aWV3L2V2ZW50cy0xLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcyNTg0NzM2MX19fV19&Signature=SFNziAJcQc8mS4Tt~xwEXfdbpN-JF07wGXOqRBSs4hkTCHMuLS7u~CKo3ZFN6aRuMF3D24uqTq6FfqTf8ItQFXIWYiqZycMcBNBpmVbk9vSfPWjbDsjZB78z1-jCDq3kkMXSLC8OptRTcIm4QRmHLF1GnxNIJRfpk3xSACk0T7Wcw54eEgZZXj8COPW6ABw9cfscIbTEIclTxzcP~U9hX8Qj8KTKsiVe8W89huoiSM~FWl1hL-U7X11jvKQ~oBUGcqu0U1kFvhnNj95izVHh~4F5-nyudI~rJCZD-BaL3bcvtiOKzwnv~Zu8YRJAgynGgrFEzqQgud2JvSVo7cu2ng__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)