Use case:
I want a custom color scale based upon my data range. For each range, I want to be able to specify the color that should be used. Today, I can do the following:
IF (SUM([Profit]) < 1200000) THEN 1 ELSE IF (SUM([Profit]) >= 1200000 AND SUM([Profit]) < 1300000) THEN 2 ELSE 3
I then drag this calculated field on to the color deck. So now we've established a custom color range. However, VA treats AGG fields always as a continuous measure. With a continuous measure field, you cannot assign specific colors to each range. In order to support this use case:
1) VA would need to support discrete measure. This is a more generic solution & also also address the issue of using the INDEX() table calculation as a discrete measure
2) If the scope of #1 is too large, we can support discrete measure just in the color deck.
297 KB
47 KB
46 KB
40 KB
The following are test scenarios to help validate the implementation.
Scenario 1:
Scenario 2:
Scenario 3:
Code Review:
There seems to be a problem with getting all possible values for discrete measure fields. Please look at the ColorValuesTableModel class on how it calculates the range for the measure value. We need to do something similar, but to determine all unique measure values instead of the range.
Code Review:
There seems to be a problem with getting all possible values for discrete measure fields. Please look at the ColorValuesTableModel class on how it calculates the range for the measure value. We need to do something similar, but to determine all unique measure values instead of the range.
Hi Nhi,
Thanks for your suggestions, now I am able to populate values in Color Deck using changes (which are checked in under below revision no.). However, colors are not yet applied on the Area Data. Will work on it.
Hi Nhi,
Thanks for your suggestions, now I am able to populate values in Color Deck using changes (which are checked in under below revision no.). However, colors are not yet applied on the Area Data. Will work on it.
It's hard to review the functionality further due to the broken Scenario B8 here. Please fix Scenario B8 first.
It's hard to review the functionality further due to the broken Scenario B8 here. Please fix Scenario B8 first.
Done testing of this feature. Hence, marking it verified.
Done testing of this feature. Hence, marking it verified.
Issue #15376 |
Verified |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ads-windows-x64-19.5.0-dev-76 |
No time estimate |
1 issue link |
depends upon #15442
Issue #15442Support Discrete mode for measure fields |
The following are test scenarios to help validate the implementation.
Scenario 1:
Scenario 2:
Scenario 3: