Please enable JavaScript to view this site.

thankQ Help

Navigation: CUSTOM REPORTING > TQ Dashboard

Create a Dashboard

Scroll Prev Top Next More

1.Click User Defined Reports under Report Modules

TQDASH~1_img77

2.Click Report on the tool bar

3.Select Dashboard Designer

TQDASH~1_img78

4.Click OK to create a new dashboard

TQDASH~1_img79

5.Click the Data Source tab

6.Click Add Query

TQDASH~1_img80

7.Click the Run Query Builder button with Query selected

TQDASH~1_img81

8.Double click on a Table or View eg View_BatchDetailContactAndArchive

9.Click into the tick box beside the fields required

Payment Type

Payment Amount

Source Code

10.Enter Alias Names

11.Select the fields to Group and select Sorting Type

12.Select any Aggregates

TQDASH~1_img82

13.Click the Filter button

14.Click the + to Add a Filter

15.Select PaymentAmount

16.Select Is greater than or equal to

17.Enter 1

18.Click OK

TQDASH~1_img83

19.Click OK on Query Builder

20.Click Finish on Query Editor

TQDASH~1_img84

21.Click the Home tab

TQDASH~1_img85