Forum Discussion
Matrix without aggregation
Hi.
Is there way to do a matrix visualisation without it aggregating data?
I did first a table on stock market with following columns: Date, name of the instrument, ISIN code, currency, amount bought, price per share. But then I thought I want to have headers on rows: I want to show stocks as one group and bonds as other. This of course can be done using a matrix. So I change the table to matrix and add "class" (=stocks/bonds) to rows and all the other fields go to values. But now for e.g. date I need to choose the first/last/count or some aggregation. Can I somehow bybass this aggregation and force the matrix to have all the rows displayed? Can I for example use some sort of measure - like values(date) or something?
Thank you!
6 Replies
Hi GoingIncognito ,
Using matrix the values make the aggregations as you refers, in your case all the data that you don't want to have as aggregated value you should place on the rows of the matrix and then expand the matrix to the lowest level.
So no way of bybassing this? Like no amount of writing measures that use summarize will resolve this?
Hi GoingIncognito ,
Not really understanding your question, from the columns below what are the ones you don't want aggregated:
Date
Name of the instrument
ISIN code
Currency
Amount bought
Price per share
Assuming that amount bought would have aggregation the others not, so if you place everything in rows and amounth bought in values should have values you need.
You can not have an unaggregated measure in Matrix. You can have it in Table. You can create an Index column and use that in the row. You can use stepped layout will all level drilled
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
