I am trying to convert the date filed from y axis to X axis ,but unable to format it. Also my date should be captured 3 months interval in x axis . Need to plot the similar table as per attached image.Someone help on this
Period | 10/1/2019 | 1/1/2020 | 4/1/2020 | 7/1/2020 | |
Dimention fields | |||||
new Ex | 2323 | 323 | 454 | 6766 | |
Exs Ex | 3434 | 4343 | 454 | 4343 | |
Total Ex | 5757 | 4666 | 11109 |
Hi @mpsen,
Could you pivot on the date and use a custom filter similar to the example below so you only show every third month? I used a custom filter where we extract the value of the month and subtract one. Then, determine if this value is a multiple of 3. If it is not, we filter it out. The field I pivoted on was a month value from a dimension group. We want to make sure dimension fill is turned off on the date field though for the date field.
The end result looks like this:
Please let me know if you have any questions.
Thanks!
Eric
Hi Eric,
Thanks for the solution.
But still i could see months are incremented by 1 not 3(like quarter).
Thanks
Senthil
Hi @mpsen,
If you hover over created month in the data tab can you select remove filled in dates? The other thing you can do is use the quarter timeframe in the dimension group rather than month.
Please let me know if that works for you.
Thanks,
Eric
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |