Forum Discussion
Missing Date Points
Would need sample data and your relationships and your formulas to really help you. What I can say is that whatever formula that you are using to calculate your sales or whatever, you should be able to wrap in an IF statement with an ISBLANK or something and return a "0" or something for that day so that it has some value for that day. Another trick is to add a column with the formula:
Column = 1
Just include that column in some way in your visualizations and now everything has a value so they do not get filtered out.
Again, these are general suggestions, I can't really give you specifics with the information that you have included.
Would need sample data and your relationships and your formulas to really help you. What I can say is that whatever formula that you are using to calculate your sales or whatever, you should be able to wrap in an IF statement with an ISBLANK or something and return a "0" or something for that day so that it has some value for that day. Another trick is to add a column with the formula:
Column = 1
Just include that column in some way in your visualizations and now everything has a value so they do not get filtered out.
Again, these are general suggestions, I can't really give you specifics with the information that you have included.
As a self learner, I have never got access to this function before.
It worked flawless:
About putting an extra auxiliar column, this is a technique that I often use, but in this case, maybe my filters would not make it work as we wanted.
Thank you very much, smoupre!
Regards,
Michell Madeira
