Summarising Data that requires Row Algorithms

Options
Dylan Fitzmaurice
Dylan Fitzmaurice Active Partner
First Comment First Anniversary
edited April 2020 in Platform

Hey Community, 

 

I've been having trouble working out how to display summarised data that requires row calculations. 

Below is some samples of outputs that I would like: 

 

Example 1: 

 

A control dashboard that shows the  total of number of accounts matching a certain condition in a label.

image

Getting a label to simply contain the total for column c in 201808 (38) 

 

Example 2:

 

Summarising a Calculated totalimage

I'm wanting to extract this view and load the summarised results into another cube. (Values 45.25 and 46.24 against the month 201808). Unfortunately it seems that Layout Extracts don't write the totals as a value into the text / csv file. 

 

When I remove the row dimension, this is what my data view does:  

image

 

If you guys could provide some input, that would be fantastic! 

 

 

 

Many Thanks,

 

Dylan Fitzmaurice

Tagged:

Answers

  • Björn Reuber
    Björn Reuber Employee
    Community Captain First Answer First Anniversary 5 Up Votes
    Options

    Hey Dylan,

     

    I assume those 2 blocks are algorithms, so there are some hidden blocks. If so please unhide them that we can see, the source data. furthermore it is helpful to know the formula of your calculation

     

    regards

    Björn

Categories