Question Elisa Pischedda · Nov 11

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)

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

Product version: HealthShare 2024.1

Comments

Dmitrij Vladimirov · Nov 11

Try this function 

AGGREGATE(%TIMERANGE(YourTimeDimension.hierarchy.level,YourTimeDimension.hierarchy.level.CurrentMember),Measures.YourMeasure)
0
Elisa Pischedda  Nov 11 to Dmitrij Vladimirov

Thank you a lot Dmitrij, 

i used your function in architect defining a Calculated Member, than in analyzer used that member as measure. 

0
Elisa Pischedda  Nov 11 to Dmitrij Vladimirov

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.

0