cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
MahaRabeh
Level II

Partial data filtering

Hello,

 

Since it is not possible to create a graph from two different data tables in graph builder, I updated one data table with the data from a second data table:

MahaRabeh_0-1636637445800.png

 

I can now create the graph I need (below). The problem is the following:

I would like to apply data filter only on the data from the first data table, without influencing the added data from the second data table.

Meaning in the graph below, I would like to filter claimed quantity (Y axis left) by customer, while keeping the background graph (Total volume) the same unfiltered.

MahaRabeh_1-1636637445810.jpeg

 

What is the best way to achieve this result? 

 

 

1 REPLY 1
jthi
Super User

Re: Partial data filtering

I would definitely try to figure some other way to do this (maybe with background image or by drawn shape) but this can be done with a formula and by adding extra rows to data so all Customers have at least something on every date.

jthi_1-1636646522879.png

jthi_2-1636646530547.png

jthi_3-1636646538361.png

See attached datatable. Idea is that Col formula wont be affected by the filter and by adding extra rows we can force those values to appear always

 

-Jarmo