# I want create dashboard of sales POS **URL:** \ **Category:** Ask for Help\ **Created:** [November 20, 2024, 8:24am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055 "2024-11-20T08:24:12Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 20, 2024, 8:24am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/1 "2024-11-20T08:24:12Z")
"I want to know how to create a dashboard that includes all sales of point-of-sale devices. Also, I would like to know how to set a date range, for example: sales from November 1st to December 1st. If there are any other tips, please share. Thank you. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 20, 2024, 3:11pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/2 "2024-11-20T15:11:32Z")
For filtering by date, add two date pickers where users can select a start and end date. Then set up a filter for your sales list, so it only shows transactions within that range. Glide makes it straightforward to configure, so you don’t need to code anything. If you want to go further, you can add extras like sorting options, search functionality, or even actions to highlight high-value sales. Let me know if you get stuck or need a tip for a specific feature. ---
**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, 2024, 12:54am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/3 "2024-11-21T00:54:23Z")
Do what Maxime suggested, but make sure you write them to user-specific columns so people don’t overwrite others’ inputs. I would suggest you then convert them to two numeric values through math columns: Start Date: ```auto MAX(-0+0+YEAR(D)*10^4+MONTH(D)*10^2+DAY(D),0) ``` With D being the Start Date. End Date: ```auto MAX(-0+0+YEAR(D)*10^4+MONTH(D)*10^2+DAY(D),(-0+0+1-SIGN(D))*99999999) ``` With D being the End Date. The reason I use two complicated formula is because I want the formula default to 0 for Start, and 99999999 for End when the actual dates are not presented. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce56c0a4a3191590fddefea79686c4f9db1bff6f.png) When you have a value, it goes like this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80759453da8192312cde9f8897b459aa9f3d5a8d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f939affbca7352f6ef779d36b65c3ef77d9dc1a.png) You can then use filters/queries based on those math values. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 21, 2024, 2:02am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/4 "2024-11-21T02:02:51Z")
> [@ThinhDinh](#): > > Do what Maxime suggested, but make sure you write them to user-specific columns so people don’t overwrite others’ inputs. I mean, if he uses row owners in you users table (hoping so since it is a POS), it doesn’t really matter, but you are right. We should always set these type of data as user-specific columns! Thanks partner. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 21, 2024, 3:33am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/5 "2024-11-21T03:33:34Z")
@ThinhDinh Smart math! I had been doing that with a series of if-then-else columns. Math is much more elegant. ---
**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:** [November 21, 2024, 3:35am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/6 "2024-11-21T03:35:27Z")
> [@ThinhDinh](#): > > The reason I use two complicated formula is because I want the formula default to 0 for Start, and 99999999 for End when the actual dates are not presented. Very clever! 👍 ---
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 21, 2024, 9:33am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/7 "2024-11-21T09:33:24Z")
Can you explain it to me more clearly? I am new to the platform and would like to understand it better. Thank you." ---
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 21, 2024, 9:38am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/8 "2024-11-21T09:38:38Z")
"I need a clearer explanation, please. Thank you." ---
**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, 2024, 12:24am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/9 "2024-11-22T00:24:21Z")
Not sure what you need more. Have you tried applying the columns I noted above? ---
**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, 2024, 12:24am UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/10 "2024-11-22T00:24:45Z")
Thanks Darren & @Robert_Petitto , SIGN really comes nicely into some math formulas. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 23, 2024, 12:50pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/11 "2024-11-23T12:50:17Z")
> [@ThinhDinh](#): > > `-0+0+` Why is that required? ---
**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 23, 2024, 2:40pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/12 "2024-11-23T14:40:01Z")
`YEAR(D)*10^4+MONTH(D)*10^2+DAY(D)` is empty if D is empty, -0+0 forces it to become 0. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 23, 2024, 3:21pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/13 "2024-11-23T15:21:03Z")
I thought about that but I wanted to confirm 🙂 thanks! ---
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 24, 2024, 12:14pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/14 "2024-11-24T12:14:05Z")
Am I doing it the right way? Or what should I do? ![‏لقطة الشاشة ١٤٤٦-٠٥-٢٢ في ٣.٠٦.٥٠ م](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f78cade7a1e6bc44a826c5542ee0eb97925044ff.png) ![‏لقطة الشاشة ١٤٤٦-٠٥-٢٢ في ٣.٠٦.٥٧ م](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b349468299a9aad7aeaa1ff09fdf4ac7e91551be.png) ---
**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 24, 2024, 12:30pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/15 "2024-11-24T12:30:43Z")
What does the “TrxDate” column do? ---
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 24, 2024, 12:36pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/17 "2024-11-24T12:36:54Z")
This date comes with the data from the POS device the date of the purchase transaction ---
**Author:** ![Abdulrahman\_Alhamran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdulrahman_alhamran/32/82422_2.png) [@Abdulrahman\_Alhamran](https://community.glideapps.com/u/Abdulrahman_Alhamran)\ **Post date:** [November 24, 2024, 1:22pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/18 "2024-11-24T13:22:51Z")
I have this dashboard in Excel. I want filters like the ones on the left: Date: From - To Product code Number Terminal Code Number ![‏لقطة الشاشة ١٤٤٦-٠٥-٢٢ في ٤.١٨.٢٥ م](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/9/89ea773ca7cf12016c3cfa8829453f2d0b4fb09b.png) ---
**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 24, 2024, 2:56pm UTC](https://community.glideapps.com/t/i-want-create-dashboard-of-sales-pos/78055/19 "2024-11-24T14:56:48Z")
You have to add two user-specific columns where you store the filters. Then use my method to convert those to numbers. In the actual sales data, add another math column to calculate the numeric version of your “TrxDate”. Then use either the collection’s filter or a query column to do this: “TrxDate Number” is greater than or equal to “Start Date Number” AND “TrxDate Number” is less than or equal to “End Date Number”