Data modelling in between Measure and Interval Table
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).