Set Analysis

[himabinduch]

Hi All,

in my dashboard i have data like below

STATUS	VERSION_NAME	=Count(DISTINCT(ISSUE_COUNT))
Analysis	20170224	3
Backlog	20170224	2
Backlog	-	2
Backlog	20170217	3
Development In Progress	20170224	11
Done	20170224	6
Done	R-Done	180
Gather Requirement	20170224	3
IT	-	1
IT	20170224	38
POC	20170224	2
Prod Validation	20170224	1
QA Approval	20170224	9
SA Approval	20170224	6
Tech Lead Review	20170224	3
UAT	20170224	3

if the expression  as Count(DISTINCT{<VERSION_NAME= >}ISSUE_COUNT)  it should not change the values according to my version_name field, in my case it is working fine but  when i am giving sort condition it is not working please help me out on the same please find my sort condition as well.

If(STATUS='Backlog',1,

  If (STATUS = 'Gather Requirement',2 ,

  If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 ,

  If (STATUS = 'Tech Lead Review', 10 ,

    If (STATUS = 'Ready for Development',15 ,

     If (STATUS = 'Development In Progress',20 ,

      If (STATUS = 'QA Approval' or STATUS='SA Approval',25 ,

      99 //Done

      )

     )

  )

    )

  )

  )

   )

Thanks In Advance.

Regards,

HimaBindu Ch

[Anil_Babu_Samineni]

What are the values of ISSUE_COUNT and what is the o/p

[himabinduch]

ISSUE_count has issue id please find the below

6027113
6027114
6027115
6027274
6027329
6027368
6027375
6027447
6027462
6027483
6027490
6027493
6027496
6027497
6027498
6027585
6027591
6027593
6027596
6027597

[Anil_Babu_Samineni]

What is the o/p you want to see

[himabinduch]

i want to see the count of issue_count and it shouldn't effect if i select by VERSION_NAME and i want to sort the order as based on the below condition.

If(STATUS='Backlog',1,

  If (STATUS = 'Gather Requirement',2 ,

  If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 ,

  If (STATUS = 'Tech Lead Review', 10 ,

    If (STATUS = 'Ready for Development',15 ,

     If (STATUS = 'Development In Progress',20 ,

      If (STATUS = 'QA Approval' or STATUS='SA Approval',25 ,

      99 //Done

      )

     )

  )

    )

  )

  )

   )

[sasikanth]

HI,

If it for Only sort you can try INLINE Load /Match() function

in sort tab-->Expression

=Match(

STATUS,

'Backlog',

'Gather Requirement',

'Analysis',

'IT',

'POC',

'Tech Lead Review',

'Ready for Development',

'Development In Progress',

'QA Approval ',

'SA Approval')

OR Inline  LOAD in script

LOAD * INLINE [

STATUS

Backlog

Gather Requirement

Analysis 

IT

POC

Tech Lead Review

Ready for Development

Development In Progress

QA Approval

SA Approval

];

[Anil_Babu_Samineni]

May be try something like below for removing selection for one Field

Count({<VERSION_NAME= ::VERSION_NAME>} DISTINCT ISSUE_COUNT)

From below expression you can try from Script level then tell me what is your intend to sort

If(STATUS='Backlog',1, If (STATUS = 'Gather Requirement',2 , If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 , If (STATUS = 'Tech Lead Review', 10 , If (STATUS = 'Ready for Development',15 , If (STATUS = 'Development In Progress',20 , If (STATUS = 'QA Approval' or STATUS='SA Approval',25 , 99)))))))

I didn't understand this above one where you want to course this