Monthly value at week level

[Anonymous]

Hi All,

I have a requirement to represent the weekly value( Value) at month level.

What i have done is , i have performed a Group by at the month level to get the monthly level Value(in the script).

But the challenge is to represent the monthly value at the Week level.( Image2), without using the Month, in the dimensions , because it messes up my other KPI's

So far I'm only able to represent it month wise( Image1)

As shown in  image2

Week 18- Week 22-  Month1

Week 23- Week 26 -  Month 2

Week 27- Week 31- Month 3

Anyway I can get the Monthly value at week level?

Thanks in advance for your time and help.

[Anonymous]

Hi,

You can divide number of weeks in a month to convert monthly value into weekly. For example,

TableA:

Load

     Month,

     Monthly_Value

From <Table1>

Left Join

Load

     Month,

     Week

From <Table2>

TableB:

Load

     Month,

     Sum(Monthly_Value)/Count(Week) as Weekly_Value

Resident TableA

Group by Month;

[parthiband]

Sorry,

I need u to explain a bit more clearly.

U r having data in week level.

U want to show in month level or week level?

If week/Month, how u want it to get displayed?

[Anonymous]

Hi Parthiban & Satyadev

I have the value at both month level and week level.

But the problem is  I want to represent the month level data at week level.

To make it more clear.

Please see Image-3

Here 382,250 represents month1 value( Month 1 comprises of W44 to W48)

406950 represents month 2 value (W49 to W52).

Thanks again for your time.

[parthiband]

Hi Rajagopal,

If my assumption is right about your requirement, there's nothing to do with your data model whereas tricks will make it work.

Please find the attachment.

I'd did an sample based on my understanding.

Please revert me back if am wrong

[Anonymous]

Hi Parthiban,

Thanks a lot. I'm trying it out now. Will let you know if it worked.