This content has been marked as final.
Show 3 replies
-
2. Re: How do you fill in missing data to display zeroes, instead of not showing a value at all?
Phil R Jul 10, 2018 11:57 AM (in response to Deepak Rai)Thanks Deepak, can you explain the solution and it's application? There are a number of functions here that are rather dense:
Calculation 1 = IFNULL(LOOKUP(SUM([c_Distinct User ID Count]),0),0)
Calculation 2 = INDEX()
Calculation 3 = {FIXED [c_Total Visit Count for User ID]:SUM([c_Distinct User ID Count])}
Calculation 4 = IFNULL(SUM([Calculation3]),0)
Calculation 5 = IFNULL(LOOKUP([Calculation4],0),0)
Thank you
-
3. Re: How do you fill in missing data to display zeroes, instead of not showing a value at all?
Deepak RaiJul 10, 2018 12:06 PM (in response to Phil R)
I tried everything, I Changed your Axis to continuous to show you missing Values and Tried Different Tricks to Bring 0 at 3,6, 7, 8, but looks like I can't do that. So These are all those Calcs. Will Try later though.
Thanks
Deepak