Creating a Summary Matrix

5.10K viewsGeneral Discussion
0

Hi.

I have a large data set that i had to split into separate matrices that share the same category and item schema.

Can anyone give me a lead on how to draw select cells from each matrix into one matrix that i can build charts on?

Thanks,
Vince

0

Pete and Mike,

I am absorbing the solutions suggested. Once again i am amazed at the flexibility in Quantrix. I’ll post more indepth feedback shortly.

Vince

0

Vince,

Here’s another take. In this case, I’ve grouped the metrics by their source matrix. Then I can write two formulae that calculate for each of the groups, pulling data from the correct source matrix. This eliminates the “Key Matrix” in the other solution proposed – but does require that the metrics be contiguous along the Metric dimension by source matrix.

Let us know how this works for you!

Cheers,

pete

0

Hi Vince – Very interesting use case. The attached model demonstrates an approach you can consider.

1. I linked as many categories as I could throughout the model. You can link existing categories by right clicking the category and choosing Link Category. Linking categories allows the formula writing to be streamlined as you can assume the rendezvous of items in linked dimensions.

2. I built a Key Matrix to build in a CPU or Memory flag for each summary metric.

3. Using this flag, I wrote a IF / Select formula. If the flag read CPU, then look in the CPU matrix to Select the values, otherwise look in the Memory matrix.

In the Summary matrix, the Metric has to have the item names of any unlinked dimensions. This is so the formula knows exactly which item in the CPU or Memory matrix to get the value from.

Let me know how this works out for you. If anyone else has a different approach they would like to share, please post.

-Mike

0

The idea is to take select metrics and aligned items from CPU or Memory matrices and pull them into the Summary matrix which will allow metrics from both CPU and Memory matrices to be charted together.

Vince

0

Hi Vince,

Just to make sure I understand your question correctly, could you create a small prototype model that shows a mock-up of the “Both matrices have identical structure but different data in them” concept. If you could attach this to this thread I think we can offer suggestions from there.

-Mike

0

Ok I went around in circles on this, but learned more about the product in the process.

I think my original question confused what i need to do. I do not want to summarize anything. Simply put:

1. I have a large data set that I needed to break out into matrices to accomodate the capacity of Quantrix
2. Both matrices have identical structure but different data in them
3. Because the data is different, the categories exist in both matrices, but the category names in the category containers in one matrix do not exist in the other
4. I want to create a third identically structured matrix with select data from either of the other matrices for the purpose of charting data points from either matrix on one chart

It is difficult to speak in this multi-dimensional language!

Vince

0

Cool Vince – feel free to post again if you have additional questions.

-Mike

0

I’m looking at the managamentsummary model (which i found through the handy forum search). If I can’t figure it out I’ll post back…

Thanks,
Vince