X axis date formatting - Table

mpsen · 12-14-2020 08:36 PM

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

Eric_Lyons

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

mpsen

Hi Eric,

Thanks for the solution.

But still i could see months are incremented by 1 not 3(like quarter).

Thanks

Senthil

Eric_Lyons

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