Forum Discussion
To show three dates in column
Hi Anonymous ,
You can achieve this by placing the Category field above Date field in Columns section and then click on the below drill down option to show both levels in Matrix visual.
Hope this helps!
Please accept the solution if this answers your query.
Thanks,
Avantika!
Hi Anonymous ,
Few checks that you can do :
1) If all the dates are available in one single Date column, you can make its summarization as "Don't Summarise"
2) Now put the Date column in Matrix - Columns to view the selected dates
3) Please Note, if you are using the Table visual - it will show all the dates as rows in one single column and won't be able to separate out in separate columns. Hence its recommended to use a Matrix visual in this case.
Hope this helps!
Thanks,
Avantika
Hi Avantika-Thakur thanks for the answers, in matrix it's worked one more point is the date will come under categories like below, I have to achieve like this
| category 1 | category 2 | |||||
| country | Mar-21 | Jan-22 | Feb-22 | Mar-21 | Jan-22 | Feb-22 |
| A | 22 | 35 | 63 | 20 | 30 | 60 |
| B | 25 | 67 | 45 | 22 | 65 | 43 |