My MDX query retrieves about 10 column names (in fact, this is the key EVENT_ID), which will be used in the report to link the goal and drill behavior) + time measure (time lost per day in our factory) + budget measure.
Since I have all these columns, I cannot "Include empty cells" → the result in miljons rows.
I represent the time loss in the column diagram +, evaluating the line of the moving line (from the code behind, rather complicated) +, representing the budget line. I put, using signatures, a series of diagrams in the layout from top to bottom, only the diagram series are changed using the parameters, so I want all the diagrams to look the same (the same start and end points on the x axis), but when they are replaced by only a group of series → comparison will be easy.
My problem:
Since the MDX request only reports days when we really have a loss of time,
This leads to a very unpleasant layout or subtitles, where some charts have values for the last month / day and do not ...
Please, did anyone solve any similar problem? I tried to solve this problem using the Lookup function between another DataSet containing all dates, but using serial groups makes it inappropriate.
Information added:
Look at the image below.
da * n I have only 6 points, you need 10 to send images: /
The thin line estimates the moving average ok, but I can’t fill in the value after mar , since my dataset has no values after Mars .
Jan, Feb, Mar, Apr, May. , Feb, Mar → Mar. , . :
iif(DateValue(Fields!Date.Value)>=DateValue(First(Fields!Date.Value, "TimeData"))
,Code.movAvg.movingAverage(
Sum(Fields!Time.Value,"CategoryGroup")
,DateValue(Min(Fields!Date.Value, "TimeData"))
,DateValue(Fields!Date.Value)
,DateValue(Max(Fields!Date.Value, "TimeData"))
,Parameters!Type.Value
,"TOTAL"
)
,Nothing
)
"" ...
:
1, ( 10 ), 5 ( -by behavour) , , ...
2. , 1 - , ...