Hi, Stuart

is it that you need an index (calculated measure) for your dimension? not the dimension you have in your dataset?

-Mia-

Hi, Stuart!

I guess i am not fully understanding your requirement. Like I asked earlier, do you want a calculated "measure" as your "dimension"?

Disaggregated means it will show each data point without calculation and you should be "filtering" things out instead of "calculating" the dimension? what is it that you want to place in column/row shelf as your dimension? Do they have to be calculated? if so, by what?

-Mia-

Hi Stuart,

Does your data set have a unique row identifier? If so just keep it aggregated but add that to detail.

Take care,

Keshia

Hmm, I don't think so. If you just used your measure as a dimension, it will only show a mark per each unique value, not per each row in the data set. The only way to make sure that you actually are accounting for every single row would be to uncheck the "Aggregate Measures" option. However, once you do that, there is no way to get the index to work correctly for states(which you need for this to work) since you are telling Tableau to dis-aggregate everything. So even if there is a way (I can't think of one but maybe others know), I feel like it would probably be so convoluted that it wouldn't be worth the effort, especially when it's so easy to just add it to the data.

Take care,

Keshia

Hi Keshia and others:

I have a similar problem. I am trying to create trellis chart of nonaggregated data, in this case, i am using autompg dataset from UC Irvine. When I add indexID which is equivalent to your rowID, i lose my trellis chart. In the attached tableau I have two sheets: one that shows nonaggregated charts of MPG by weight by model year and I would just like to create trellis chart of this. Following Andy's blogpost at Panel charts in Tableau – Gravy Anecdote I created trellis chart in the second worksheet but when I add indexID to detail in this worksheet, it all goes away. Any suggestions?

Radhika,

Please see if the attached Sheet 4 could work for you.

I think the [RowInd] may have needed two adjustments:

if [RowVal] = INT([RowVal])

then INT([RowVal])

elseif [RowVal] < 1

then int ([RowVal])+1

ELSE int([RowVal]) +1

END

( the division of [index of model yr] by [# of columns] may need to be compared against 1,

and if it is less than 1, add one to the Int([RowVal)] )

For the table calculations of [ColumnInd] and [RowInd3], I needed to change the "Edit Table Calculation" settings to:

Compute Using:

    Specific Dimensions

        √ Model yr

        √ IndexID

At the Level:  Model yr