Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

High density scatter chart based on date

I am struggling with a scatter chart where i am based on date and value.  What I have now is:   And what I would love to have is:  What i tried is:  - high density line chart, it look...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Anonymous,

Can please share some dummy data with a similar data structure to test? It should help us clarify your scenario and test to design scatter charts.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Xiaoxin, 

    I have 2 tables, where I want to connect two columns, one from each table (TestDate and Value). They are connected with ID column. TestDate could be categorized as days or months but when i try to do so, Values are getting sumed up and shows one dot instead of intensed scatter chart. 

     

    I hope it helps somehow to understand what i want to acheive. If not, please let me know. 

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Anonymous,

      I test with some dummy data that similar to your snapshot. I test on 'scatter chart' but found it seems only allows you to use the numeric value on it. In addition, it also not support you to directly show values without aggregation groups.

      If you want to achieve the high-density chart, you need to use the numeric axis to replace the date value first.
      Then you need to expand the table value to add some dummy data based raw values and random offsets to fill the nearest data ranges.

      BTW, you can also try to use script-based visuals with the script to manually plot these graphs.

      Scatter Plots - R Base Graphs 

      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Dear Xiaoxin, 

        many thanks for your input. I tried your solution but again with no luck. I tried to replace the date with numeric value however it always sum up the value even I choose don`t summarize. 

        I "played" around with different options and what i did, is changed from scatter to line chart and almost achieved what I wanted. 

        I see 2 issues now: 

        1. dots cannot be lower than size 5, which I have seen on forums it`s still impossible to go lower and it will be a voting done for it

        2. Dots cannot be clicked/picked as I want. Once I click the specific dot, it takes some from the area (below I clicked the toppest one and it took just random): 

         

        Do you know any workaround for that? This chart takes data as i wanted based on years (which is fine and I couldnt achieve the same on scatter chart). 

         

        Many thanks for your help.