cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use JMP Live to centralize and share reports within groups. Webinar with Q&A April 4, 2pm ET.
Choose Language Hide Translation Bar
View Original Published Thread

problem with a graph

Françoise
Level V

Good morning,


I have a database that starts in October 2024, until January 2025.


I have this graph attached.


Is there a trick to avoid months without results? undefined


Sincerely

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

2 REPLIES 2
Victor_G
Super User

Re: problème avec un graphique

Hi @Françoise,

 

Happy new Year 2025 !
I think you may find a solution in previous post A way to show a date with no data in graph builder by changing your column date format (from continuous to categorical/ordinal), disable "Include Missing categories" in Graph Builder Graph Builder - parallel Plot - missing entries, or simply hide & exclude rows with no data.

 

Hope this answer may help you, 

Victor GUILLER

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)
hogi
Level XII


Re: problème avec un graphique

Just add Moyenne to the Local Data Filer and move one of the sliders, first in - and then out, to select all data points (with values). Then all data points with values will be displayed - and regions without data will disappear.

A significant disadvantage of this approach: it is NOT dynamic.
The Data filter will stay as it is - once the data set gets updated, the plot will still show data with the previous limits.

 

better: add a transform column via right click / 

hogi_0-1736189723445.png

with the formula:

hogi_2-1736189834197.png

Then use the local data filter to select

  hogi_3-1736189855591.png