Question

Hello,

I have 3 databases ENTRIES, ASSETS and STRATEGIES.

In my ASSETS database, I have rollups from the relation ENTRIES database for each strategy calculaling the Win Rate for each page(ASSET). Let's say "Win Rate Strategy 1" and "Win Rate Strategy 2".

In my STRATEGIES database I want to see the ASSET with the highest Win Rate.
Since it's not possible to rollup a rollup. I made formula's in the ASSET database of the rollups "Win Rate Strategy 1" and "Win Rate Strategy 2". Let's say "Formula Win Rate Strategy 1" and "Formula Win Rate Strategy 2".

If I then make rollups in the STRATEGIES database "Check Asset Highest Win Rate Strategy 1" and "Check Asset Highest Win Rate Strategy 2" from the "Formula Win Rate Strategy 1" and "Formula Win Rate Strategy 2" and set the calculation to Max. I now have the value of the Highest Win Rate Asset but I don't have the Name of that Asset. When I add the name to the "Formula Win Rate Strategy 1" and "Formula Win Rate Strategy 2" I can not calculate the Max anymore in the rollups "Check Asset Highest Win Rate Strategy 1" and "Check Asset Highest Win Rate Strategy 2". How can I resolve this?

Kind regards

Answer 1

As you said it is not possible to calculate with text, so you need extra columns. The ones needed to calculate and extra ones with more formulas to show them with text.

Then you can show them as needed in your different Notion views, but all of them are necessary, even if some are hidden in your views.

So keep adding columns as needed to have all the information in the databases to then show them as needed in different views.