bonjour,
j'ai une base de données qui commence en octobre 2024, jusqu'à janvier 2025.
j'ai ce graphique joint.
existe-t-il une astuce pour ne pas avoir les mois sans résultats?
cordialement
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,
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