"Time" Drill as Row Attribute with "Last Year Sales" as a me

[ArunKKK]

Hi,

In my report, I have the row attribute as "Year" off of the Time hierarchy, which can be drilled to Year->Quarter->Month->Week->Day.

I have a metric on the report as "Sales $" and "LY Sales $". First metric can be calculated easily. Problem is hot to build the second metric "Last Year Sales $". Specs are - depending on the row attribute drill level, apprpriate transformation needs to be applied, and that too dynamically.

Any tips or help will really be appreciated. ASAP response would greatly be appreciated.

Thanks,
ArunKKK

 

[nlim]

use dynamic transformations. This is not the forum to go through this advanced concept in detail. But you can learn about it quickly by trying the following if you have the tutorial project that ships with the software.

Open up the transformation called Last Year's. Look at how it is built. Then create a report with year, revenue and "Last Year's Revenue" on it. The last 2 items are metrics; you can search for them.

When you drill down from year to quarter, the 2nd metric resolves automatically to the right level depending on what you have on the row.

 

[JaC74]

Looks like you have your question answered. I am curious to see how you have your Week set up that you can drill from Month to Week. A week can spread across two months. For example, April 1st starts on a Thursday. If you defined your week to be, let's say, M - SUN, when you drill on April to weeks, you will get a week that fall in to both April and March. This would produce overstated data. Because of this we have implemented SplitWeeks for instances when a week does cross over two months. Just my curiosity that's all.