Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dataset with 3 columns
ErrorID Status Priority Date
101 Assigned High 01/04/2016
102 Resolved Medium 01/04/2016
103 Closed Low 01/04/2016
104 Assigned High 04/04/2016
105 Resolved Medium 04/04/2016
106 Closed Low 05/04/2016
107 Assigned High 11/04/2016
108 Resolved Medium 11/04/2016
109 Closed Low 11/04/2016
Dimension : ErrorID,Status,Priority
Expression : Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID) + Count({<Status={'Assigned'},Priority={Low},Date={>Date('03/04/2016')}>}ErrorID)
O/p
ErrorID Status Priority Count
107 Assigned High 1
106 Closed Low 1
109 Closed Low 1
Now I want to add link on ErrorID. how do I do that. So that when I click Error ID it takes user to web page
Check the attached now
May be like this?
Sunny Thanks for the Help.
There is small change in the Expression i forgot to mention in the previous post
Yes with one Countit is working
Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID)
but i with two Count im not getting
Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID) + Count({<Status={'Assigned'},Priority={Low},Date={>Date('03/04/2016')}>}ErrorID)
Check the attached now
Thanks sunny .
It Worked