# Create analytic that can access two tables

**URL:** <https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100>\
**Category:** Product Suggestions\
**Created:** [August 1, 2024, 6:41am UTC](https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100 "2024-08-01T06:41:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![saga.losman](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@saga.losman](https://community.tulip.co/u/saga.losman)\
**Post date:** [August 1, 2024, 6:41am UTC](https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100/1 "2024-08-01T06:41:44Z")

</div>

Hi!

I have two tables where all records are linked 1 to 1 in each table.  
Each linked pair has information about a Sales Lead in the company.  
The first table has all the information that is important for the user such as “Category” and the other table keeps track of the time that the lead has been in each process…

I am trying to make an analytic where I want to count the lead time per category, but I cannot access both the time information and the category information when making the analytic as they are in different tables.

I realise that it is possible to simply add a field with “Category” to the time tracking table aswell. But I like to keep these separate.

I was only asking if there is a way that I might have missed.

Thanks!  
Saga

---

<div class="post-metadata">

**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\
**Post date:** [August 6, 2024, 1:30pm UTC](https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100/2 "2024-08-06T13:30:34Z")

</div>

Hi Saga!

You’re not missing anything here - right now it is not possible to have an analytic pull from two different tables. Because of this, in general, you will need to architect your table data in accordance with which metrics and KPIs you would like to analyze.

That being said, you will have to add the “category” field to the time tracking table to do this, like you mentioned.

If you’d like, I can turn this thread into a product suggestion if you would want to request this as a feature?

---

<div class="post-metadata">

**Author:** ![paul.genoud](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@paul.genoud](https://community.tulip.co/u/paul.genoud)\
**Post date:** [August 9, 2024, 9:07am UTC](https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100/3 "2024-08-09T09:07:07Z")

</div>

Hi Beth,

From my point of view it is interesting to thread a product suggestion.  
For example I have this use case with two table linked together :

 ![Table example](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/c/c8aad6ecfaa04e519e33f9d5a525eadddf36a2b6.png)

And it could be useful to be able to make analytics on Product Table and to filter this analytics with inputs from the Order Table.

For example if I want a bar chart of the number of products filtered by due dates and brand, I need to access both tables datas.

Thanks !

---

<div class="post-metadata">

**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\
**Post date:** [August 9, 2024, 1:22pm UTC](https://community.tulip.co/t/create-analytic-that-can-access-two-tables/12100/4 "2024-08-09T13:22:21Z")

</div>

Thanks for your input here! Went ahead and made this into a Product Suggestion for our team to track and for other Community members to vote on!