# Big numbers

**URL:** https://community.glideapps.com/t/big-numbers/36495
**Category:** Ask for Help
**Created:** [December 30, 2021, 11:14am UTC](https://community.glideapps.com/t/big-numbers/36495 "2021-12-30T11:14:14Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Ferdinando\_Fogacci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ferdinando_fogacci/32/36482_2.png) [@Ferdinando\_Fogacci](https://community.glideapps.com/u/Ferdinando_Fogacci)
#### Post date: [December 30, 2021, 11:14am UTC](https://community.glideapps.com/t/big-numbers/36495/1 "2021-12-30T11:14:14Z")

</div>

I have one column with “inspection performed” and “inspection not performed” it is possible to extract statistics where I have the number of “inspections performed” and “not performed” with the big numbers function

---

<div class="post-metadata">

### Author: ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [December 31, 2021, 11:24am UTC](https://community.glideapps.com/t/big-numbers/36495/2 "2021-12-31T11:24:56Z")

</div>

Big numbers are used to display data. This mean you’ve to calculate your statistical before, into the data editor of course.

The technique for achieving this is as follows:

1. have a multiple relation that points to the rows where the data you are interested in is present
2. add a Rollup column that points to the multiple relation (Summarize the values ​​of) and choose the type of calculation to perform (By calculating the), it can be a sum, an average, a count … etc.
3. at this point you will be able to use the result of the rollup column in your bignumber component.

Take a look here: [Rollup Column - Glide Library](https://docs.glideapps.com/all/topics/computed-columns/primary/rollup)  
and let me know if yo need more help.  
Ciao!

---

<div class="post-metadata">

### Author: ![Ferdinando\_Fogacci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ferdinando_fogacci/32/36482_2.png) [@Ferdinando\_Fogacci](https://community.glideapps.com/u/Ferdinando_Fogacci)
#### Post date: [January 3, 2022, 1:56pm UTC](https://community.glideapps.com/t/big-numbers/36495/3 "2022-01-03T13:56:22Z")

</div>

@Roldy sono riuscito a calcolare dei totali ma non riesco ad estrapolare dei numeri dalla colonna con diversi risultati.  
Ad esempio ho la colonna province e ho 5 richieste 2 da Milano e le altre da altre province…non riesco a calcolare quante sono da Milano e dalle altre ma solo il totale cioè 5

---

<div class="post-metadata">

### Author: ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [January 4, 2022, 1:18am UTC](https://community.glideapps.com/t/big-numbers/36495/4 "2022-01-04T01:18:11Z")

</div>

Questo si ottiene con la definizione di due tabelle: nella prima definisci tutte le province possibili, nell’altra ci sono i dati da totalizzare nella prima.

Esempio.

Tabella 1 Province  
(colonna provincia)  
Mi  
Fi  
Pg

Tabella 2 Dati (colonna provincia e poi altri dati provenienti dal form)  
Mi  
Mi  
Fi  
Pg  
Fi  
Mi

Ora, se tu definisci una relazione multipla fra la colonna provincia della tabella 1 e la colonna provincia della tabella 2, puoi definire una colonna rollup-count nella tabella 1 ed ottenere quindi:  
Mi 3  
Fi 2  
Pg 1

Questo era per ottenere i totali per provincia. Ora tuttavia il problema successivo è che la quantità di totali che ottieni non puoi conoscerla a priori e quindi non puoi visualizzarla in una componente bignumber. Ti ci vuole una lista per visualizzare la tabella 1.

---

<div class="post-metadata">

### Author: ![Ferdinando\_Fogacci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ferdinando_fogacci/32/36482_2.png) [@Ferdinando\_Fogacci](https://community.glideapps.com/u/Ferdinando_Fogacci)
#### Post date: [January 4, 2022, 3:39pm UTC](https://community.glideapps.com/t/big-numbers/36495/5 "2022-01-04T15:39:57Z")

</div>

@Roldy grazie mille ci sono riuscito 😀

---

<div class="post-metadata">

### Author: ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [January 4, 2022, 3:52pm UTC](https://community.glideapps.com/t/big-numbers/36495/6 "2022-01-04T15:52:04Z")

</div>

Ottimo

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [January 5, 2022, 3:52pm UTC](https://community.glideapps.com/t/big-numbers/36495/7 "2022-01-05T15:52:42Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
