Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have attached a screenshot of the sheet.
Where i have used the image and text objects and Filter pane.
The issue is the default data is displaying without any selection in filter pane.
I need to exclude the default selection and the data should display only when the selection is made in filter pane.
Help on this.
Thanks,
Pramod
Why is your data not in charts or table objects?
Hi Toni Kautto,
I have used the "Text and image object" to display the data.
You can see in filter pane i have not selected any data. but also it is displaying the data.
i need that should be blank till i select value in filter pane.
Thanks,
Pramod
Hi Pramod,
you can use Only( ) function:
=Only(' .. your text with data .. ')
- Ralf
Hi Ralf Becher,
It's work fine for some data. But for set analysis it's not working.
Concat(DISTINCT subjectid, '-', subject_access_track_id)
count({<subject_status = {"Passed","Completed"}>}DISTINCT subjectid)
Would you please help how to use only() to the above expressions.
Thanks,
Pramod
Could you upload a sample app?
Hi Ralf Becher,
Please find the attachment
Thanks,
Pramod
Hi Pramod,
Try using Clear all thro Triggeres is Sheet or Document properties.
Where is it?
sorry,
will you please help me how to produce sample app?
Thanks,
Pramod