I have a weird situation where I would like some help.
I have a histogram created in Qlik Sense that is displaying the open tickets per hour. To display that, I use the 'created time' field of the tickets that I have converted in hours. So basically the x-axis of the chart will look like the screenshot in the attachments.
My question now is the following - the 'created time' field that I use contains time in different time zones, so how can I make sure that the users will be looking at their desired timezone for all tickets?
PS I tried creating an inline table with different time zones and then add them as buttons, but this solution doesn't work for me as it will show only the tickets that have that time zone in their 'created time'. What I want to accomplish is view ALL tickets in different time zones...