Using an Advanced Function based on existing column advanced function

Peter Ruth shared this question 2 years ago
Answered

Hi,

We have a report where we're getting the count distinct plus the weighted average values. We want to get the Delta value between the 3 month period (example on column F).

Because the column is already using an advanced function we can't use the results to calculate using another advanced function or, use two advanced functions in the same column.

In the example below, we have columns A, B & C as output from the database.Column D is the count distinct plus weighted average of column C.

How do we get to column F using the advanced function "Delta From Last N" please.

/c4f0cd1847f3fde473d90de91bcff9b1

Kind regards,

Peter

Replies (2)

photo
1

Hi Simon,

Thanks for the quick reply.

We had found this function and tried a variety of selections, but it needs to be applied to the weighted moving average results (column D), which we can't see how to do. Also we don't want the percentage, just a simple subtraction.

These are the results using your suggestion and various options:

#1. This is count distinct aggregation with Delta For Last N = 3 (not using percentage) .I'm not sure where the displayed delta figure comes from as if it's added or subtracted, the answer is not in either of the rows to the left.

/5d68c9a13474d3281acb8f0247f7e25f

#2. Using your example settings

/c8f4ba0a609da9b991833ce8314f4be8


Without the percentage formatting:/4e5eefbdd40ae17ada11c592f8481e91

In each of the above examples the values in the Delta column do not match my original example results.

Kind regards,

Peter

photo
1

Hi Simon,

It was weird but I noticed your reply above mine. We're working on a Pre-Defined function at the moment which could be OK, if not we'll go down the path of the Advanced Function.

Thanks for your assistance.

Kind regards,Peter

Leave a Comment
 
Attach a file