5 Replies Latest reply on Apr 18, 2018 10:26 AM by Amit Naik

# Convert to Dimension not available

I want Count distinct of Customers by ASR but the issue is I am not able to convert ASR Grouping into Dimension.

I have a calculation

Avg Subscriber Revenue

##### END)

ASR Grouping

if [Avg Subscriber Revenue] > 278

then '> 278'

elseif [Avg Subscriber Revenue] >= 167 AND [Avg Subscriber Revenue] <= 278

then '167 - 278'

ELSEIF [Avg Subscriber Revenue] < 167

then '< 167'

else 'N/A'

END

Hence total Customers for 167-278 = 398

But after going Distinct Count of Customer Number it vanishes because the grain is at higher level

The LOD is having issue

• ###### 1. Re: Convert to Dimension not available

Hi Amit, will you please be able to attach the twbx file ?

• ###### 2. Re: Convert to Dimension not available

Your Avg Subscriber Revenue calc is an aggregate.  Therefore it is a measure and always be a measure.

Because of that, ASR Grouping  is based on an aggregate, and therefore is also an aggregate and always will be a measure.

But looking at the first calc, I think you can redo it as a FIXED LOD.  And if you do, then it is NOT an aggregate, and therefore the ASR Grouping will also not be an aggregate.

To make the FIXED LOD, the SUM half of your calc will be one FIXED LOD, and the COUNTD half will be another.  You can combine those two LOD strings into one calc if you want.  Otherwise make two separate ones, and make a third calc that divides the two.

• ###### 3. Re: Convert to Dimension not available

HI Amit,

I think You dont need to convert ASR grouping into dimension. If you want the total 398 of countd customers, simply remove the customer ID pill from row and put the COUNTD(customer ID) in text. I just mocked up a calculation below. if you still wan the customerid pill in rows, you may want to use subtotal on columns

• ###### 4. Re: Convert to Dimension not available

Thanks Joe

ofcourse I need to create the LOD's but need to figure it out well. I will try out ans post the solutions in here.

• ###### 5. Re: Convert to Dimension not available

Hello Anik

thank you so much for taking time to help me resolve. However this being an aggregated calculation the stated solution dosent work.