-
1. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Ken Flerlage Jul 8, 2018 4:40 PM (in response to Yves Lacroix)Not quite sure I understand the issue. The structure of the data, as is, should allow you to do what you need. For instance, I pulled in your data and did a quick summary:
I suppose the only thing that is missing are the specific categories you need. If you don't have those categories in your data, you have a couple of choices. First, you could add it to your data. Second, you could use groups in Tableau to create those. The problem with this is that new transaction types will not be automatically added to those groups, so it will become a maintenance problem.
To create the groups, right click on "Name or type of transaction" and select Create then Group.
From here, you can choose how to group each item:
This will create a new data item in your data called Name or type of transactions (group).
You can then use this in your charts. For example, this shows your spending over time using some groups I maade up.
Is this what you're looking for?
See attached workbook.
-
Transactions.twbx 42.8 KB
-
-
2. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Yves Lacroix Jul 8, 2018 7:22 PM (in response to Ken Flerlage)Hi Ken. Thanks for your assistance. I just tried to use the main data that I wanted to use and tried to follow your example. I still don't get the list of 'Name or Type of transactions' that we you obtained it, which what I am looking for. Instead, I get the following. I'm quite certain that I am close to the solution that you presented. Instead, I obtain the following. What do I need to do to get your version with the list of all transactions and Sum for each type of transaction?
Thanks again for your assistance!
-
3. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Ken Flerlage Jul 21, 2018 11:41 AM (in response to Yves Lacroix)Did you get this working?
-
4. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Yves Lacroix Jul 22, 2018 1:41 AM (in response to Ken Flerlage)Hi Ken. Thanks for following up.
Yes I got help from Tableau trainer.
On Sat, Jul 21, 2018 at 5:11 PM Ken Flerlage <tableaucommunity@tableau.com>
-
5. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Ken Flerlage Jul 22, 2018 9:28 AM (in response to Yves Lacroix)Would you please mark one of the responses as the "correct answer" so we can close this thread and others can learn from it in the future. Thanks!
-
6. Re: How can I group list of bank transactions by sub-category similar to personal budget heathers?
Ken Flerlage Jul 29, 2018 1:35 PM (in response to Ken Flerlage)Hi, just following up on this to see if we've addressed your question or you have additional questions. Please advise.