Dundas Calculation

#1

Hello, Good Day…

We have a requirement to calculate Year to Year calculation for the below data set
CQ - Current Year Qtr
PYCQ - Previous Year Qtr

QTR_Code Rev $ ID

CQ 150 P101
CQ 50 P102
CQ 0 P103
PYCQ 20 P104
PYCQ 70 P104
PYCQ 10 P103
Y2Y Rev = (Current Year Qtr of sum(Rev$) - Previous Year Qtr of Sum(Rev$) for PYCQ) / Previous Year of Sum(Rev$) for PYCQ * 100
= (200 - 100)/100 * 100
Y2Y ID = (Current Year Qtr of count(ID) - Previous Year Qtr of count distinct (ID)) / Previous Year of count distinct (ID) * 100
= (3 -2)/2 * 100
Could we know, how to calculate Y2Y using Dundas Cube or in Metric Set?

#2

You can make use of the calculated element transform in the data cube which allows you create new elements by writing DundasScript expressions.

Please see article below for details.

https://www.dundas.com/Support/learning/documentation/cleanse-consolidate-modify-data/transforms/common/calculated-element

Alternatively, you can also make use of formulas to achieve the required result.

Please see article below for details.

https://www.dundas.com/support/learning/documentation/analyze-data/formulas/adding-formulas

However, if further assistance is required, you would need to contact Dundas Support (support@dundas.com) with a screenshot of your datacube and input elements or metric set.

#3

Thank you, Olukayode for your quick reply.
I have tried both the calculation using Data Cube calculation

  1. The Y2Y Rev working successfully and matching with the database since it has a summation of Rev$.
  2. In the case, Y2Y ID is not matching with the database since it has a count distinct of ID.

I am facing issue in the aggregation of count distinct of ID.

Thanks,
Rajkumar

#4

This inquiry is currently being resolved offline by the Dundas Support Team. We will post the solution when it is available.