# Data from current day

**URL:** <https://community.glideapps.com/t/data-from-current-day/12390>\
**Category:** Ask for Help\
**Created:** [July 13, 2020, 5:37am UTC](https://community.glideapps.com/t/data-from-current-day/12390 "2020-07-13T05:37:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\
**Post date:** [July 13, 2020, 5:37am UTC](https://community.glideapps.com/t/data-from-current-day/12390/1 "2020-07-13T05:37:34Z")

</div>

hello guys,

I would like to display as details “title” component a data sum that is for that current day. ie. Todays revenue. Any suggestions?

Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 13, 2020, 8:52am UTC](https://community.glideapps.com/t/data-from-current-day/12390/2 "2020-07-13T08:52:51Z")

</div>

Do you only need to show today’s numbers or do you need other days as well?

---

<div class="post-metadata">

**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\
**Post date:** [July 13, 2020, 1:05pm UTC](https://community.glideapps.com/t/data-from-current-day/12390/3 "2020-07-13T13:05:24Z")

</div>

Today’s data is good enough. but other dates are also nice, for example last three days…

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 13, 2020, 2:13pm UTC](https://community.glideapps.com/t/data-from-current-day/12390/4 "2020-07-13T14:13:09Z")

</div>

Make an arrayformula in your sheet that would determine the type of date your record is e.g “Today”, “Last 3 days”, “Last week” etc. then do a relation - rollup to return the sum.

---

<div class="post-metadata">

**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\
**Post date:** [July 14, 2020, 5:37am UTC](https://community.glideapps.com/t/data-from-current-day/12390/5 "2020-07-14T05:37:30Z")

</div>

I didn’t quite get the relation and rollup functions. How do they work?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 14, 2020, 3:41pm UTC](https://community.glideapps.com/t/data-from-current-day/12390/6 "2020-07-14T15:41:07Z")

</div>

Make a relation matching the “type of date” to itself and set it to match multiple so you now have a group of all your records with the same type, then have a sum rollup over that relation. It’s like a sum of multiple matches using VLOOKUP.