Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a main fact table, and for each record, a 'many' table lists various tags (key-value) .
Currently I have a simple bar chart with elements from the fact table only :
This tells me, how many items I have in each category.
Then using Filters from my [tag] table, I can select to see how many [id] in each category have a tag with key of Size (or Weight or Colour).
But now I want to count the inverse.
So for each Category, the number of [id] that do NOT have a tag with key 'Colour|Size|Weight'
Hope someone can give a nudge in the right direction !?
Thanks if you can !
Table: Fact | Table: Tags | ||||
Field: Id | Field: Category | Field: Id | Field: Key | Field: Value | |
A | Cat 1 | A | Colour | string | |
B | Cat 1 | A | Size | string | |
C | Cat 2 | A | Weight | string | |
B | Colour | string | |||
B | Size | string | |||
C | Colour | string | |||
C | Size | string | |||
C | Weight | string |
Hi,
I think you would want to do joins in your script to create fields on your fact table for Colour, Size & Weight. You would then need to rework your other visualisations.
If you don't want to do that you could try something like the below, but note it is fragile, so if I select Key=Weight then I am not sure it gives the behaviour you would want. You would then get into using set analysis to stop selections applying ... which is where you should start to look back at if your data model is working for you 😀.
Cheers,
Chris.