Hey there,
it seems to be a common challenge that is discussed and solved many times. But I wonder if there is a smarter solution.
My Table is structured as follows:
| ContractID | Module_1 | Module_2 | Module_3 |
| ABC | 1 | 0 | 0 |
| DEF | 1 | 1 | 1 |
| GHI | 0 | 1 | 0 |
| .. | .. | .. | .. |
Goal is to create a bar chart in VA (8.5), that shows the share of existing Module_1 (=1) within all contracts.
As there is no categorical variable for the Modules in this "wide" table, I have to transpose it into a "long" version. That's the proposed way to solve that (first sort, then transpose).
But is there also a way to create such a chart within Visual Analytics without creating a second datasource of this structure?
Thanks in advance for your suggestions!
