Hello Tableau Community,
I need help on a situation that I am in. I need to make a sheet that gives us what the ticket provider is for each organization. This is what my sheet looks like now:
To get this in the tooltip I created a calculation that if the value is null for the variable tm_event_type than it would say Tickets.com in the tooltip and if it is null for the variable tdc_event_type then it would show Ticket Master in the tool tip. This is what my 2 calculations looks like:
IFNULL([tm_event_type],'Tickets.com')
IFNULL([tdc_event_type],'Tickets Master')
My problem is that I need to some how get these two calculation combined into one calculation so that in the tooltip it only shows the ticket provider for each and that it because right now in the tooltip it shows the ticket provider and something else which I don't want. Would someone please help me in this situation that I'm in?
If ISNULL([tm_event_type]) THEN 'Tickets.com'
ELSEIF
ISNULL([tdc_event_type]) THEN 'Tickets Master'
END
