Perspective - Pivot/Contingency table

Dear friends,
I have to migrate the old MS Acces file, which used a very nice feature the pivot table (similar to excel).
Do you think is there any easy way how to combine table data with the stacked bar chart.

I have to rebuild the following visual:

Thank you for every proposal on how to do it.

no xD

Use the base barchart and just rotate it,
or you could recreate the svgs… make a view of it bind the width and x to the right values…
image

[
  {
    "type": "ia.shapes.svg",
    "version": 0,
    "props": {
      "viewBox": "0 0 100 20",
      "elements": [
        {
          "type": "group",
          "elements": [
            {
              "type": "rect",
              "fill": {
                "paint": "#76F001"
              },
              "stroke": {
                "paint": "#000000",
                "width": "0.25"
              },
              "x": 0,
              "y": 0,
              "width": 20,
              "height": 20
            },
            {
              "type": "text",
              "text": "value",
              "x": 0,
              "y": 15
            }
          ]
        },
        {
          "type": "group",
          "elements": [
            {
              "type": "rect",
              "fill": {
                "paint": "#E5A109"
              },
              "stroke": {
                "paint": "#000000",
                "width": "0.25"
              },
              "x": 20,
              "y": 0,
              "width": 20,
              "height": 20
            },
            {
              "type": "text",
              "text": "value",
              "x": 20,
              "y": 15
            }
          ]
        }
      ]
    },
    "meta": {
      "name": "bar"
    },
    "position": {
      "x": 673,
      "y": 767,
      "height": 40,
      "width": 100
    },
    "custom": {}
  }
]
1 Like

Thank you,
What is the proper way how to work with SVG (bind properties, calculate)?
I just found MarkupEditor and I can use HTML, but when I use the expression to concatenate HTML and bind values, then the SVG is processed and destroyed on the output.
So in the static version, I am able to use it, but I need to link dynamic properties (as you proposed).

Is there any other component or approach I am not aware of?

Thank you

Just copy everything i posted inside the root, thats the component :wink:

Idk why its hidden in the perspective component browser.
i get this by dragging in a symbol factory and deleting all the elements inside xd

1 Like

I owe you a beer, or maybe two. :smiley:

haha no problem :slight_smile: