Forum Discussion
Creating stacked date and time column headers in a matrix visual
I would like to modify a matrix visual displaying time-series data with datetime column headers to have stacked date and time column headers. The matrix visual currently has the following layout:
where the column values come from a datetime field and the table values come from datafields. The row headers are automatically generated based on the value datafields, and I am not using any row datafields. I have Format -> Values -> "Show on rows" turned on.
I would like the matrix visual to have either of the following layouts (preferably the first):
OR
I do have sepearate date and time fields. I have tried a few things that haven't worked, such as using the separated date and time fields and bins for the column values. Is there a good way to create this layout without changing the way I store data?
Thank you,
pv342
I think I found the simplest solution. I achieved my preferred layout by using individual date (first) and time (second) fields for the columns. I right-clicked on the column headers (which were just the dates initially) and selected "Expand to next level", which resulted in a header with hourly times grouped by the date.
3 Replies
i don't know man, but it work. I separate date and time columns and get. try to check format date and time
I think I found the simplest solution. I achieved my preferred layout by using individual date (first) and time (second) fields for the columns. I right-clicked on the column headers (which were just the dates initially) and selected "Expand to next level", which resulted in a header with hourly times grouped by the date.
