# Financial data

**URL:** https://community.glideapps.com/t/financial-data/58791
**Category:** Ask for Help
**Created:** [March 5, 2023, 3:39pm UTC](https://community.glideapps.com/t/financial-data/58791 "2023-03-05T15:39:00Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [March 5, 2023, 9:40pm UTC](https://community.glideapps.com/t/financial-data/58791/4 "2023-03-05T21:40:29Z")

</div>

> [@ibrahim17](#):
>
> The data doesn’t shows up when I try to relate the items.

We would need screenshots of your setup to be able to troubleshoot the issue. Ideas you could explore:

- ~~Are the column types the same?~~ Column types need not be the same, mistake on my part.
- Is the data you are trying to relate actually exactly the same?

**General warning about dates**

You’ll notice below that I am relating YYYYMM (for example 202303) to YYYYMM. These are integers that are exactly the same. I usually try to relate integers, row IDs, values that will never changes and that are not ambiguous. Relating dates is best avoided, because they are more complicated than they seem. A date is actually a DateTime, with year, month, day, hour, minute, second and millisecond components. You could think that two dates are the same, but the time might be different, and it creates issues.

**Expenses table**

 ![Screenshot 2023-03-05 at 22.27.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfb9fc8e9a7ae8ab24173492a5f148d4dd17faba.jpeg)

Setup of the math column:

 ![Screenshot 2023-03-05 at 22.36.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6d18dbd4271e4fa8d71edf4e4198faf07110b13.png)

**Monthly report table**

 ![Screenshot 2023-03-05 at 22.36.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b151bc62340f5e6da470434ff071f46d23d1e10b.jpeg)

Setup of the relation column:

 ![Screenshot 2023-03-05 at 22.37.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c484c08adf68f6a8f599ca220aa8ef60c54ab56.png)

Setup of the rollup column:

 ![Screenshot 2023-03-05 at 22.38.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/357de45fb270833c2a3afb40dbe860b922d0483f.png)

**Layout editor**

- Collection component: I chose table. Opt for whatever collection style suits your project.
- Chart component: line, bar and radial are available natively in Glide. Should you need more options, you could have a look at [Quickchart](https://quickchart.io/).

 ![Screenshot 2023-03-05 at 22.30.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1edbd050c2f7f6a1c0f45b665eb47749a83afe98.jpeg)

---

_[View the full topic](https://community.glideapps.com/t/financial-data/58791)._