Hi All,
I'm making a line chart in Webi in which different lines represent different products. On the Y axis I have a measure (no problems here) and on the X axis I have months. Naturally, different products enter the chart at different points along the X axis because they didn't all enter the portfolio at the same time as you can see in the print screen. My problem is though, that I want the start point for all of the lines in the chart to be at the X-Y intersect, not the month that they actually started. The values for the X axis should then be 1 - 24 or something similar to cover a 2 year period. Newer products would then have a line that stopped at some point in the middle of the chart, rather than one that started in the middle.
I've been trying to create a new variable where min([Month]) is equal to 1 and then each month after that would be +1, but I'm not having any luck.
Thanks in advance for any suggestions.
Hi,
Since Different Products enter at different points, there will be no value for those products in that particular month,
Eg:
See the above Example for Product 2 there is no value for 201301 month, so when u convert to chart it starts from 201302.
But if u insert a variable =if(isnull([Y - Axis];0;[Y-Axis])
Then 0 will be inserted in place of null values,
So when u convert this into a chart all the products start and end at the same point but rises and falls based on the values.
Regards
Subasree
Hi Darrel,
Try using the DaysBetween and Min functions and the "In" operator. This will find the number of days between the "Order Dt" and first "Order Dt" for a "Product".
Example:
=DaysBetween( Min([Order Dt]) In ([Product]);[Order Dt])
Best of Luck,
Jeremy
Add a comment