Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning everyone, I need your support in order to display a scatter plot I need to develop, the expressions that I use are:
Expr1: Only ({<[Year Time - Cost] = eaMarino :: [Year Time - Cost], Management = { 'Terrestrial'}, [Month Time - Cost] = { '> (= min ([Month Time - Cost ]) <(= max (eaMarino :: [Month Time - Cost]) '}>} [Actual Cost])
Expr2: Only ({<[Year Time - Cost] = eaMarino :: [Year Time - Cost], Management = { 'Terrestrial'}, [Month Time - Cost] = { '> (= min ([Month Time - Cost ]) <(= max (eaMarino :: [Month Time - Cost]) '}>} [Planned Cost])
The detail that I have is that when I add the expression of the month ([Month Time - Cost] = { '> (= min ([Month Time - Cost]) <(= max (eaMarino :: [Month Time - Cost ]) '}), not shown the graph, show the leyend "no data to be displayed", but they do exist.
The data come from the selection in an alternate state called eaMarino.
in my condition I require is that to indicate a month, for example, the information is displayed March from January to March inclusive.
In advance thank you very much by support to my problem.
I look forward to your comments.
Kenneth Baeza
What is the format for [Month Time - Cost]? Format's need to match on the LHS and RHS of the set modifier. Min(Month) would be a number and wouldn't equal Jan, Feb, ... etc. So you need to somehow get the LHS and RHS in the same formats to get this working
Thanks for your comment Sunny T, both values have shaped the text, Jan, Feb, ..., I made the switch to numeric format by changing the value of MonthNames
SET MonthNames = '1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12';
even so, I do not get to see the graph.
thanks for you support.
Kenneth Baeza
Would you be able to share a sample to look at the issue?
Of course, attached application, I use a Personal Edition version.
Regards.
Kenneth Baeza