Is there an option to use values ​​from other visualizations in calculations?

User_VMJII

Is there an option to use values ​​from other visualizations? For example I want to calculate the ratio between these two (calculation or manual query does not take into account, so I wonder if I can use these two numbers (253,385/355,373) in the further calculation?)

[Deleted User]

Hello @User_VMJII

Can you please update your user profile so we know who we're talking to? Thanks.

With regards to your question that's not really how analytics works conceptually.

Let's assume that your first list is your grand total across all customer and your second one is the top 5 customers with their revenue and you want to calculate how many % of the grand total each top 5 customer brings in.

For that you use the concept of level-based measures. You can tie the measure "Revenue" to the level "Grand Total" of the customer which means it will aggregate it along every dimension present but will not break it down below the level of the grand total for customer.

You can then extend it to break it down only to year level in order to have yearly grand totals by customer, etc. etc.

It's not about "taking one number from a viz". OA since its inception works with models and rules which are then expressed in formula.

That last bit because you can also write this (what I explained above) as formula but if you do it in the metadata you create and manage it once and when there's a change you don't need to go look for 50 formulas.

Cheers