x-axis labels crowded. change to every other-every 3 labels

[Anonymous]

I have a graph which looks like this

the x-axis as you can see is very busy with every single month/year.  is there a way to adjust it so that every other month/third month is showing?

[Anonymous]

this still has every data point on the x-axis labeled with something, so it's till crowded.  i want to label every other data point/every 3rd data point, to make space between the labels.

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

yes!  here is 3 months of data.  i was having probs with it as a table, so i converted to comma delimited.  you can see from the graph i have many more.

Year Month, Default Channel Grouping, Sessions

Jun-19, Organic Search, 236792

Jun-19, Email, 199

Jun-19, Social, 2574

Jun-19, Referral, 33405

Jun-19, Direct, 52005

Jun-19, (Other), 3

Jun-19, Display, 1

Jul-19, Email, 24

Jul-19, Referral, 36070

Jul-19, Social, 2923

Jul-19, (Other), 4

Jul-19, Organic Search, 232708

Jul-19, Direct, 55516

Aug-19, Email, 15

Aug-19, Social, 3764

Aug-19, (Other), 13

Aug-19, Direct, 64015

Aug-19, Organic Search, 248389

Aug-19, Referral, 37672

[Anonymous]

HI @Anonymous,

You can change the date field to hierarchy mode and keep year, quarter, month levels and turn off the concatenate label option, then this graph should show more simple than currently displayed.
Regards,

Xiaoxin Sheng

[Nathaniel_C]

Hi @Anonymous , try this from another post. 

How To Change X-Axis Labeling  

It sounds like you want to group your axis label based on category fields. If this is a case you can enable this effect by modifying the x-axis type to 'categorical' and turn off the 'concatenate label' option. (notice: don't forget to set 'sort by' current axis fields to enable axis grouping)
Regards,

Xiaoxin Sheng

[Anonymous]

Not quite.  I don't want to turn off concatenation because it makes the rest of things i'm doing incoherent.  I've somehow been able to do it before, like below

[Anonymous]

HI @Anonymous,

I test with the chart but not found the option to achieve your requirement.
Perhaps you can add a calculated column to regroup your records then use that as the axis of your chart to show the custom summary level.
Regards,
Xiaoxin Sheng