Data slices in the QM
Hi all!
There is a flat table of sales records with the fields: [Date, Quarter, Salesman, Region, Product, NumCustomers, Net Sales, ProfitOrLoss]. The values of the Net Sales and ProfitOrLoss fields are assigned for analysis. The list of products sold consists of three names: [FastCar, RapidZoo, SuperGlue]. First, you need to build two reports for the Net Sales field. Report 1 (R1) is the total revenue by months and years. Report 2 (R2) is a summary of revenue by years and for the company as a whole for two years. As everyone knows, this is an elementary task. But here’s what makes it harder: reports R1 and R2 must be parameterized by Product slices. Here’s what I mean:
*
*
*
Does anyone know, if it is possible to mimic data slices in QM? Yes or No?
Good luck
FYI.
Starting from version 2022.2.0, the use of new QM’s feature – check-boxed boolean constrained input – will allow you not to use canvas switches. Slicers become fully scalable without any manual manipulation of the canvas elements.