I am looking to calculate number of instruments Installed per month.
As long as an instrument still have status installed then count.
If a site has a total of 20 installed instruments, I want to visualize monthly. E.g July = 20 installed, August = still 20 installed and if one instrument changes status in September then = 19. I don't know how to do this, any ideas?
Hi, @Michael Madisha
I'm not sure if this is what you're looking for, but please take a look.
Is this data being overwritten with the latest version each time?
If so, it seems that monthly performance records may not be retained, so some form of logging might be necessary.
For example, you could
(1) use Tableau Prep to export the data as a CSV file on a fixed day each month,
or (2) if you have Tableau Server or Tableau Cloud, publish the data source there.
In case of (1), you could merge the monthly CSV files to build a historical dataset.
If using Server or Cloud, you might need to implement an incremental update strategy to accumulate the data over time.
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
