-
1. Re: Using a calculated field based on aggregates as a dimension
Deepak Rai Apr 10, 2017 3:00 PM (in response to Steve Field)Hi Steve,
Here it is. Check Screenshot and attached. I used an LOD to do this and Grouped the values of LOD as per your Grouping Calculation.
Hope it Helps!!!
Thanks
Deepak
-
Price Group Example.twbx 1.2 MB
-
-
2. Re: Using a calculated field based on aggregates as a dimension
Deepak Rai Apr 10, 2017 3:02 PM (in response to Steve Field) -
3. Re: Using a calculated field based on aggregates as a dimension
Steve Field Apr 10, 2017 3:09 PM (in response to Deepak Rai)Well, I had read that using a fixed LOD calculation was a work around but it causes Avg Price to be calculated incorrectly... for example if you look at Postal Code 03060 the Average Price should be $3.59 but using a LOD calc it's returning as $7.75
-
4. Re: Using a calculated field based on aggregates as a dimension
Deepak Rai Apr 10, 2017 3:24 PM (in response to Steve Field)-
Price Group Example.twbx 1.2 MB
-
-
5. Re: Using a calculated field based on aggregates as a dimension
Steve Field Apr 11, 2017 8:41 AM (in response to Deepak Rai)Deepak! You are the man! I tried several variations of the calc using a fixed function and never would have come up with writing it that way but it works! THANK YOU SO MUCH!!!
Cheers!
Steve
-
6. Re: Using a calculated field based on aggregates as a dimension
Steve Field Apr 11, 2017 11:12 AM (in response to Steve Field)The only thing I'd add is that this example it works fine until filters on other dimensions are added. Once a filter is applied it doesn't calculate correctly... adding the filters to the context fixes this