/
Monthly Graphs - Inventory Turnover

Monthly Graphs - Inventory Turnover

Owned by Jerome Ellos
Last updated: Jan 19, 2024 by Albert Saludaga
1 min read

This report displays the trend of orders by month and year.

Report Definition

  1. Author

    1. Jerome Ellos (Full Scale developer)

  2. Presentation Medium

    1. SSRS Portal

  3. Fields (data)

    1. Year

    2. Month

    3. Turnover

Calculations

Column Name

Data Type

Calculation

Column Name

Data Type

Calculation

Turnover

decimal

avg(SoldQuantity)

Data Sources

The main data source will be the Tableau_TB_SalesView view in the eiboxoffice database (192.168.10.215).

Data Set

Data Set

 Query

Description

Data Set

 Query

Description

1

dsTurnover

select MonthYear ,Year ,Month ,DateName( month , DateAdd( month , v.Month , -1 ) ) as MonthName ,cast(AVG(Sold) as decimal(9,2)) as [TurnOver] FROM ( select concat(DATENAME(month,InvoiceDate),' ',year(InvoiceDate)) as MonthYear ,year(InvoiceDate) as Year ,month(InvoiceDate) as Month ,SoldQuantity as Sold from Tableau_TB_Salesview WITH (NOLOCK) where InvoiceDate >= CONCAT(MONTH(DATEADD(year,-4,GETDATE())),'/1/',YEAR(DATEADD(YEAR,-4,GETDATE()))) AND InvoiceDate <= GETDATE() AND IsCancelled = 0 AND IsExpired = 0 ) v GROUP BY MonthYear ,Year ,Month ORDER BY Year ,Month

This gets the average sold quantity of tickets for the past 4 years.

 

Related content