Question

How to create Matrix Report? Need step by step process.

0

I want to create Matrix Report like this : Help me by giving step by step process.

asked 2024-04-08

Vijay Lakhani

6 answers

Rene van Hofwegen · Answer 1 · 2024-04-10

Vijay Lakhani · Answer 2 · 2024-04-10

Hi @Nabin Choudhary,

Here you can see data and it's output as matrix/pivot table.

Erwin 't Hoen · Answer 3 · 2024-04-10

Have a look at the demo project that is available from the marketplace: https://marketplace.mendix.com/link/component/115965

This should explain exactly how this is done with the pivot table widget.

Vijay Lakhani · Answer 4 · 2024-04-12

For Y-axis ID, I set the attribute whose type is 'Date and time'. So this widget giving error. You can see error in second image below.

error :

Please give the solution for this.

Marcel Groeneweg · Answer 5 · 2024-04-12

Hi,

What is the data type of TotalKmRun?

Marcel Groeneweg · Answer 6 · 2024-04-12

Please check the examples in the sample project there are examples of counting data as well