Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In our report we have a selector box in front end dashboard and filter source having having two values as:-
Order
Backorder
I need to create a third value as 'ALL'(Order+Backorder), so that user should be able to select this 'ALL' from the drop down.
so now it should be:-
Order
Backorder
ALL
Please suggest how can I achieve this.
you can add in your script as below:
link_table:
load
'Order' as current_field
'Order' as new_field
Autogenerate 1;
load
'Backorder' as current_field
'Backorder' as new_field
Autogenerate 1;
load
Order' as current_field
'ALL' as new_field
Autogenerate 1;
load
'Backorder' as current_field
'ALL' as new_field
Autogenerate 1;
in the UI use new_field as filter.
Hi Andrea,
Thanks for your response.
I tried to implement this, but how can we link this table with our fact table, as source field is from the fact table.
Because if I check in data model , there is no link between link and fact table.
you have to rename new_field as your fact table field.
But for what? If there is nothing select in filter you already get Order+Backorder...
Hi Vasiliy,
By default 'Order' value should be selected.
Hi Andrea,
If I set' Order' as default value then 'ALL' filter is not working.
It allows to select the 'ALL' from the drop down, but the same time it's reflecting back to Order data.