I've a data counting events. No events occurs in July, so this month is empty. Is there any way to ensure this month is still shown in the graph but simply as a missing line piece?
I could probably make a work around by introducing a July-date in a year not displayed, then colour this year invisible/white, but this seems like such a hack.
Is there any way to do it without messing with data in excel?
twbx attached.
4 réponses
Use this calculation and also go to Analysis menu>Table Layout >Select Empty Columns
IFNULL(LOOKUP(COUNT([Betjeninger]),0),0)
