Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I`m trying to create new chart but I want to show only key models in the chart ! but on the other hand I want to give to the user the ability to select model in the filter view.
I will give an example:
When no selection has made, I want to show by default the machines models: X,Y,Z
but when the user made a T machine model , I want to show only the model machine T.
I used the line chart:
group field is "Time"
Line field is "Model"
measure is
((sum( Aggr(sum( distinct [Duration]),[Machine Job])))/
($(vUtilizationTotalTime)*count( distinct [Machine number])))
I dont want to use the function getCountSelected - it makes issues when selection made.
the only way that I can think about is Set Analysis, it works in some cases (when I applied it on the dimensions) but when the user try to select some value in model filter the selection didn`t change .
any suggestion ?
Thanks
what is your issue using "getselectedcount"? you want the models X;Y;Z when no selection is done.
Maybe you may use a test for explizit naming of models?
if (match(getfieldselections,Line), 'T','other models except X;Y;Z') > 0,
((sum( Aggr(sum( distinct [Duration]),[Machine Job])))/
($(vUtilizationTotalTime)*count( distinct [Machine number])));
((sum( Aggr(sum( distinct [Duration]),Line={'X','Y','Z'},[Machine Job])))/
($(vUtilizationTotalTime)*count( distinct [Machine number])))
When i`m doing another selection the previews selection change for some reason.