Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a line chart with years of date
some year are showing only the month's with values, but the client want to show all the year value, no matter if the value of the year, month or date is 0
This is an exemple of what they want:
I tryed to criate a master calendary which had some succes but still with some issues on the values
the new question is, my code is bringing missing values
if ( IsNull(item), 0, Count ( { < item = { condidion1 } > } item ) )
i don't know how to repair this
You would need to add dummy data in your table with 0 value
and
then in your chart under AddOn>> Data handling>>check Include zero values
i had tryed the master calendary, it work's but not 100%,
if ( isnull(item), 0, Count ( { < item = { condition1 } > } item ) )
This code was my try, but had some issues in the count