Custom Views in CAKE

This article will cover the following:

- How to create and edit custom views in reporting

Viewing Reports

To get started, access a report by:

1.) Selecting the main Reports tab at the top of the screen

2.) Then choose a master report on the left subtab menu (Affiliate, Advertiser, Offer.  In this example I've selected the master Offer report)

Customizing Reports

Now that you have a master report open, you'll see the Edit View icon in the top righthand corner of the screen.  Click that icon to get started customizing your report view.

Remove Columns

Remove Columns

To remove a column from a report, simply uncheck the box under the Display column in the righthand portion of the Edit View card.  As soon as you uncheck the Display checkbox, the report column is removed.

Reorder Columns

Reorder Columns

If you want columns to show up in a different order in the report you can reorder them by clicking and holding the Reorder Icon to the left of the label and dragging the label to the position that you want.

Rename Columns

Rename Columns

To rename a column heading double-click on the label in the column list and change to what you want.  Once complete, click Done and the column will reflect the new name.

Sort Report by Specific Column (Ascending and Descending)

Sort Report by Specific Column (Ascending and Descending)

If you'd like to have the report sort by a specific column, click to the far right of the column label and you'll see a green arrow appear.  If you'd like the report to sort ascending, click the arrow until it points up and if you'd like the column to sort descending, click until the arrow points down.

Set a Default Date Range

Set a Default Date Range

If you would like to set a default date range for the report you can do so by setting the Date Range dropdown to one of the preset ranges or you can set a specific start and end date.  NOTE: by setting a specific date the report will always show results for this date range by default until you change the date.

Resize Columns

Resize Columns

To resize column width hover over the right edge of the column heading in the report that you want to edit.  You will see an arrow appear.  At that point click and hold then drag the column edge to the right or left to expand or shrink the column.

Creating/Saving a New Custom View

Creating/Saving a New Custom View

Once you have your report customized the way you want you can save the view as a Custom View.  Click the Edit View icon in the top righthand corner of the report to get the Edit View card.  Now, click the Create New View button to save your report.  The Create New View card will now appear.  Fill in the details of your new view and click Save.

View Name: What your custom report view will be named.

Make Default: This will make this view the default view any time you view the report you are applying it to.  This is not recommended as if it is selected, this view is what you'll see every time you view this report.

Shared: If shared, this view will be available to all users of your instance.  If not shared, you will be the only user who can view utilize this view.

Export All Fields: This will cause hidden fields to be included when this report is exported.  If unchecked, only the visible fields will be exported.

Report Width: This allows you to set a custom width for the report.  Reports can have a width between 1,000 - 4,000 pixels.

Add a Custom Column

Add a Custom Column

You have the ability to add a custom column where you can perform calculations on values from other columns within the report.  To do that start by clicking the Edit View button.  Next, in the Edit View card, click the Add Column button which will result in a new column line.  Enter the name of the column you want to create and click Done.

After clicking Done the column will be created and the Formula card will appear where you'll enter the formula to calculate the new value.  Once you have the formula entered, click Save.  Next, in the Edit View card, click Update View to see the results in your report. 

Now that your custom column is in effect you are ready to view your report with your custom value.  However, if you ever need to change your formula, click the Edit View button then find your custom column in the column list on the far right.  You'll see that to the right of your custom column, there will be an Edit icon.  Click that icon and the Formula card will appear where you can update your formula.  Once done, click save and in the Edit View card, click Update View to see the results in your report.

0 Comments

Add your comment

E-Mail me when someone replies to this comment