Hey folks,
I want to create a data structure that provide me a feature as below:
When I click the interval value in the dashboard, I can see the value of measure which is in same interval.
Measure | Interval1 | Interval2 |
---|
550 | 456 | 567 |
600 | 540 | 690 |
700 | 670 | 770 |
All I want to do is creating a new model that will show me the all value of intervals when I click a specific measure. What kind of changes do I need to implement in my data structure
For instance,
Measure | Interval1 | Interval2 |
---|
550 | 456 | 567 |
| 540 | 690 |
%KeyInt and %Facts are foreign keys for tables. The value of intervals in Interval.Interval (Interval) and the value of measurements is inside of Measure.Measure (Measure).
Thanks in advance,