# Creating a Presence Report **URL:** \ **Category:** Get Help\ **Created:** [March 3, 2023, 6:34pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094 "2023-03-03T18:34:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [March 3, 2023, 6:34pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/1 "2023-03-03T18:34:42Z")
So, I need to organize presence in my company meetings. I created, in google sheets just to organize myself, a sheet where rows = users and columns = meetings and then each cell gained a color according to the status of that user in the meeting (green = present; light red = informed absent; and darker red = non-informed absent / disconsider black and blue) ![Captura de Tela 2023-03-03 às 15.29.16](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2781ad13c7dc67e44f89a29d1b475dc84b09087f.png) On Fibery, I have a users database (all guests) and a meetings database. In every meeting I have there are three relations-field to users (presents, informed absents and non-informed absents). So, what I wanted to do is generate this sheet I have manually produced in Google Sheets in a report on Fibery! That’s possible right? How? Thanks! ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [March 6, 2023, 4:53pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/2 "2023-03-06T16:53:45Z")
Hi! I think to create a report like this, we will need an auxiliary database, that stores Users Status - because we don’t have Matrix View and can imitate with Board, I think ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0bc1cea5d95e2f8c4844ac2c1a07e376808b0dfb.png) But I wonder - why imitate this table in Fibery? And how the report has to look like? Do you meed to see % of accepted and visited meetings? Or smth else? ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [March 6, 2023, 7:38pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/3 "2023-03-06T19:38:33Z")
Hi @Polina_Zenevich My aim with this report is to have a global view of the presence of people in the meetings. I work with a lot of volunteer people, and I’ve noticed a pattern that when a person has 3 non-informed absents, they are probably going to leave the project… And to do it manually is quite exhausting. So, since we are always putting this information in Fibery, I thought Fibery could automatically create something like that table. I’m not sure if I know what is a Matrix View… ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [March 15, 2023, 6:43pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/4 "2023-03-15T18:43:02Z")
> [@gomocoop](#): > > absents Hi again! I was thinking on your case, and what if instead we could have such a report? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/6761059215a1519c6e9d3a6d278e4ef972aa3bbc.png) Om a weekly/monthly basis, we can check how many meetings the user attended, and how many not (across the ones he was expected to come) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [March 16, 2023, 10:14am UTC](https://community.fibery.io/t/creating-a-presence-report/4094/5 "2023-03-16T10:14:42Z")
You could also use a formula in the report to calculate a running count of uninformed absences (maybe even with a date condition of last three weeks or similar) you could have a chart that shows the users who are increasing in risk of dropping out. ---
**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\ **Post date:** [March 28, 2023, 1:26pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/6 "2023-03-28T13:26:22Z")
Hi @Polina_Zenevich , That could be really interesting. How was this created? Like what features in which places (column, row…)? ---
**Author:** ![Kseniya\_Piotuh](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/kseniya_piotuh/32/6501_2.png) [@Kseniya\_Piotuh](https://community.fibery.io/u/Kseniya_Piotuh)\ **Post date:** [April 4, 2023, 4:08pm UTC](https://community.fibery.io/t/creating-a-presence-report/4094/7 "2023-04-04T16:08:48Z")
Hi @gomocoop, Please have a look at this video — hopefully, it helps you set up the report that Polina shared earlier 🙂 [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/c2d9b2d6bf2b431782799a717c066f38)