# How to limit a Joined list **URL:** \ **Category:** Ask for Help\ **Created:** [May 12, 2021, 11:30pm UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727 "2021-05-12T23:30:50Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [May 12, 2021, 11:30pm UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/1 "2021-05-12T23:30:50Z")
I’m using the Joined List to chart (with [quickchart.io](http://quickchart.io)) values from a column where are stored data from users (last 60 days). I would like to offer the view of the last 7, 30 and 60 days. Is any simple method to limit in some way the rows kept by Joined list (that gather all the values/rows that are in the column)? Any Suggestion? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 12, 2021, 11:34pm UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/2 "2021-05-12T23:34:35Z")
Hey, have you tried using first an If Then Else column and after a join list? ---
**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:** [May 12, 2021, 11:38pm UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/3 "2021-05-12T23:38:14Z")
I think what @Lucas_Pires suggest is great. Create a column to calculate the difference in days between your record and now. Then use 3 ITE columns: for last 7 days, if difference less than or equal 7 then data, else null. Do the same for the other 2 ranges. Finally have 3 joined list columns linked to those 3 ITEs. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [May 12, 2021, 11:39pm UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/4 "2021-05-12T23:39:26Z")
Yes, this is simple and great! Thanks!! ---
**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\ **Post date:** [May 13, 2021, 1:42am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/5 "2021-05-13T01:42:34Z")
I did something similar that worked well. Date Sheet: Column 1: Type (Today, 7 days, 30 days) Column 2: Date (Today, Today - 7, Today - 30) Performance Sheet: 3 Single Value Columns for Today, 7 Days and 30 Days 1 ITE “Date”: If Date Viewed is on or after: Today + If Date Viewed is on or after \* 7 Days, Last 7 Days + If Date Viewed is on or after \* 30 days, Last 30 Days. Picker: User Specific Text Column (This is where your choice goes) 1 Single Value: “Performance Picker” 4 ITE: - IFToday: If “Date” is Today, Today - IF7Days: If “Date” is Last 7 Days, Last 7 Days + If Date is Today, Last 7 Days - IF30Days: if “Date” is Last 30 Days, Last 30 Days + If “Date” is Last 7 Days, Last 30 Days + If “Date” is Today, Last 30 Days - If “Performance Picker” is “IFToday”, True + If “Performance Picker” is IF7Days, True + If “Performance Picker” is IF30Days, True + If “Performance Picker” is empty, True My Chart then uses a Filter: IFTrue is True The reason I set it up this way is so that I can see all posts viewed Today, Last 7 Days and the Last 30 Days…but the Last 7 Days also includes posts seen Today and the Last 30 days includes all posts seen Today + Last 7 Days as well. Previously when I viewed Last 7 days, it excluded all viewed Today. And when I viewed Last 30 days, it excluded all viewed Today and Last 7 Days. ![Screen Shot 2021-05-12 at 9.40.39 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e59d5bd28f6fb9df1220298f75ab2bcfdc18a07b.png) ![Screen Shot 2021-05-12 at 9.40.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/004b2e221c3cb386a0d27fb7e35fccf45034fe52.png) ![Screen Shot 2021-05-12 at 9.41.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f4c501c3a4deb50ccf0fdcb38395ed173fd73767.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 13, 2021, 3:52am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/6 "2021-05-13T03:52:16Z")
> [@Joe\_Gabriele](#): > > The reason I set it up this way is so that I can see all posts viewed Today, Last 7 Days and the Last 30 Days…but the Last 7 Days also includes posts seen Today and the Last 30 days includes all posts seen Today + Last 7 Days as well. > > Previously when I viewed Last 7 days, it excluded all viewed Today. And when I viewed Last 30 days, it excluded all viewed Today and Last 7 Days. [timtoady](https://en.wikipedia.org/wiki/There%27s_more_than_one_way_to_do_it)!! I solved this challenge using a slightly different approach. I also have Today (Past 24 hours), Past 7 Days and Past 30 Days choices, but instead of writing the choice _labels_ into the User Specific column, I write a value - representing the number of minutes. So… - Past 24 Hours = 1440 - Past 7 Days = 10800 - Past 30 Days = 43200 Then in the table that contains all the rows I want filtered, I calculate the age of each record using a bit of date math: ![Screen Shot 2021-05-13 at 11.46.01 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d12d62941329fa515900230c5894c0e963c0aca.png) And so the if-then-else to determine which rows to filter simply compares the two numbers. If the row age (in minutes) is less than the user selection, it gets included. ![Screen Shot 2021-05-13 at 11.43.11 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/3272d148c5d0f064e44e3b15bac267d9ea30556d.png) ![Screen Shot 2021-05-13 at 11.51.26 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c4217fce20214bf77588a208a04f1a6c3755114.png) ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [May 15, 2021, 12:27am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/7 "2021-05-15T00:27:33Z")
…and is it possible to filter a joined list with values in the column related only to a specific user? ---
**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:** [May 15, 2021, 12:36am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/8 "2021-05-15T00:36:21Z")
You would have to do a relation as a source of the joined list. The relation would use the link as the user’s email/ID or something like that. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [May 15, 2021, 12:44am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/9 "2021-05-15T00:44:16Z")
yes, i’m trying with a relation to the email, but it doesn’t work. Maybe I’m missing something. ---
**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:** [May 15, 2021, 12:46am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/10 "2021-05-15T00:46:22Z")
Can you go into more details about what you’re trying to do? ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [May 15, 2021, 12:54am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/11 "2021-05-15T00:54:55Z")
Every day users fill up a row with some data. So I have multiple rows with different users each day. I would like to chart the data (one column + date) for each user. Joined list + Quickchart is perfect, but Joined list store all the data for each row (therefore mixing different users). ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 15, 2021, 2:37am UTC](https://community.glideapps.com/t/how-to-limit-a-joined-list/26727/12 "2021-05-15T02:37:52Z")
Like @ThinhDinh mentioned, assuming you have an email with that data, you should be able to create a relation to it using email and build your joined list from that relation.