Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to use two fields as one dimension so I can have the total or use a filter pane to choose either of the fields. At the moment I have "Field 1", "Field 2" and "Total" as three separate fields. I have tried putting Fields 1 and 2 into a master dimension but to no avail. What's the best way to go about this? Apologies if the solution is already posted but I am unsure what to look for even.
Thanks in advance
The best way in my opinion is to already combine these two fields in the load script:
LOAD
Field1 & ' - ' & Field2 AS Field3,
...
RESIDENT
Table;
If that is not feasible, create a master dimension and define it as such: Field1 & ' - ' & Field2.
Thank you for your advice. Unfortunately, It's not quite what I was hoping for. The two fields are values connected to a day. Both field 1 and 2 will have a value for each given day. I was hoping to be able to use a filter pane to select field 1 or field 2 to see the given value for the selected day(s). What do you reckon?
Without knowing much about your data model, here is another suggestion:
FilterTable:
LOAD
%Date,
Field1 AS FieldFilter
RESIDENT
Table;
CONCATENATE (FilterTable) LOAD
%Date,
Field2 AS FieldFilter
RESIDENT
Table;
From the table you have, this script extracts both fields and puts them into a new table with both of the fields then having the same name. %Date would be the link to you original table. Is that more likely what you are looking for? If not, please provide more insight into your data model.
your use case is not very clear, can you post some example / mockup of what you are trying to achieve?
field 1 or field 2 to see the given value for the selected day(s)
are field1 and field2 Dimensions or Measures??
If you just want to show/hide either field1 or Field2 then create a variable with Dynamic Value as below
vChooseField
Dynamic Value = 'Field1|Field2'
Use Variable input as DropDown list
Then in the Chart just add $(=vChooseField) as dimension
you can then toggle between Field1 and Field2 using the dropdown