Skip to main content
Question

How can I create a matrix type visualization in a view?

  • February 20, 2024
  • 3 replies
  • 30 views

andrea.quint
Level 2
Forum|alt.badge.img

Hi Celopeers team,

 

I have a requirement where the user needs see the data as a matrix (like a image)

 

Basically the user needs to see the trend of various KPIs for specific dimension over time.

 

the request is in a View

 

example of matrixsomeone knows, how can I do it?

 

Thanks 😉

3 replies

Forum|alt.badge.img+8

Hi Andrea,

 

to my knowledge there is no straight forward way of doing this.

The two options that came to my mind initially are the following:

  1. Building a HTML Table. This is possible within a Text Box. The advantage would be to have everything within one component. The flip-side is that you couldn't filter on the individual cells of the tables and would need to build multiple versions of the same KPI but filtered on specific time intervals.
  2. Manually building a matrix by aligning multiple text boxes and KPI lists/cards. Here the advantage is that you would be only need to filter the kpi lists/cards by the respective time interval. However, the filters would still need to be created as well, but at least these could be reused. The end result could look like this: image

Both options have the limitiations of a static number of entrances in the matrix.

Please le me know if this is helpful and if you have any follow-up questions!

Thank you!

 

Best regards,

Bernardo


andrea.quint
Level 2
Forum|alt.badge.img
  • Author
  • Level 2
  • March 6, 2024

Hi Bernardo

Thanks a lot for your response.

 

Something like the second option I had in mind for the solution. When I finish it I will show you.

 


andrea.quint
Level 2
Forum|alt.badge.img
  • Author
  • Level 2
  • March 16, 2024

Hi Andrea,

 

to my knowledge there is no straight forward way of doing this.

The two options that came to my mind initially are the following:

  1. Building a HTML Table. This is possible within a Text Box. The advantage would be to have everything within one component. The flip-side is that you couldn't filter on the individual cells of the tables and would need to build multiple versions of the same KPI but filtered on specific time intervals.
  2. Manually building a matrix by aligning multiple text boxes and KPI lists/cards. Here the advantage is that you would be only need to filter the kpi lists/cards by the respective time interval. However, the filters would still need to be created as well, but at least these could be reused. The end result could look like this: image

Both options have the limitiations of a static number of entrances in the matrix.

Please le me know if this is helpful and if you have any follow-up questions!

Thank you!

 

Best regards,

Bernardo

Hi Bernardo,

Look it:

 

Matrix Table 1Matrix Table 2 

I created it with each month like a KPI.

 

😀