Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello every one,
I have a report which displays some graph according to a chosen workstation in the search bar.
If I choose no workstation, all the workstations will be displayed in the table and in the graphs it will be the total of all the workstations.
I wish that at the opening of report no particular workstation will be selected by default and that the table and the graphs will be empty ( no data).
Any idea please ?
Thanks
HI @lorita2021
Try like below
In the chart,
Properties -> General tab
=GetSelectedCount(workstationfieldname)>0
---
Chart will display only atleast one workstation is selected.
For clear all workstation, you can add Onopen trigger in Document properties
Thanks for your reply, but this solution does not meet my need 😞.
I want that at the opening of the dachbord there will be no workstation selected and that all the report elements will be empty of data. if i don't select any one , all workstations will be selected by default
I need to add a null value in a filter along with other values for a field workstation. how can I add a null value among the choices please?
HI @lorita2021
You can hide the entire chart / show the chart based on condition.
You can add null value in the script or NA in the script for null values. Can you elaborate ur requirement with some sample data.