# Filtrar datos en graficos por mes

**URL:** <https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968>\
**Category:** Ask for Help\
**Created:** [November 20, 2023, 12:18pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968 "2023-11-20T12:18:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![RodrigoLagos](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@RodrigoLagos](https://community.glideapps.com/u/RodrigoLagos)\
**Post date:** [November 20, 2023, 12:18pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/1 "2023-11-20T12:18:37Z")

</div>

Mi duda es la siguinete:  
Tengo un APP de gestion de proyectos, en donde se asignan, autores, fecha de termino areas, descripciones de la tarea, estado entre otras cosas, mi problema va principalmente en el dashboard para gestionar avances.

Requiero hacer un Tablero que pueda filtrar con condicionantes, 1ero que el estatus de la tarea este finalizada y 2do que corresponda al mes que quiero revisar.

Logre segregar los datos por area, me entrega solo las tareas finalizadas, pero no logro realizar un boton o un filtro que segrege la entrega de datos, segun el mes indicado.

---

<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:** [November 20, 2023, 11:33pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/2 "2023-11-20T23:33:27Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb135c1332dc5c5f20444a735a3ef08cacfac6e0.png)

Have you tried using in-app filters for your collection?

---

<div class="post-metadata">

**Author:** ![RodrigoLagos](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@RodrigoLagos](https://community.glideapps.com/u/RodrigoLagos)\
**Post date:** [November 20, 2023, 11:55pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/3 "2023-11-20T23:55:20Z")

</div>

De que forma transformas las fechas ingresadas en meses, para poder filtrar?

Buscaba una forma de tener en la parte superior un botón de selección, en la cual estén todos los meses y me filtre la totalidad de gráficos en dicho movimiento.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [November 21, 2023, 12:03am UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/4 "2023-11-21T00:03:18Z")

</div>

Hola Rodrigo,

Tendrías que crear otra columna donde estén transformadas tus fechas en el formato que te convenga.

El plugin **Format Date** puede servirte  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52586eed309432f6112bdec03d61686884214abf.png)

Saludos!

---

<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:** [November 21, 2023, 12:52am UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/5 "2023-11-21T00:52:52Z")

</div>

Format Date can bring issues in iOS. An alternative is converting the date to a numerical month format using the Math column, then use a JavaScript column to map the month number to the correct name using an array of month names.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [November 21, 2023, 8:24pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/6 "2023-11-21T20:24:42Z")

</div>

> [@ThinhDinh](#):
>
> Format Date can bring issues in iOS

Do you know which version? Does it apply to older iOS versions or newer ones?

We’ve already discussed this issue before but I still can’t find the issue with iOS and I have tested with 3-4 versions.  
Of course, an old version can create a lot of headaches and for example, version 12.x can no longer load any Glide APP (not Classic ones).

Saludos Thinh!

---

<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:** [November 22, 2023, 11:18pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/7 "2023-11-22T23:18:22Z")

</div>

> [@gvalero](#):
>
> Do you know which version? Does it apply to older iOS versions or newer ones?

It has always been a problem for me, and @Darren_Murphy as well. It might have something to do with our locale format of dates, seems like Safari doesn’t like it, I have seen this issue happening to an EU user before as well.

---

<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:** [November 29, 2023, 11:19pm UTC](https://community.glideapps.com/t/filtrar-datos-en-graficos-por-mes/67968/8 "2023-11-29T23:19:12Z")

</div>

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