Is there any specific reason to have this chart in your report?
Jitters plot could be the ideal approach for such data: I’ve Got the Jitters (and I Like it!) – Data Revelations
Let us know if this help.
Thanks for your response. Each mark represents that a record of text entry has been made in the underlying data source for a specific client and date range. Tooltip hover then displays details of text entry.
This is a better view than simply showing a cross tab with multiple columns and sizable free text field. I couldn't think of another way to structure the visualisation. That said, I'm open to suggestions??
I figure this is my chance to challenge the user request for a table.
Bump. I've looked further for a potential solution to my problem and the reason I don't have a horizontal scroll bar is because I don't have a measure on rows or columns. This is well documented in a few threads over the years, predominantly relating to text tables. Here is an explanation from the Tableau Knowledge Base: Horizontal Scroll Bar Missing | Tableau Software
Can anyone think of a work-around to create a measure which will return the visual result I am after (i.e. the same visual layout as per screenshot)? I have experimented with using a date field, however this assigns marks to specific dates and therefore I don't get the stacked representation.
What I am trying to show is really a frequency dot plot. A mark to display for each record against a client for the selected month without the dots (...) appearing. Would a rank calculation work in this instance? That is, the first record in the month for each client is assigned 1, the second record assigned 2, and so on.
Hoping someone may be able to help. Thanks in advance for any help you can provide.