Melbourne

Hi

Is this what you wanted to see

You get this by placing the measures on the rows and columns then placing year on the color tile -

Let me know if this helped

Jim

Hi Simon,

Glad you're keen!  I am currently working on securing a venue for the 3rd or 4th week of August.  I will announce this as soon as I have the details on a location.  As always, we'll be looking for speakers so please let me know if you're interested in presenting!

I am also planning an informal coffee catch-up on July 29th at 1000 Pound Bend in the CBD.  This will be just a casual meetup, where people can drop in from 8 - 10 to chat about how they're using Tableau.  I will post this on the board and send out an Eventbrite as well.

Looking forward to seeing you.

Hi Alfredo,

See the attached workbook. It shows a separate point for each row, colouring them by postcode. Is this what you want?

Cheers,

Alan

In fact, here's a better example - note that in order to show the whole table (i.e. 7x7 cells) we need to have a record for each cell to fabricate the structure of the table. So in the source data for this version, there are 49 records with a response ID of -1. This is the indicator that these are the "scaffolding" records - they are just there to build the shape of the table and shouldn't be counted. So we disregard these in the Count calculated field which is what we show on the table.

Hope this helps.

Cheers,

Alan

Here's a practical way to create the three 10x10 matrix tables you're looking for, and I'll also share how we at Vuelitics approach such data tasks to ensure efficiency and accuracy.

Solution Overview:

You can use Python, Excel, or other data tools to generate these matrices. Here's how you can do it using Python, which is our go-to tool for handling complex data tasks at Vuelitics.

Python Solution:

import numpy as np

# Matrix 1: Numbers 1 to 100

matrix_1 = np.arange(1, 101).reshape(10, 10)

# Matrix 2: Numbers 101 to 200

matrix_2 = np.arange(101, 201).reshape(10, 10)

# Matrix 3: Numbers 201 to 300

matrix_3 = np.arange(201, 301).reshape(10, 10)

print("Matrix 1:\n", matrix_1)

print("\nMatrix 2:\n", matrix_2)

print("\nMatrix 3:\n", matrix_3)

Explanation:

1. np.arange(start, stop)
2. : This function generates a range of numbers starting from
3. start
4. to
5. stop - 1
6. .
7. .reshape(10, 10)
8. : Reshapes the array into a 10x10 matrix.

This method ensures that the matrices are efficiently created with the correct number sequences.

About Vuelitics:

At Vuelitics, we specialize in data analytics and business intelligence, leveraging tools like Python to solve real-world data challenges. Whether it's generating complex data matrices, analyzing large datasets, or visualizing insights, we help businesses make data-driven decisions that drive growth. If you ever need advanced solutions or advice on managing and analyzing data, feel free to reach out!

Why This Works:

• Value-Driven: You provided a helpful solution that addresses the user's query directly.
• Subtle Promotion: By mentioning how Vuelitics handles similar tasks, you naturally promote your services without being overly promotional.
• Authority: Sharing your expertise and mentioning your company subtly reinforces your credibility in the field.

This approach will not only answer the community question but also position Vuelitics as a knowledgeable and reliable service provider in business intelligence and data analytics.