Visual for count of "active" rows over a time period

[Josh Petersheim]

Hello,

I'm trying to come up with a way to visualize the UniqueCount of the item ids over each week in the 2021 year. For each week, if the week of the row's completed date is

[Fabian Duerr]

Please have a look at this question:

https://community.spotfire.com/questions/counts-over-time

Instead of working with a cross-join method you could also implement a data functions that returns all active items for a given date (loop thru every day, find active items, return combined table of all results; or loop thru every item, find the time period, return table of all results).

The moving average is already available as a standard aggregation method for the y-axis. But first you need to get your data table into the right shape.

[Josh Petersheim]

Thanks for the insight, fabd. Making another table was my first thought too. I was hoping someone had figured out how to do it within the visual itself using the [Axis.X] property.

 

I will give the cross-join a shot and post results.