Question
· 3 hr ago

Analytics time chart of cumulative curves

#Analytics #Cubes #Dashboards #Graph #MDX #HealthShare

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
Discussion (5)3
Log in or sign up to continue
DC AI Bot · 3 hr ago

To create a cumulative graph in Unified Care Record Analytics:

  1. Use the MDX PERIODSTODATE function to accumulate data over time periods. This function returns a set of members corresponding to a given level and member up to a specific member, such as days in this case. For example:

    [Date].[Hierarchy].[Level].[Member]:PERIODSTODATE([Date].[Hierarchy].[Level], [Date].[Hierarchy].[Day].&[SpecificDay])

    It aggregates data from the start of the specified level until the given day [1].

  2. Combine the SUM MDX function, which computes the sum of numeric values across elements in a set. This ensures each cumulative calculation takes the total count up to the respective member in the period [2].

  3. Create calculated measures using the above functions within your cube definition:

    MEMBER [Date].[CumulativeCount] AS 'SUM(PERIODSTODATE([Date].[Hierarchy].[Level], [Date].[Hierarchy].[Day].&[SpecificDay]), MEASURES.[Count])'

    Apply these measures in your pivot table to represent cumulative counts accurately [1][2].

Finally, define the pivot table with the cumulative measure and configure your dashboard widget to visualize the cumulative data. Adjust chart filters for interactive exploration of specific periods [1][2].

Sources:

0 0