# Dashboard Error While Filtering Data

**URL:** <https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582>\
**Category:** OpenSearch Dashboards\
**Tags:** troubleshoot\
**Created:** [November 7, 2023, 5:09pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582 "2023-11-07T17:09:55Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 7, 2023, 5:09pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/1 "2023-11-07T17:09:55Z")

</div>

OpenSearch Dashboards:

Hi guys! I don’t know if it’s the right group to start this conversation. But I’m having troubles while trying to set my OpenSearch Dashboards (in my Wazuh) to filter the “count” data as “desc” automatically. Now I’m doing everything manually when I want to generate a report. Does anybody knows how to solve it?

![image](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/a/a272f557db4c2b5aa2cd49dddebba88e7a9ef6df.png)

Obs: This image came from a “OpenSearch Dashboards” Table.

---

<div class="post-metadata">

**Author:** ![\_free](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/_free/32/6381_2.png) [@\_free](https://forum.opensearch.org/u/_free)\
**Post date:** [November 8, 2023, 2:31am UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/2 "2023-11-08T02:31:45Z")

</div>

You may need to reverse the visualizations before saving

---

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 8, 2023, 12:37pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/3 "2023-11-08T12:37:49Z")

</div>

But therein lies the problem! I already put it in descending order before saving. But on the main Dashboard, the error remains ;-;

---

<div class="post-metadata">

**Author:** ![\_free](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/_free/32/6381_2.png) [@\_free](https://forum.opensearch.org/u/_free)\
**Post date:** [November 9, 2023, 2:09am UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/4 "2023-11-09T02:09:51Z")

</div>

Can you please let me know the version of Opensearches and Visualization you are using, as I have no problem using table testing

---

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 9, 2023, 2:45pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/5 "2023-11-09T14:45:38Z")

</div>

Now, I’m using the 2.6.0 version.

---

<div class="post-metadata">

**Author:** ![\_free](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/_free/32/6381_2.png) [@\_free](https://forum.opensearch.org/u/_free)\
**Post date:** [November 10, 2023, 5:18am UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/6 "2023-11-10T05:18:19Z")

</div>

Table has an Order during production

![1699593106178](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/f/f81a541af845ebb9b111d525f5e1f6bfabf9166b.png)

---

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 10, 2023, 10:55am UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/7 "2023-11-10T10:55:01Z")

</div>

Thanks for the answer. But it’s strange, because I don’t have this option. Let me show you how it appears to me:

![image](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/8/802ab7b1feed7f096b0a53b064f3fde89121ad10.png)

Obs: The size that I’m using, it’s just a test to catch all the results instead of only 5, for example. And if you go to “Advanced” section, you’ll only find a Json input and Exclude/Include field.

Do you think that there’s a way to enable the “Order” option?

---

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 10, 2023, 6:48pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/8 "2023-11-10T18:48:07Z")

</div>

Dude, I just don’t know what to do anymore. Even changing the JSON file I did, but still had no success.

---

<div class="post-metadata">

**Author:** ![l\_ssants](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@l\_ssants](https://forum.opensearch.org/u/l_ssants)\
**Post date:** [November 10, 2023, 7:50pm UTC](https://forum.opensearch.org/t/dashboard-error-while-filtering-data/16582/9 "2023-11-10T19:50:05Z")

</div>

Hey, I found the solution!

The problem: I was using the “Significant Terms” aggregation, instead of “Terms”. When I changed the Aggregation field, the “Order” option became visible. Thanks for the help and the time spent!