Calculation on changing Column Names

[gonhaddock]

Hi @sven-abx
I’ve anticipated a possible solution that covers all the mentioned bullets in your posts. As I interpreted, these are:

• Customized reporting column names

@sven-abx

How do I calculate the delta of the columns? Changes from 10 to 11 and 09 to 11 and 08 to 11 when the column names are changing and under the condition that the data is based on months?

• Nulls handling

@sven-abx

thanks for your reply. first i was thinking to do it the way you describe, but then i fiured out, that it is possible no sales happend in a month and this month is then missing.

• Calculate differentials on a monthly basis (or any other customised granularity)

@sven-abx

i want to calculate the changes (delta) in sales from 30, 60 and 90 days to today.

Comments:
I’ve divided the workflow in two parts: The upper section brings some raw retail transaction data from the last past 12 months. And also a design of your desired report granularity, numbered in months to reporting date.

There’s a small intermediate section that cares about report sorting for rows and columns.

The lower section iterates over the report item: populating the missed, and calculating the differentials. The applied method to calculate differences is based in ‘Moving Aggregated’ node functions as anticipated in my previous post.

All relevant nodes are highlighted in shaded grey. The workflow ends with two reports allowing you to compare the results. If you inspect on LOREM item row, you will realize how Null Handling is achieved.

Count Items Report:

Differentials Report:

BR

Financial _ Product Differentials from Retail – gonhaddock