Solved: Multiple filters/slicers in a chart

vicks88980

Hi frends,

I have a column date and associated users.

in charts, i want to show only those dates which are in future.. something like those are follow up dates. but it should show userwise and followupdate greater than today

How to do it? pls help

SURYATEJ

In order to achieve your result,

Go to the Data > Slices tab in your AppSheet editor.>Define a condition to filter out only future dates. For example, you can use an expression like [FollowUpDate] > TODAY().

Also for user to user slicing you can select the data and in slice you can mention

if your app is running on useremail basis

"[Email Id] = USEREMAIL()"

or

if your app is running on user name basis, then you need to define using if function as

IF(logical-expression, value-if-true, value-if-false)

[USER] = IF(USEREMAIL()=xyz1@xyz.com,ABCDE1,IF(USEREMAIL()=xyz2@xyz.com,ABCDE2,IF(USEREMAIL()=xyz3@xyz.com,ABCDE3,"")))

Result will be:-
if useremail is xyz1@xyz.com & the user name is ABCDE1 then the data created by the user will only be visible. if not then it will pass on to next user and so on.

View solution in original post

SURYATEJ