Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis

[himani_a_agrawa]

Hi All, 

Please help me building logic on below scenario. 

I have a data(attached), in which there are many device saying A/B/C.., with their server up/down status being 1/0 respectively and dates(24 Hour) correspondingly to it. 

What I want here is to Count No. of distinct devices in a dataset, which are UP in entire day for atleast once. Means, If any device is Up i.e 1  for atleast once in a day, then it is counted as 1, and check for other devices and count the others similarly.  and finally show the total UP devices Reported. Vice Versa for the devices which were Down whole day. 

I am sorry, if I am putting this again, But I did'nt find any post regarding this. 

I am not sure which function/loop will give the correct logic? Can we do it through loop, or set analysis can do this?

I am attaching a sample qvw with sample data-set, if anybody can help in building this logic, will be appreciable.

Thanks

[himani_a_agrawa]

Can you please explain me your logic, I am unable t collect facts. 

Also, How can we use expression, to exactly count no of devices down for 3/7 days. 

[vvira1316]

Hi,

There was an error in calculation that I've corrected. I've included new QVW file as well as an Excel file that will help you understand the data scenario.  You can compare information between Excel and QVW.

I hope explanation in word document will aid in understanding.

Data Model can be cleaned up and some additional/meaningful flag can be created for calculations.

KPIs and Expressions will have to be worked out using Set Analysis.

Let me know if you will need any further help.

BR,

Vijay

[himani_a_agrawa]

Can we simplify the data model, since I already have other data table, which is making it more complex.

Attached is the snip of showing my data tables.  

[vvira1316]

Here is the simplified file