# Transaction filtering issue

**URL:** <https://community.mycapitally.com/t/transaction-filtering-issue/262>\
**Category:** Issues\
**Created:** [October 11, 2024, 8:49pm UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262 "2024-10-11T20:49:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Early\_Bird](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/e/92400e/32.png) [@Early\_Bird](https://community.mycapitally.com/u/Early_Bird)\
**Post date:** [October 11, 2024, 8:49pm UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/1 "2024-10-11T20:49:15Z")

</div>

I want to filter for example “buy” transactions for September 2024. I go to portfolio → transactions → filter period above the chart → thick "period only " in table header, but I see all buy transactions from august, July etc.

Am I doing something wrong ? or is there an issue ?

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [October 11, 2024, 8:54pm UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/2 "2024-10-11T20:54:47Z")

</div>

Hmmm, what you described is how it should work and it does so for me right now…

Just make sure that the time period is indeed just September (you can type 2024-09 or choose start and end dates) and the Only period is enabled (blue).

Any chance you could send a screenshot with your values redacted? Maybe I’ll be able to see the problem then.

---

<div class="post-metadata">

**Author:** ![Early\_Bird](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/e/92400e/32.png) [@Early\_Bird](https://community.mycapitally.com/u/Early_Bird)\
**Post date:** [October 12, 2024, 8:01am UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/3 "2024-10-12T08:01:39Z")

</div>

Thanks for the reply. Clearly I was doing something wrong because now it’s working ok.  
Two things to mention.

1. There are 2 filtering locations and it get’s a little bit confusing. Maybe there is a way of improving this.

- one at the top  
 ![Screenshot 2024-10-12 at 10.38.00](https://community.mycapitally.com/uploads/default/original/1X/f4ad18fabf77dc111f0ad9be75b16df6e85203bb.png)
- one above the chart  
 ![Screenshot 2024-10-12 at 10.57.00](https://community.mycapitally.com/uploads/default/original/1X/3a7a775cfde9666c404e3d15d77e0a2554d41ec0.png)  
and it seems both filter the same data.

1. If I do any filtering, the totals from table bottom change only if I filter with the top filter (not the one above chart)

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [October 12, 2024, 8:49am UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/4 "2024-10-12T08:49:25Z")

</div>

Hey, they actually do two different things.

The one on the top filter the _positions_ ([position units](https://www.mycapitally.com/help/position-units) to be precise) - so it will include positions that were **opened** in September. If you also select `max`, the table will show you transaction only for these positions - so both Buy & Sell. Buys will only be from September, Sells can be from any month.

Now the one on the bottom controls the time period for the results - you select for what period you want the returns and other metrics to be calculated.

So if you want to see only the positions you have _closed_ in September, use the `Position Closed within period 2024-09` on top and `max` in bottom. The charts and metrics will show you how these positions performed and how long you held them.

If you just want to see the transactions from September, don’t filter on top, just select the `2024-09` on the lower one.

> [@Early\_Bird](#):
>
> If I do any filtering, the totals from table bottom change only if I filter with the top filter (not the one above chart)

Yes, filtering the table by searching, period only or choosing transaction types will currently not affect the aggregation at the bottom. This is on the roadmap.

What number you’re looking for? Number of transactions, the sold amount, something else?

---

<div class="post-metadata">

**Author:** ![Early\_Bird](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/e/92400e/32.png) [@Early\_Bird](https://community.mycapitally.com/u/Early_Bird)\
**Post date:** [October 12, 2024, 9:07am UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/5 "2024-10-12T09:07:28Z")

</div>

I find it difficult to use with having these 2 different filtering.  
Now I remember what the issue was in the first place → I was filtering only the bottom (above chart) for September, the transactions indeed are filtered for September, but the positions are not. It shows me positions with no transaction in September also, ant for the positions that had transactions in September the amounts are in full (not with for ex: 47% badge and the corresponding amount).  
I was also trying to find the total amount invested in September, but because the totals ( total quantity, total value, total invested principal. etc) where not filtered in positions, and in transactions there are no totals , I wasn’t able to do this only with bottom filter(above chart).

So I think it is an issue that can be improved, the confusion between the 2 concomitent filtering methods, and the partial filtering (only transaction , not positions, and maybe other tabs - I didn’t check), and also the totals.

Thanks.

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [October 12, 2024, 12:37pm UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/6 "2024-10-12T12:37:25Z")

</div>

The period selector is not a filter. It selects the period to calculate metrics for. It’s a very typical selector that works in many other apps - mostly on charts - just in Capitally there’s one that affects the whole screen to limit the confusion.

Similarly, in other apps filters act on positions, but Capitally lets you filter by open/close date, not only asset or category.

I agree the footer is confusing, but funnily enough it was introduced as a quick user-request solution with a known drawback to address later

---

<div class="post-metadata">

**Author:** ![Early\_Bird](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/e/92400e/32.png) [@Early\_Bird](https://community.mycapitally.com/u/Early_Bird)\
**Post date:** [October 12, 2024, 12:48pm UTC](https://community.mycapitally.com/t/transaction-filtering-issue/262/7 "2024-10-12T12:48:19Z")

</div>

> [@rafal](#):
>
> funnily enough it was introduced as a quick user-request solution with a known drawback to address later

🤯 😂
