Analytics time chart of cumulative curves
Hi everyone, on HealthShare Unified Care Record 2024.1.0 Build, we're using the Analytics section to create a dashboard containing a time chart showing a cumulative curve of the number of documents indexed in the registry for each documentSource of each repository. We tried the following steps: we created a cube whose dimensions are the CreationDate, SourceValue, and repositoryUniqueID of the HS_Registry.Document table; in the Analytics section, we created a pivot table that lists the document creation date on each row, along with as many columns as each repository's documentSources. However, the table displays the number of documents indexed on that specific day, not the cumulative number of documents indexed up to that day. We tried creating a calculated measure in the cube using the MDX sum function and the MDX periodToDate function, but we're unable to achieve the desired result. Can you help us create the right pivot table to obtain the cumulative graph we're interested in? Thanks everyone,
Elisa
Following,
1) a mock graph of the information we would obtain (cumulative curve of the document indexed up to each day per source/repo).png)
2) the time chart we created in analytics at the moment (number of document per day for each source/repo) and the corresponding pivot table.png)
.png)
Comments
Try this function
AGGREGATE(%TIMERANGE(YourTimeDimension.hierarchy.level,YourTimeDimension.hierarchy.level.CurrentMember),Measures.YourMeasure)Thank you a lot Dmitrij,
i used your function in architect defining a Calculated Member, than in analyzer used that member as measure.
Have you tried what the bot recommended?
I tried 'SUM(PERIODSTODATE([Date].[Hierarchy].[Level], [Date].[Hierarchy].[Day].&[SpecificDay]), MEASURES.[Count])'
but i obtained a pivot table with all cells full of 0.
I got what I needed with the function you suggested.