Combo Chart - Full Accumulation Limits

[ZoeM]

Hello Community.

I have a glidepath combo chart which shows Planned vs. Delivered product for the year.

I am trying to create limits for both metrics such that the planned line should start in the current month, April in this case, and still be the accumulated amount of planned (Jan through Apr).

The Delivered bars should stop at current month, Apr in this case and not show remaining. 

Please see attached application. 

Is this possible?

Thanks for the help.

[dplr-rn]

Quick question why do you have delivered information fro future?

in any case You can do it through set analysis for month
e.g. Month={"<=$(=Month(today()) )"}

but you need to format month appropriatly with dual. i.e. you need to create proper date fields rather than just text (like in your qvw)

[ZoeM]

Thanks for the reply Dilipranjith.

Yes I put that QVW together quickly for elaboration.

The below is the syntax for my expression in the actual dashboard:

Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'}, [#of Days Post DD]=-{' '}>}Product)

I plugged in your component and I got an error.

[dplr-rn]

Please share the expression you tried.

[ZoeM]

Here is my expression:

Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'},YearMonth={"<=$(=Month(today()) )"}, [#of Days Post DD]=-{' '}>}Product)

[dplr-rn]

Since you are using year month
change the Month(today()) to same format as your YearMonth column
e.g. below
YearMonth={"<=$(date(monthstart(today()), 'MMM-YYYY')"}

[ZoeM]

Yea still no luck buddy.

My format is MMM YY and I still get an error.

[albertovarela · Accepted solution]

Hello there,

Please take a look at the attached qvw. 

A few notes:

• I had to create a date field as your original qvw had month as a string
• For the planned I used a combination between rangesum and above therefore disabled the full Accumulation on the chart properties
• For the Delivered and difference I played with background colour (inside the expression). Made it white
• Created a separate chart for the legend as the original one was displaying the last colour on the expression (white)

I hope this helps

[dplr-rn]

hm.. thats the usual approach but depends on your data too.
i think i missed $(= in the last one.
but if you have sample app or data i can try locally too

[ZoeM]

Exactly!

But please explain a bit more on how you did this, and please reference my Set Analysis Expression and how I can get the same result as you:

If(YearMonth<Month(Today()),0,
RangeSum(Above( Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'}>}Product) ,0,YearMonth)))

I am not getting the same changes to the chart as you 

YearMonth is my date field in the chart

I am counting how many products that were planned have been delivered, by month. 

Blue color is Difference 

Green color is delivered.