Line chart

In the Sales database, create a Line chart to compare the sales of a particular product this year compared to last year.

1. Prepare the data in the grid: In Period mode, select the Product dimension, then select and focus on the top ten products (highest sales). Select Period > Rolling 12 months, then click the Summary button to view the total of the selected products across the period.

2. Click the Chart button in the top right toolbar above the grid.

3. Click the Line chart category button on the left of the chart and select the Line option.

   

   The lines in the chart depict the current and previous values. You can see that the selected products are selling better in almost every month this year (blue) compared to last year (red).

   
4. (Optional) Select the Use cumulative option to chart current vs. previous cumulative for each time unit, rather than simply current vs. previous.

   

If you create a working day calendar in Phocas and select a day period type in the grid, you can apply a working day calendar to the Line chart.

For example, suppose your business operates from Tuesday to Saturday each week. Sunday and Monday are non-working days.

When you look at the data over a week, you see troughs on Sundays and Mondays where the values are 0 (expected), as illustrated by the highlighted areas in the image on the left below. You might prefer to show only working days (exclude non-working days) in the chart, to more accurately reflect what’s going on. In the image on the right below, you can see the data trend more clearly when Sundays and Mondays are removed from the chart.

In the Sales database, create a Line chart to compare the revenue earned in December this year compared to December last year.

1. In Period mode, Summary view, select a day type of period from the Period menu.

2. Click the Chart button in the top right toolbar above the grid.

3. Click the Line chart category button on the left of the chart and select the Line option.

4. Select Filter by calendar and select the required calendar, such as Working Days, then click out of the box to apply your change. The chart updates to only display data for the working days.