Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Requirement is to, Include option ‘All’ in the period selector. which allows the user to select all data, rather than limiting the data to a certain period.
I have created a data island table for this and the script for data island table is like below:-
v_periods:
LOAD
period_type as %period_type,
period_type_description as %period_type_description
FROM [$(vQVDLib)v_periods.qvd](qvd)
where period_type='fin_ytd' or
period_type='fin_month' or etc;
left join v_periods:
LOAD
%period_type,
%period_set_analysis
FROM [$(vExternalDataLib)Frea_Periods.csv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
Based on flag calculation like (if(fmonth_offset = 0,1,0) as [Current Month-flag],) it's picking the values for different selector.
In my dashboard filter box is like:-
select period
current month
year
financial year
How can I include 'ALL' as another filter in this period selection box?? please suggest
Thanks
Is this for the use in a KPI object?
Otherwise you could just deselect all values and this would result in being shown all the data.