cancel
Showing results for 
Search instead for 
Did you mean: 

Tips on Managing Formulas / Getting Consistent Calculations

hlorosc
9 - Travel Pro
9 - Travel Pro

Question for y'all: How do you maintain consistent calculations of key metrics? 

Custom columns in the data model won't work b/c I need aggregations that can be easily filtered (e.g. can't add activation % to my base table b/c my stakeholders want to know what it is for different industries etc).

Formulas work great, but there isn't an easy way to lock them so I know the other analysts use the exact same ones. Plus, if I change the underlying data model or if I decide to update the formula, I have to start over.

Would love to know how y'all deal with this? In case it matters: we have a Sisense hosted deployment and are leveraging live models

Look forward to learning from what's worked in practice!

4 REPLIES 4

irismaessen
11 - Data Pipeline
11 - Data Pipeline

We're in a situation where our dashboard design is done by a very small number of people and dashboards can be audited before going live so we haven't had to be creative in this regard.

What I've found happening often is that widgets get copied from already audited dashboards and then adapted further, using the authorised formulas. But this is not immune to changes in the authorised formula or the data model. Once a widget is copied, it is its own thing.

Starred/Names formulas are I think the official way to share predefined formulas for metrics with other analysts. What you cannot do, however, is force people to use them, or stop defining other named formulas themselves. And indeed, if you change the datamodel or the formula, you still need to start over because I think old widgets/dashboards will keep using the old formula. I'd love to be wrong on that last one.

I think documentation here is important no matter what you do. Not only does that allow you to explain exactly what each metric calculates, it also lets you explain how that metric is arrived at and what the limitations are (for instance, filter-wise). People should want to be using the same, relatively simple, formulas because that means they can properly compare numbers.

 

 

 

Ophir_Buchman
12 - Data Integration
12 - Data Integration

Hi @hlorosc ,

@irismaessen is correct - The right way to deal with this is "Starred Formulas".
Take a look at this page for details: https://documentation.sisense.com/l2021-9-x/docs/reusing-formulas

Ophir

Ophir,

It would be great to have the ability to lock a starred formula or even better centralized formula management.  One of my customers is starting to give a few of their customers design privileges.  It's fine for them to create their own starred formulas, but we really don't want them changing existing formulas and starring them without changing the name.  If they were to do that, we might inadvertently use a starred formula without realizing it has been changed.  

I know that centralized formula management has been talked about for a while.  Is there any movement there?

Regards, Jim

Ophir_Buchman
12 - Data Integration
12 - Data Integration

Hi @Silutions,

Your idea has been submitted to the Sisense UserVoice (under https://sisense.uservoice.com/forums/930613-dashboarding-reporting-tomer/suggestions/44688790-idea-r...)

Ophir