Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
for debug purposes I am trying to find a way to find all values which are in use for certain values, because I have a datamodel with a huge amount of fields.
The following example is probably more clear.
lets say this is the abstract structure:
Event | Field1 | Field2 | Field3 | Field4 |
---|---|---|---|---|
Event1 | 1 | 2 | ||
Event2 | 2 | |||
Event3 | 2 | 3 | ||
Event1 | 1 |
From this I would like to have a chart like this
Event | Fields in use |
---|---|
Event1 | Field1 |
Field2 | |
Field4 | |
Event2 | Field3 |
Event3 | Field2 |
Field4 |
I started and trying to build a calculated Dimension around $Field but so far I am not able to get this right. Is there another approach someone would like to share?
thanks a lot,
Alex
Hi there,
no - not yet I wasn't aware of this function which looks really useful to me.
However for my usecase it might be only a last possible option as I there is really a big amount of columns and those are also dynamic and changing,(each column is basically a JSON-property) so I would need to adjust the script when reloaded the data which I would prefer not to do. Also, I would like to do the analysis in chart and not via datamodel
anyway - thanks,
alex
Try this provided if you have that data in any excel file just give that excel path.
CrossTable(Fields, Value)
LOAD Event,
Field1,
Field2,
Field3,
Field4
FROM
[..\Desktop\EgFile_2.xlsx]
(ooxml, embedded labels, table is Sheet1);
Create a straight table chart and use
Dim: Event, Fields
Expr: Value
Thanks,
V.