i am unable to execute the following query in tableau:
count(if [CATEGORY]<> "Other" or [CATEGORY]<> "Cisco WebEx Connect" or [CATEGORY]<> "Cisco Jabber" AND
ENDSWITH([URL],".webex.com" ) or ENDSWITH([URL],".mywebexpc.com" ) or ENDSWITH([URL] ,".webexone.com" ) or
ENDSWITH([URL] ,".webexworkspace.com" )
AND [Web_Ver] = "" or
[CLUSTER_X] = "" or
[CSM] = "" or [DB_Status]="" then [CASE_ID_] end)
can someone tel me what is the problem ??
What error you are getting? Also try to use proper brackets between the OR and AND, so that you will get desired result.
Prashant Sharma - India | LinkedIn
yes it was because of the brackets
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...