Set Analysis question

ManuelLindekeit — Mon, 08 Jun 2020 19:20:18 GMT

Hi experts,

I'm looking to get sales from Day 1 of the month we were in 3 months ago to date.

Solution 1. accomplishes this. But I see other developers using a solution 2. approach. Which one would you use and what is the difference?

1. Sum({<[Date]={">=$(=date(monthstart(addmonths(today(),-3))))"}>}[OrderLines.Net Order Amount])

2. sum({<OrderID = {"=([Date]>= $(=date(monthstart(addmonths(today(),-3))))"}>}OrderLines.Net Order Amount)

Re: Set Analysis question

sunny_talwar — Mon, 08 Jun 2020 19:39:42 GMT

I would use option 1 over option 2 where you are checking at the chart level to keep only those rows where Date is greater than the 3 months back. The second option goes by OrderID and check if the condition is met or not. There are times when you cannot use Option 1, is when I would use Option 2.

topic Set Analysis question in App Development

Set Analysis question

Re: Set Analysis question