Forum Discussion

bcmoulam's avatar
bcmoulam
New Member
3 years ago
Solved

Ratio Calculation between two user-selected columns

Hi all, 

Ref example table below. Various numeric metrics for each month - there are about 30 total columns similar to the examples (events, defects etc.)

 

Dateeventsdefectsdelayscyclesdefects/cycles
Jan-22111923224310.038
Feb-2211785921620.039
Mar-2240743323560.031
Apr-2260733828200.026
May-22122891323200.038
Jun-2292714021400.033
Jul-2241912126170.035
Aug-22106733028300.026
Sep-2253632429680.021
Oct-2238601729060.021
Nov-2214862620550.030
Dec-22110602828870.021
Jan-23130624025130.025
Feb-23132902621980.041
Mar-23117992926550.037
Apr-2339853920180.042
May-2366842829470.029
Jun-23141952223130.041
Jul-2362821525810.032

 

I'd like to calculate ratio's between the columns based on user-input - I'm imagining two filters titled Numerator & Denominator. The two filter values are passed to a Measure(?) that then calculates the ratio for each row. In the above example the user would have selected 'defects' in the Numerator filter and 'cycles' in the Denominator filter. That result is then plotted in a line chart over time.

 

 

I know I can create loads of calculated columns to do this up-front for all the possible combinations, but was wondering if possible to do this dynamically based on user input?

 

I've looked at other similar articles but they don't quite fit what I'm after - any help appreciated. 

Thanks