would like to do CDF by the different groups for comparison. how to do it?

[Ming Dong 2]

would like to do CDF by the different groups for comparison. how to do it?

[Fredrik Rosell]

Hello,

To start with, are you currently using the CDF Data Function available in TIBCO Exchange (https://community.spotfire.com/s/exchange/aCv4z0000008OaMCAU/cdf-data-function-for-tibco-spotfire) or something else?

Best Regards

Fredrik

[Gaia Paolini]

Maybe this thread can help:

https://community.spotfire.com/s/question/0D54z00008g9BKfCAM/how-can-separate-data-into-different-groups-for-the-cumulative-distribution-function-in-r-

[Ming Dong 2]

yes. Based on the addon we only can create a new table with a signal column. just for example like below:

value group

0.99 sw

0.97 tk

0.76 JO

0.89 sw

0.77 JO

0.54 TK

I would like to retrieve data from my table and create a new table called 'CDF' using the data function, but I am unable to include the 'group' parameter in the new table.

[Ming Dong 2]

the key is how to create a new "CDF" table for analysis. could you please educate me? thanks, i uploaded the raw data as attached.

[Gaia Paolini]

In the thread link above, you can find a dxp with a modified data function. This data function (attached) takes in input a data frame (df) a value column name (analysisColumnName) and a grouping column name (groupingColumnName).

The results can be displayed for instance like this:

 

[Ming Dong 2]

sorry, it's hard to catch your point. before we plot the CDF chart, we still have to get a new table, am I right? How do transfer or create it?

[Gaia Paolini]

Spotfire data functions can create tables. The CDF table is created as an output to that data function.

See for instance these resources:

https://community.spotfire.com/s/article/Spotfire-Enablement-Hub

https://docs.tibco.com/pub/spotfire/6.5.0/doc/html/df/df_details_on_data_functions_parameters.htm