DateTime Grouping on the Column Cells of the Matrix
Hello,
I am going to ask if there will be a support for automatic grouping of the column cells of the matrix which are of the DateTime data type.
For example, think of that query.
Select SalesType,SalesDate,Count(*) as SalesCount From SalesTable
To put this query in a matrix, developer should go like this:
SalesType = RowCell
SalesDate = ColumnCell
SalesCount = DataCell
What if I want to see first the year of the sales and then the quarter as two ColumnCells?
Right now we can achieve this partly though a query like "Select SalesType, Year(SalesDate), Count(*) as SalesCount From SalesTable"
I am going to ask if there will be a support for automatic grouping of the column cells of the matrix which are of the DateTime data type.
For example, think of that query.
Select SalesType,SalesDate,Count(*) as SalesCount From SalesTable
To put this query in a matrix, developer should go like this:
SalesType = RowCell
SalesDate = ColumnCell
SalesCount = DataCell
What if I want to see first the year of the sales and then the quarter as two ColumnCells?
Right now we can achieve this partly though a query like "Select SalesType, Year(SalesDate), Count(*) as SalesCount From SalesTable"
Comments
That's right, your query should return two separate columns (year and quarter). Another way is to create two matrix columns and use expressions, for example:
[Table1.SalesDate].Year
[Table1.SalesDate].Month