# Count operations by month **URL:** \ **Category:** Ask for Help\ **Created:** [March 5, 2024, 2:31am UTC](https://community.glideapps.com/t/count-operations-by-month/71414 "2024-03-05T02:31:23Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [March 5, 2024, 2:31am UTC](https://community.glideapps.com/t/count-operations-by-month/71414/1 "2024-03-05T02:31:23Z")
I have a table where sales (operations) are recorded. In each entry, I record the date, and I also have a column of type math(date) that puts the month number. Then I have another table called dashboard. In it, I have a column of type joined list where all the months are listed like this: 12,12,01,05,10… What I need is a column that counts the number of times the number 12 appears (for December) and likewise for all the months. That way, I can draw a report of how many sales there are per month. How can I do it? ---
**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:** [March 5, 2024, 2:53am UTC](https://community.glideapps.com/t/count-operations-by-month/71414/2 "2024-03-05T02:53:58Z")
Change your joined list to an array using a split text column. Relate that to your month numbers. Do a rollup through that relation. ---
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [March 5, 2024, 12:37pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/3 "2024-03-05T12:37:29Z")
How can I count the number of time that each number appears in this column? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f23ce7c9be2b93504fd43bbb33155e6037545111.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 12:55pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/4 "2024-03-05T12:55:00Z")
Just Multiple Relation from month to itself and count thru this relation ---
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [March 5, 2024, 1:26pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/5 "2024-03-05T13:26:25Z")
but I need to count for each month not total of all months I need sometime like this: Count where Month = 12 Then I will get the total of operations of december ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 1:30pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/6 "2024-03-05T13:30:10Z")
It exactly gives to you count of December. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 1:31pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/7 "2024-03-05T13:31:47Z")
And why you don’t follow Darrens suggestion? ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 1:40pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/8 "2024-03-05T13:40:02Z")
Usually, i do like this: I have Dictionary table of months In this table i have multiple relation to the operations table and i have rollup count thru this relation. In a dashboard i have collection sourced from month dictionary table and filtered if month is included in lookup from operation table So, i have only month which appeared in operations also i have count of month’s operations. ---
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [March 5, 2024, 2:18pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/9 "2024-03-05T14:18:24Z")
How do you relate the operations table to the dictionary? This is my dictionary table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4366661f2c1b6cb0a6c46c9d576cd1096542c4c.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 2:21pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/10 "2024-03-05T14:21:02Z")
Create Multiple relation from Month number to operation table in which math column: Month(operationDate) Usually i creating not only Operation date column also i write Math Year(NOW)\*100+Month(NOW) and later use it for addressing YEARMONTH 202403 also you can write Month(now). Relation to Numeric Month or Numeric YEARMONTH much more faster, compared to relation to Calculated column. ---
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [March 5, 2024, 2:37pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/11 "2024-03-05T14:37:16Z")
Great! But how I filter this by dates (From and to) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39e4516f816b16786db3e37683f151cd2e51af5f.jpeg) The “Operaciones por mes” Chart is the one for the operations by month ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/3417611ecb9d70f9ffd3465c63727fb1dd74ebee.jpeg) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [March 5, 2024, 2:45pm UTC](https://community.glideapps.com/t/count-operations-by-month/71414/12 "2024-03-05T14:45:35Z")
Use query for source for Total QUERY with operation date is on of after start and operation date is on or before End But usually, i use YYYYMMDD as Numeric from Math Year(opDate)\*10000+Month(opDate)\*100+Day(opDate) instead common Date. Oh, no, for total of course. If you want to filter Operation per month according start and end date and keep looks, so you need use Query in DICT Month Table instead relation and add to it dates filter. But i little bit misunderstand reason to filter Operation per month chart by dates…