Question Samuel Claiborne · Mar 6, 2017

The >/</= etc. operands in named filters are great... except they won't work with measures ('native' or calculated - and what a boon it would be if  they could work with both). 

 

Are there any plans to add this capability?

 

And are there any plans to have a 'named filter' control within widgets that would let you change the operand?

 

Thanks.

2
0 276
Question Samuel Claiborne · Dec 28, 2016

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.

I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])

This year Net Sales: AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.

3
0 413
Question Samuel Claiborne · Nov 9, 2016

Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.

I am looking to create a pivot table that will be used to drive a bar chart. The chart will have product classes across the bottom, and two bars per class: a calculated measure to derive Net Sales for the specified period last year, and a straight aggregation of a standard measure for the same period for this year. Ideally, this period can be chosen by the user via filters on the dashboard, and it could be week, month, or quarter. So, obviously, it's the calculated field (and perhaps the entire MDX query) I need help with.

4
0 595