Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community members
Has anyone an idea how I could ignore the datapints from the dark blue line ("Base planning CP"). The goal is to start at zero and directly connect the line to the next available amount. In my datamodel I only have dates + values on the desired datapoints.
Thanks for your help
Date | Value |
31.01.2012 | 0 |
31.12.2013 | 51885 |
28.02.2014 | 164732 |
31.12.2016 | 20084 |
Nachricht geändert durch Michael Städtler
May be this:
If(Sum({<KPIID = {20}>} VALUE) = 0 and DATE <> Date(Min({<KPIID = {20}>}TOTAL DATE)), Null(), RangeSum(Above(Sum({<KPIID = {20}>} VALUE), 0, RowNo())))
May be something like this:
If(YourExpression <> 0, YourExpression)
But you will need a additional if to check for the first 0. May be use the minimum date to allow that to be 0 and everything else becomes null().
Thx for your post.
This is not working. The problem is the second expresion in this chart. Whenever it has a datapoint on a given date, it uses this date with value 0 also for the other expression.
Any other ideas?
May be able to offer better advice if I can have a sample to work with.
! added the example with the desired line in my original post.
@This?
Just sets the static min in the axes as:
min(SUM({<KPIID = {20}>} VALUE))
Regards,
MB
Thanks Miguel, but this is not the problem.
Please look at the example. The Line for "Base planning CP" should go straight from 0 to the first available data point (62'290,-). Now it goes parallel to the date axix and then to the first data point.
Thanks
May be this:
If(Sum({<KPIID = {20}>} VALUE) = 0 and DATE <> Date(Min({<KPIID = {20}>}TOTAL DATE)), Null(), RangeSum(Above(Sum({<KPIID = {20}>} VALUE), 0, RowNo())))
Works perfectly! Thank you sunindia!