Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
In the report I am creating, I have 15 minutes data across different units.
There is a time dimension data goes from the 15 minutes to the hour and then to the day -> month -> year.
There is an asset hierarchy that goes from a unit to a site -> region -> country and so on.
The fact table reporting data is linked from one side to the 15 minute intervals table and on the other side to the unit table.
Not all the units started to log data at the same time.
I want to calculate how many samples are expected from a unit since when it started logging to today. This numeber may vary if I restrict the date range, to its min and max date.
This is the Measure I created, which performs the calculation as I expect:
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |