Forum Discussion

Selwynster's avatar
Selwynster
Helper II
8 years ago

Scatter chart or Clustering chart

Not sure if this is possible, but I would like to place Dates on the x axis with Occurrences of an event on the y axis. So if the event occurred on that date, it would be marked on the graph by a do...
Need Help
Selwynster's avatar
Selwynster
Helper II
8 years ago

Hi Anonymous

Below is a small sample of my very long table.

I have all the Dates i need in this table. Do i need to split the table out?

DateEvent
1/1/2018A
1/1/2018B
1/1/2018C
1/2/2018A
1/2/2018B
1/2/2018C
1/2/2018D
1/3/2018A
1/3/2018B
1/4/2018C
1/4/2018D
1/4/2018E
1/4/2018F
1/5/2018D

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Selwynster,

 

Your table not need to be transformed, you can direct use it to achieve your requirement. 

Drag date to axis and switch to normal date mode, event column to value field with summary mode count.

 

Notice: scatter chart seems not support to use data column on x-axis.

 

Regards,

Xiaoxin Sheng

  • Selwynster's avatar
    Selwynster
    Helper II
    8 years ago

    Thanks Anonymous

    But i need it on a Scatter or clustering chart

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Selwynster,

       

      Which visuals you want to use? I already create graph on a clustering chart. For scatter, it seems like date type not available on axis.

       

      Regards,
      Xiaoxin Sheng