Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

KPI Visual showing Blank when target is added

Hi, 

 

I have come across a strange behaviour of the KPI-Visual that I seem not be able to solve:

 

I Have two measures. One of them calculates some percentage the other one just uses a simple formular to "calculate a fixed target":

value 0.97 = 0,97

 

I want to use these two Measures in a KPI Visual but get Blank as result. The interesting thing is, that if I switch aroung "indicator" and "target goal" I get a number. But of course the number is wrong for my purpose.

 

Also when I just add the indicator without the target I get a number back. Only when I combine the two fields  in one certain way I get Blank.

 

I have no clue what causes this behaviour. I would at least have expected that it shows BLANK in both cases. Here is a picture that explains the problem:

 

 

Thanks in advance for your help.

 

BR,

Torben

Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    Please refer to the following example:

    Assume that I have a table like below:

    Then I create a measure as the target like below:

    value = 205

    Then drag these columns to the related field, the result like below:

    Best Regards,

    Teige

5 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous ,

    Please refer to the following example:

    Assume that I have a table like below:

    Then I create a measure as the target like below:

    value = 205

    Then drag these columns to the related field, the result like below:

    Best Regards,

    Teige

    • varamati's avatar
      varamati
      Regular Visitor
      6 years ago

      TeigeGao ,

      In the example specified, I want to have a dynamic goal i.e median(column1). How can I specify goal here?

       

      If I create a calculated measure for the median to fix this, it is rendering blank.

       

      Thanks in advance,

      Veda

  • BSacchini's avatar
    BSacchini
    Frequent Visitor
    7 years ago

    Hello. I am having the same problem.

     

    I know why it is happening although I havent been able find a way around the issue.

     

    I created two measures: 1) A measure I want to track using KPI and 2) A "fixed" measure that indicates the treshold for my KPI goal (e.g: 10). 

    When I create my KPI I want it to have a trend axis (date hierarchy by months). 

     

    So basically the problem is that my first measure (the one I am looking to track) comes from a table that is up to the maxcurrentdate, while the second measure (the fixed goal) comes from a table that is populated for the entire year (see picture). So logically the KPI will analyze the last given month, which has a Fixed Goal but has no value for the measure that I want to track, hence I get the BLANK result.

     

    How do I set my Goal Measure to only provide values for current or past months?

     

    Thanks

     

     

     

  • MyriamW's avatar
    MyriamW
    Frequent Visitor
    3 years ago

    Have you solved the problem? I am facing the same issue.

  • Chris001's avatar
    Chris001
    New Member
    1 year ago

    I had a similar issue, but found the problem. The trend axis and the indicator axis have a different "behaivior". If you remove the traget goals, than (I assume) the last not blank value is shown. If you add a singel target, the last value (blank or not) will be compared with the target. You can make this visible by activating the "Date"-Field in the formating menue. By manually filtering the trend axis, I solved this problem.
    In the example I had no value for August, but for June. So I only display June and before.