47802_en-US

liliconcom

Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

All, 

     I would like to know if there is a way to make the Data Filter a text edit box or number edit box instead of the default List Type Display or the Slider view .

dt = Open( "$SAMPLE_DATA/Time Series/Raleigh Temps.jmp" );

// Traditional Slider View 
dt << Graph Builder(
      Size( 814, 714 ),
      Variables(
       X( :Name( "Month/Year" ) ),
       Y( :Temperature ),
       Y( :Predicted Temperature, Position( 1 ) )
      ),
      Elements( Line( X, Y( 1 ), Y( 2 ), Legend( 23 ) ) ),
      Local Data Filter( Conditional, Add Filter( columns( :Month Number ), Display( :Container, Size( 160, 225 ), List Display )) )
     );

The above code produces this : ( Slider View) 

Instead , by remodeling the column as Ordinal data , I can generate the LIst Display for the data filter 

Col = Column(dt,"Month Number"); 
Col << Set Modeling Type("Ordinal");
dt << Graph Builder(
      Size( 814, 714 ),
      Variables(
       X( :Name( "Month/Year" ) ),
       Y( :Temperature ),
       Y( :Predicted Temperature, Position( 1 ) )
      ),
      Elements( Line( X, Y( 1 ), Y( 2 ), Legend( 23 ) ) ),
      Local Data Filter( Conditional, Add Filter( columns( :Month Number ), Display( :Container, Size( 160, 225 ), List Display )) )
     );

The above code generates this : 

Instead , I would like to have the Data Filter displayed as a text edit box / number edit box . I remember going down this path at one point , but dont remember the result - if anybody can address it - please kindly share . 

Best 
Uday 

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

Interestingly, the 'keep things simple' mentality is the exact reason I would consider coding this.  For a seasoned JSL user who knows about the numeric entries, and already learned not to lower the upper limit before lowering the bottom limit, and knows what Show, Include, and Inverse mean, simple code is probably better.  For the best user experience though, if they only want to see one data point at a time from a long list of possible dates, it is hard to get simpler than a well-described box where you enter a date.

 

A GUI should be hard to explain because it you never had to think about it before, not because it requires specific steps in a specific order.

 

Of course this might not relate Uday's problem at hand.

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

Here's a GIF that shows clicking on the value in the slider to set it.

 

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

I like to keep things simple. The 'slider view' that you refer to shows the upper and lower limits of the current filter. You don't have to use the slider to change the range. You can also click on the current value (number) and enter a new one. This way you can use the data filter object (simple) and avoid additional coding that might not really add new functionality.

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )@Mark_Bailey : can you please elaborate or demonstrate what you are saying ?
Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

Did you know that you can also click on either one of the current limits in the Data Filter and enter a new one?

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

Here is one way.  I am not sure if it is possible to read the text edit box value using an input format (as in data table cells) but I like the flexiblity of regex:

 

Names default to here( 1 );

dt = Open( "$SAMPLE_DATA/Time Series/Raleigh Temps.jmp" );

New window(
 "Graph with filter",
 Data filter context box(
  H list box(
   V list box(
    Text Box( "Enter month and year (mm/yyyy):"),
    Text Edit Box( "01/1980",
     <<SETFUNCTION></SETFUNCTION>

 

Edited: forgot screenshot. 

Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )@ih,
In the example you have provided, can you use the "Month/Year" column instead ? For when you have a date - wouldn't this approach require a Number Edit Box for Month, Day and Year respectively ? Or can it be done with Number Edit box ? The only way , I can think of is by translating the text into a number that equals the date , please let me know if there is a better alternative .Re: Display Data Table Filter As a Simple Text Edit Box ( Not List Not Slider )

You could set the where clause in the data filter yourself when the value in a number edit box changes, and hide the normal user interface:

 

 

Names default to here( 1 );

dt = Open( "$SAMPLE_DATA/Time Series/Raleigh Temps.jmp" );

New window(
 "Graph with filter",
 Data filter context box(
  H list box(
   V list box(
    Text Box( "Enter month:"),
    Number Edit Box( 1,
     <<SETFUNCTION></SETFUNCTION>