en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Karol  
#1 Posted : Thursday, October 6, 2016 9:39:51 AM(UTC)
Karol
Rank: Advanced Member

Groups: extranet\Forum
Joined: 5/6/2016(UTC)
Posts: 12

Hi,
Could you please share your experience and knowledge to help me with one issue?

I have a simple table which was achieved by using Visibility Agent and a calculation field:
UserPostedImage

Visibility Agent: hide members:
UserPostedImage

Calculation field: Count - allcount(c1, d1:0(v,s), 0)

What I want to present in Targit is a bar chart that will show quantity of records for each site:

UserPostedImage

Any ideas?

Thank you in advance,
Karol
Ole Arp  
#2 Posted : Thursday, October 6, 2016 11:19:52 AM(UTC)
Ole Arp
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/6/2011(UTC)
Posts: 41

Hi Karol

You can add a visibility agent like this allcount(c1,d-1:0(s),m1)>1 hide member. Then use the visibility property and uncheck "project name"

Edited by user Thursday, October 6, 2016 11:24:11 AM(UTC)  | Reason: Not specified

Med venlig hilsen / Best regards
Ole Arp

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.
Karol  
#3 Posted : Friday, October 7, 2016 6:54:28 AM(UTC)
Karol
Rank: Advanced Member

Groups: extranet\Forum
Joined: 5/6/2016(UTC)
Posts: 12

Thank you Ole for prompt reply.

I'm not sure if I did it in a right way.
When I added new condition in Visibility Agent I get only one line for Romania with incorrect value.

UserPostedImage

Ole Arp  
#4 Posted : Monday, October 10, 2016 9:33:07 AM(UTC)
Ole Arp
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/6/2011(UTC)
Posts: 41

Hi Karol

After I wrote my first reply, I saw that your Count is calculation 2 C2, so try and use C2 instead of C1 in the visibility agent. To troubleshoot further, I will need to see the whole crosstab.
Med venlig hilsen / Best regards
Ole Arp

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error