This content has been marked as final.
Show 4 replies
-
1. Re: Basic Calculation off Dimension Attributes?
Deepak RaiJun 12, 2018 9:32 AM (in response to Trey Weeks)
COUNT(Complete)/(Count(Pending)+COUNT(Return))
-
2. Re: Basic Calculation off Dimension Attributes?
Trey Weeks Jun 12, 2018 9:36 AM (in response to Deepak Rai)Hi Deepak,
So "Complete", "Pending", and "Return" are attributes or fields (sorry I dont know the correct terminology) within the dimension "Order Status" so I cannot point a calculated field to those filter names.
For example I have an IF statement where I have to specify what the order status is that says:
IF [Order Status] = 'Closed'
THEN ([Order Number]) END
-
3. Re: Basic Calculation off Dimension Attributes?
Deepak RaiJun 12, 2018 9:46 AM (in response to Trey Weeks)
Order Status is your Dimension and Closed, Pending, Open Etc are Dimension Values. So If I use This Data To Count Those Orders where status is Complete
Order Number Status 1 Complete 2 Pending 3 Return 4 Complete 5 Return Then you get this
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to close Thread
-
Order Ex.twbx 16.6 KB
-
-
4. Re: Basic Calculation off Dimension Attributes?
Trey Weeks Jun 12, 2018 10:11 AM (in response to Deepak Rai)Perfect this is what I needed, appreciate the help