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
Solved! Go to Solution.
Hi @TorbenM ,
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
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
Hi @TorbenM ,
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
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
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
360 | |
105 | |
63 | |
51 | |
49 |
User | Count |
---|---|
335 | |
121 | |
83 | |
68 | |
62 |