Missing Count Details

[Anonymous]

Hi All,

Please help me on below requirement.

1. I need to Create two buttons  i.e StatusOk and Status NotOk .

StatusOk button which displays the count of status for selected continent from attached sample.

Status NotOk button should display the  count of missing records for the selected continent  based on  the date.

2.On the selection of StatusOk button it should  navigate to the detail table which should display the respective records for the selected continent. and when we  click on Status NotOk button it should  display the missing records(i.e for Continent Asia missing record is 1 on 20170302)

For continent Asia the  StatusOk is 11 and  Status NotOk is 1( because for date 20170302 segment A the region south is missing  )

for continent Europe the StatusOk is 12 and  Status NotOk  is 0

Continent	Segment	Region	Date	Status
Asia	A	North	20170301	1
Asia	A	South	20170301	1
Asia	B	North	20170301	1
Asia	B	South	20170301	1
Asia	C	North	20170301	1
Asia	C	South	20170301	1
Europe	A	North	20170301	1
Europe	A	South	20170301	1
Europe	B	North	20170301	1
Europe	B	South	20170301	1
Europe	C	North	20170301	1
Europe	C	South	20170301	1
Asia	A	North	20170302	1
Asia	B	North	20170302	1
Asia	B	South	20170302	1
Asia	C	North	20170302	1
Asia	C	South	20170302	1
Europe	A	North	20170302	1
Europe	A	South	20170302	1
Europe	B	North	20170302	1
Europe	B	South	20170302	1
Europe	C	North	20170302	1
Europe	C	South	20170302	1

Thanks in advance

[Anil_Babu_Samineni]

Confusing to me, Can you share output needs while you click the two buttons. What is the output if you select StatusOk and What if you slect Status NotOk

[Anonymous]

[#4]

Hi,

Hope this helps.

[#5]

Hi,

I am assuming that there will be a filter of Continent.

Made 2 buttons of Status Ok  and Status NotOk and made 2 text boxes for respective button:

Variable1=GetFieldSelections(Continent)

Status NotOk(Textbox Expression)=count({<Continent={"$(Variable1)"},Date_1={'20170301'}>}Status)-count({<Continent={"$(Variable1)"},Date_1={'20170302'}>}Status)

StatusOk(Textbox Expression) =count(Status)

Regards,

Sanya Chauhan

[Anil_Babu_Samineni]

Can you check may be this you are looking?

[Kushal_Chawda]

Hi kavya,

I have already replied to your question on below link. Please check on that.

Re: Help on button creation‌

Please don't create the duplicate threads. It is hard to refer.