resolve problem without touching datamodel

[zied_ahmed1]

Hello everybody,

Thanks for your answers. I attached an example of the application.Just one thing when I selected Color in Exist  I can't select it in not exist

so now for example when I select color in Exist and  Entreprise  in not exist I will have a table with just one row with the hostname X

Hope you understand how I need to do

Thanks

omarbensalem‌

[OmarBenSalem]

what are those?

[zied_ahmed1]

Sorry...

[zied_ahmed1]

if for exemple we select Statut Exist and Entreprise Not Exist we will have just the row Hostname x.

[OmarBenSalem]

Now please explain in better words with some examples;

if u select statut in exist what happens?

if u select statut in exist and rentrprise in not exists, what should happen?

etc

[OmarBenSalem]

but u can't select both Statut in exist and ntreprise in Noty exists:

[zied_ahmed1]

Okay..

I used to do the same model but in the real model when you select Color in Exist field it will be disable in the field not Exist

For the example like i said , if select Statut in Exist (Exist is like Statut = 1 in table ) and Entreprise in Not Exist (it means 0 in the table )

-> I will display just the row of hostname X

[OmarBenSalem]

Then reattach an application like the real model, PLEASE.

[zied_ahmed1]

I can't export the application that's why

[OmarBenSalem · Accepted solution]

For me the easiest way to achieve this is to add 2 columns in your final table:

Controler1:

=if([Not Exists]='Statut', aggr(sum({<Statut={0}>}1),Hostname) ,

if([Not Exists]='Entreprise', aggr(sum({<Entreprise={0}>}1),Hostname) ,

if([Not Exists]='Color', aggr(sum({<Color={0}>}1),Hostname) ,Statut )))

Controler2:

=if(Exist='Statut', aggr(sum({<Statut={1}>}1),Hostname) ,

if(Exist='Entreprise', aggr(sum({<Entreprise={1}>}1),Hostname) ,

if(Exist='Color', aggr(sum({<Color={1}>}1),Hostname) ,Statut )))

Result:

Example,

exists ; Statut

No exists : color:

=>