Daily Data vs a Total Target

[#1]

Hello,

I have daily figures for one set of data, with another set of data on a monthly basis (a target).

I can graph the daily sales which accumulate, however I want to track these against a target which I have at a monthly level.

i.e.

Is there an easy way to do this please?

Many Thanks

[sunny_talwar]

Not sure if I completely understand your question. Is your dimension month or day here?? Please provide a sample if you could.

Best,

Sunny

[#3]

Ie. I have sales daily but a target at a monthly level:

DAY          SALES

day1          10

day2          15

day3          20

day4          25

day5          30

day6          35

But with a target of the total month ie.  50

So when It is graphed it looks like this:

As the target is not split down to a daily level

[sunny_talwar]

So for each day you would show 50 as the target??? compared to cumulative sales

Is that what the goal is?

Best,

Sunny

[#5]

No, I would want to calculate the target per day so 50/6 = 8.3

DAY          SALES          TARGET

day1          10                    8.3

day2          15                    8.3

day3          20                    8.3    

day4          25                    8.3

day5          30                    8.3

day6          35                    8.3

On a graph this would then be able to be accumulated back up to 50

[sunny_talwar]

Have a look at the attached qvw file, is this close to what you are looking for? I didn't have the data structure with me so I used hardcoded 50 here, but have a look.

Best,

Sunny

[ramoncova06]

I normally break down the monthly target into a daily target based on the numbers of days in a month

[#8]

Yes I can do that, also but it does not have any relationship to the days?