-
1. Re: Counting a unique number of days
Shinichiro MurakamiAug 4, 2017 8:47 AM (in response to Abhiroop Verma)
-
countdays_SM_10.2.twbx 38.3 KB
-
-
2. Re: Counting a unique number of days
sesha.peram Aug 4, 2017 8:52 AM (in response to Abhiroop Verma)Hi,
Create calcualted field as v1=If(isnull([value obj]) then "Y" else" N"
Now take count(([v1]) and In filters restrict V1 ="N"
Thanks
-
3. Re: Counting a unique number of days
mitchell.landisAug 4, 2017 8:58 AM (in response to Abhiroop Verma)
Hi Abhiroop,
What have you tried so far to create the desired calculation?
There are likely many different ways to do this but one thing I tried was to create a simple Show/Hide calculation and place that on the Filter Shelf (see below):
IF [Value] = 0 THEN 'Hide' ELSE 'Show' END
If we then drag the Date field onto the text shelf, we can change the aggregation to Count Distinct and that should give us the count you are looking for.
If you're strictly looking for a calculation and want to avoid the filter shelf, we may have to go a different route.
I've attached the .twbx for your review.
-
CountDate.twbx 11.6 KB
-
-
4. Re: Counting a unique number of days
Abhiroop Verma Aug 4, 2017 10:54 AM (in response to Shinichiro Murakami)Thanks Shin! Much appreciated.
-
5. Re: Counting a unique number of days
Abhiroop Verma Aug 4, 2017 10:54 AM (in response to Abhiroop Verma)Thanks for your help everyone!