Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to group how many times values are repeated to zero in a client and show it in a graph. The period is from January to December, meaning that a customer can have a value at zero 1 to 12 months.
I want to show my dimension from 1 to 12 times in the year
Expression
COUNT({<[CSMO_ACTUAL]={0}>}CICLO)
should work with customer as dimension and Include zero values in Data Handling Add-Ons property of graph
It is not what I need, in the dimension I want to show the N occasions that the value to zero is repeated.
It still does not work, I need to leave the graph as in the following image from 1 to 12 times.