Calculate the percentage based on two calculations - one for future data and another for past data and finally create a bar chart for every team

[preeti1211 (preeti)]

Calculation -
95/120 (First value being the number of PBIs approved for future 3 sprints and second value being the number of PBIs completed in the past 3 sprints). If the divided value is =<33% the bar chart should be red. If it is =<66% bar chart should be amber. If it is >66% to 100% it should be green.
Product Level Visualization: Barchart showing percentage for each of Team with bar showing as GREEN / AMBER / RED based on the same logic above

Use case is to have a bar chart with x axis as team name and y axis as percentage calculated for each time and bar chart for each team will be of corresponding color based on calculated percentage.

Can you please help which visualization and how we can achieve this usecase

Thanks
Preeti

[wylie (Wylie Conlon)]

You didn't describe anything about how your data is stored, which is usually an important factor, but in this case you have only one option: use Vega to build a fully custom query + vis. Here's a tutorial showing how to query data, which is the starting point you should use: https://www.elastic.co/guide/en/kibana/current/vega-lite-tutorial-create-your-first-visualizations.html