Use of metrics in Models

Get Help
1

Hi,
recently I've been testing use of models.
When I work with simple tables, I have a list of defined metrics (as Administrator) with the right calculations
(count if, case when or whatever). I think it's easyer for users to pick up a metric than knowing wichi filters they have to applay to get the right value (For example: Nomber of visitis is countif(Present=1 and tiquet=1))

But with models... there's no metrics predefined option? they don't work?
then, wich is the difference of working with models or having the tables related by administration->metadata of table?

image
image2053×230 14 KB

2

no one?
Now I need metrics to be built considering related tables... is that possible? without having all the information at the same table?

3

I have exactly the same problem.
I think it's imposible to define metrics in models.

4

I don't understand then models... why use them?

5

Correct you cannot define metrics in models.

Agree if you have access to the DB and can simply create a view at DB level then why use a model but using a model allows non technical users to define the data source they want to work with without having to access the Database itself.