Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

measures in a table/matrix

Hi,

I am a student currently doing a work placement. I have been tasked with creating a visual based on the clients needs they would like this to be in the form of a matrix. I have been able to create the measures required to achieve this but am currently struggling with being able to visualise it the way they have asked.

 

Field List:

 

 

Calculated columns :

 

 

Measures:

 

 

 

 

Here is an example of a chart I already have which shows the average score for each subject across all schools.

 

Below are the tables I have for my dataset:

 

 

 

 

Below is an example of how they would like the outcome to be presented which I am struggling with:

 

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Have you set up the table relationships?

    The visual you want is a matrix.  What have you got so far?

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

    Based on your description and sample data, not certain what is your expected output.

    In your datasets, there are only 4 students from school A, what about others? Have you created relationships between these tables? 

    Could you please consider sharing more details about this issue or a sample file for further discussion?

    In addtion, if you want to use a matrix to show the result which is simliar with the last picture, I'm afraid you could not achieve this because measrue can not be used as rows / columns in matrix.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.