I have this fact table
CheckTime | Error | Marker (1 or 0) |
2019-01-01 00:01:00 | 1 | 0 |
2019-01-01 00:02:00 | 5 | 1 |
2019-01-01 00:03:00 | 2 | 0 |
And the cube which is pretty much 1:1.
I have build an MDX:
InterSystems IRIS BI (DeepSee) is a Business Intelligence (BI) technology that enables the real-time analysis of transactional data, and is designed to be optimal for embedding within transactional applications.