Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
my Problem is, that I only have one value per Year. Now i need one value per month (where this is only YearValue/12 for each Month).
Sure, I simply can do a
YearValue/12 as MonthValue
but i dont know how to connect this to the acutal Month.
Do you need split that into 12 and 'see' months(Jan,Feb.....)
can you please upload a sample document, or your schema to understand more.
also you want to do this in your load script or on the design/chart level?
Hi Robert,
what i need is something like this:
Month | Aim | Aim cum. |
---|---|---|
Jan | 0,25 | 0,25 |
Feb | 0,25 | 0,5 |
Mar | 0,25 | 0,75 |
Apr | 0,25 | 1,0 |
May | 0,25 | 1,25 |
Jun | 0,25 | 1,5 |
and so on.
But I only got '3' as Aim for, lets say, Year 2014.
Hi Malek,
I doesnt matter where i implement this. Whatever solution is easier.
Hi,
Try like this using SubField
Data:
LOAD
SubField('Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec', ';') AS Month,
Value/12 AS Value
INLINE [
Value
6
3
10
];
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
Thx for the hint but this isnt working for me.
Problem is that i need a second dimension like department
So for one derpartment (and there are a lot) theres a plan per year. And now i need to break down this value to monthly level.
Regards,
Phil
Hi,
If you share sample data it would be easier to give solution.
Hope below script helps you.
Data:
LOAD
SubField('Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec', ';') AS Month,
Department,
Year
Value/12 AS Value
FROM DataSource;
Regards,
Jagan.