Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello there,
Please take a look at the attached qvw.
A few notes:
I hope this helps
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.
Here is my expression:
Count({$<[Date Type]={'Del Dates'},Reference_Only={'No'},YearMonth={"<=$(=Month(today()) )"}, [#of Days Post DD]=-{' '}>}Product)
Yea still no luck buddy.
My format is MMM YY and I still get an error.
Hello there,
Please take a look at the attached qvw.
A few notes:
I hope this helps
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.