Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26738

Sort Alluvial Node by Frequency

We can sort Alluvial node by name/ frequency.

In Node tab, add Node Order by option above Gap between Nodes. dropdown could be

  • None: current way, order of data, or categorical order

  • Name: alphabetical order

  • Frequency: frequency of node in column

ORG-27027

XF to Create Multiple VM and Plot Heatmap

A new dialog: plotmultivm to create heatmap with multiple info in one cell.

Command line usage for Existing Virtual Matrices type:

plotmultivm datatype:=vm irng:=VM1|VM2;

ORG-26846

Layer Content and Plot Setup Issues to Create Heatmap

Plot setup and layer content could list virtual matrix

In layer content, we list Virtual Matrices in data type dropdown list.

We also do the same for plot setup, list Virtual Matrices above Loose Datasets.

It should also list “Heatmap“ in Plot Type list box.

ORG-26739

Alluvial Label Improvements

Alluvial Plot Label On Top

Outside Node Position All Left/Right

In Label tab, add Position option in Show Label for plot group, under font, ratio could be Top, Bottom. Move Offset to 3rd line after this option.

For Outside Node Position, add Left, Right option before Top. This change could also apply to Sankey.

ORG-27159

ORG-26325

Fit Page to Layers Include All Graph Objects

supportFit Page to Layers Include All Graph Objects

In Fit Page to Layers dialog, add checkbox variable “go“ Include All Graph Objects in the end, default select it. Select it means all graph objects should be included when fit page, including graph objects that attach to page.

In Button Edit Mode (Ctrl+Alt+B), if a graph object is attached to page: a string “(P)” will be appended to the displayed object name.

Import

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26952

CSV connector failed to keep Text type column format

Added a system variable @IPKF to control which column format would be kept after import.

The @IPKF system variable is for CSV Connector only.

  • 0(default): keep date/time column format

  • 1: keep date/time/Text column format

  • -1: keep any column format

ORG-26921

CSV Connector supports append rows from script

CSV Connector supports append rows to import more files by scripts.

LT sample scripts:

Code Block
newbook;
string fname, path$=system.path.program$ + "Samples\Batch Processing\"; 
findfiles fname:=fname$ ext:="*.csv";
int num = fname.GetNumTokens(CRLF);
wbook.dc.add("CSV");
loop(ii,1,num)
{
next$ = fname.GetToken(ii, CRLF)$;
if (ii==1)
{
	wks.dc.flags=256;	// turn on append rows mode
}
wks.dc.source$=next$;
Tree tr1=wks.dc.optn$;
tr1.settings.partial.SetAttribute("Use", 1);
tr1.settings.partial.row$="2";
tr1.ToString(wks.dc.optn$);
wks.dc.import();
}

ORG-27074

Connector failed for Date Time More Cases

Improved JSON Connector to support auto detect date time, and import it as date time data.

For example:

the 1996-08-20T00:00:00 value will be imported as 1996-08-20 00:00:00 with column format “yyyy-MM-dd HH:mm:ss”.

...