Quick Start

Quick Start:

1. Launch logQL by double clicking “logQL.jar”.
2. Locate the Sample Dataset(Help > Quick Start).
3. Copy using Ctrl-C and paste it in Excel Ctrl-V.
4. Save this as account.xls (any folder)
5. Open the file in logQL:
• From the menu, select File > Open > Excel
• Select “…” and choose the file from (4)
• Click “OK”

Now you can try some queries.

1. To see how much money was spent from each account

SELECT account, out

To get a pie chart,

• From the menu, select Chart > Pie
• Click check box for “out”.
• Click “OK”
2. To check the day of week when the most money was spent

SELECT dayofweek(date), out

3. Why is most money spent on Wednesday

SELECT description, out WHERE dayofweek(date) = "Wednesday"

4. To check the day of week where money was spent on “Food”:

SELECT dayofweek(date), out WHERE account = "Food"

5. To check the break-up for account Food on Sunday

SELECT description, out WHERE account = "Food" and dayofweek(date) = "Sunday"

6. To see all the individual items

GREP date, description, out WHERE account = "Food" and dayofweek(date) = "Sunday"

7. To count how often you spend on cloths

SELECT count(*) WHERE tolowercase(account) = "cloths"