- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
problem with a graph
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?
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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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,
"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 /
with the formula:
Then use the local data filter to select