Skip to main content

Applying filters and it's benefits

    Above screenshot showing filtered cities of customers only in Bangladesh


   Above SC showing the filter options after selecting the column 3 having 'Customer City'

To apply the filter you have to select your desired column, and it will pop up a small box from where at first all the options will be selected but you can deselect it all and then start selecting your required information. So from the process of my filtering of cities I have found out the customers living specifically in Bangladesh, out of the 30 customers in my database.

Benefits of applying filter:

Saves time from trying to search from a larger database.

Serving a customer regarding information about anything in the database will be much easier and faster.

 Above screenshot showing the box pop-up after clicking column 12

Above screenshot showing off sales on October 2018

So after applying filter on the column 12, I could filter out the customers I have served on a particular date, which on my case is October 2018. From the 30 customers I started putting data of customers from August, September and October. My concern was to look at the customers who were served on October and the filter function has given me quiet a easy way to have a quick look at them.

With this filtering function you can scan out customer or a certain product information in few mins where as it could have taken you a couple of hours. Obviously my database of 30 customers is not that big but a database consisting of thousand will surely need filtering out to ease out the difficulty of finding a certain information.

Comments

Popular posts from this blog

Converting Database Spreadsheet into Tabular Database Spreadsheet

  Screenshot of my Tabular Database spreadsheet: After deciding the right design from the 'Format as table' layouts, I have formatted my database spreadsheet into a Tabular Database. The process of converting a database to a table format is simple: ^From the above screenshot you can see all the different types of layout available to choose from. So after finishing your database you will click 'Format as table' and select one of your choice and it will be applied immediately.

Adjustment of Font size to properly understand content

Screenshot of my website homepage in wix Mobile Version from wix.com I adjusted the size of the title name of my website homepage 'Ded2tech' in the mobile version. The problem was the whole name was split up and 'Tech' was underneath 'Ded2'. The font size was 66 which i changed to 42 to re-scale it into fitting in the gap and now my customers will be available to see the name as a single word. This testing was done from my mobile phone , device name: Samsung S8 plus. This is one of the many adjustments I did in the mobile version. Also there were problem in the product feature section where the icon and description was not properly structured which i fixed later on. Screenshot of my 'Support page' from wix.com The font size of the 'Contact Available 24/7' was small enough for me, where I do not have any eye sight problems. This content is very important for my business. If customers are not able to know this content of my website ...

Logo for my business website

Screenshot : Logo completed and in download screen of  https://www.freelogodesign.org / Screenshot : Completed logo in edit screen Screenshot: My website dashboard logo settings screen Screenshot: My website business logo I have just completed my business logo from a site name Free logo design. Site url: https://www.freelogodesign.org/  . To set up my custom made logo from the free logo site I selected from Wix dashboard settings then selected add custom logo. The screenshot above will show you the website I have designed my logo and then how I have selected my website logo in Wix dashboard settings. A logo symbolize a business banner and people will know you by that. Everyone should think critically before adding a logo. My logo symbolizes 3 wires connecting into ports which means my business will connect customers with my products and so I hope it makes sense into the people who will be looking onto my this post. If i make any changes on near f...