Hi,
I’m struggling with a problem that seems a little more tricky than initially thought.
My customer publishes articles on a regular basis. Their customers can login to a portal and download these published articles, with all downloads recorded in a table.
The calculation I’m trying to produce should be able to evaluate 2 articles at a time (the one being evaluated and the previous one) and work out whether the contact download the first AND the second of the two evaluated articles. If this is true, this should count as 1.
I have produce the figure required below – however with only a single contact highlighted at a time. I need to aggregate the required expression across all contacts which I have struggled to do. To be clear, if another contact had dowloaded Stories 1 & 2, I would expect to see 2 on the Story 2 record to show that 2 contacts had downloaded Stories 1 & 2.
| Contact | Article | DownloadCount | The required value I want is | Explanation |
| Haider | Story 1 | 1 | 0 | First Article - nothing to compare against prior |
| Haider | Story 2 | 1 | 1 | User download Story 1 And Story 2 - this needs to be counted |
| Haider | Story 3 | 1 | 1 | User download Story 2 And Story 3 - this needs to be counted |
| Haider | Story 4 | 0 | 0 | User download Story 3 But Not 4 - this needs to be ignored |
| Haider | Story 5 | 1 | 0 | User download Story 5 But Not 4 - this needs to be ignored |
| Haider | Story 6 | 1 | 1 | User downloaded Story 5 And Story 6 - this needs to be counted |
To make things a little more tricky, I need to the table to always show all articles, even if one has 0 downloads.
Example app and data attached. Thanks - Haider
