Forum Discussion

wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
9 years ago

Running total displayed on scatter timeline plot when their are gaps in the data

I have a table of transactions, one row is one transaction, and each has a date.

I want to show this on a timeline scatter chart.

 

Y axis - Store ranking (its positoin compared to other stores)

X axis - total transactions.

 

trouble is there are gaps in the data, for days at a time there may be no transactoins in a store, and on the chart, the bubble just disappears.


Can anyone point to a demo of doing running cumulative totals on a timeline scatter chart? I have not found anything beyond the most basic examples

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi wilson_smyth,

     

    Can you please provide some sample data and sreenshots ? it will be help for troubleshooting.

     

    Regards,

    Xioaxin Sheng

    • wilson_smyth's avatar
      wilson_smyth
      Icon for Post Patron rankPost Patron

      Hi.


      Apologies, I have to mock something up as i cannot put up real data due to NDA's.

      Il get a sample model up and running and upload it in a few days.