Forum Discussion
Selected value table
Hello can anyone please help me? I have the following table visual which I intend to sit as shown below - The data from this comes from at table structured like as below. (More headings than KSI an...
Thanks lbendlin for reply
So my table called Data feed bridging table looks like this -
So I want to be able to slice my table by region and date (Only been able to include one month).
But at the moment its working fine but the values are repeating on each metric as above picture in first post when I only want them to show in the measure in the column and if not blank.
| Metric number | Measure groups | Metric | Weighting |
| 1 | VTI | KSI | 10.00% |
| 2 | FIN | Lost Time Injury (LTI) | 10.00% |
| 3 | LESS | LTI | 10.00% |
| 4 | RTN | % cleared within 1 hr | 10.00% |
| 5 | Correspondence | SRUS | 2.50% |
| 5 | BELL | Correspondence | 2.50% |
| 5 | Complaints | Roadworks information | 2.50% |
| 5 | Corporate Carbon | Complaints | 2.50% |
| 6 | Biodiversity Units added | Corporate Carbon | 5.00% |
This is the data feed table
| Reporting Month | Region | VTI | FIN | LESS | RTN | Correspondence | BELL | Complaints | Corporate Carbon |
| 01/06/2023 | East | 241 | 0 | 0.56 | 0.72 | 0 | 0.902 | 34 | 34 |
| 01/06/2023 | Midlands | 219 | 0 | 0.16 | 0.73 | 0 | 0.7 | 0 | 0 |
| 01/06/2023 | North West | 1000 | 0 | 0.26 | 0.76 | 0 | 0.903 | 354 | 34 |
| 01/06/2023 | South East | 158 | 0 | 0.07 | 0.69 | 0 | 0.797 | 0 | 0 |
| 01/06/2023 | YNE | 413 | 0 | 0.28 | 0.77 | 0 | 0.999 | 0 | 0 |
| 01/06/2023 | South West | 131 | 0 | 0.26 | 0.8 | 0 | 0.786 | 45 | 0 |
| 01/06/2023 | National | 126 | 0 | 0.3 | 0.89 | 0 | 0.701 | 0 | 44 |
Please include all required details - what is your calendar table looking like, and what is your expected outcome?