Good morning! Could you help me, please I'm makin...
# gd-beginners
t
Good morning! Could you help me, please I'm making a report using the following metric: select (Fat. x Meta * Meta Weight (Excel)) BY Item Line, Establishment Name where in the table report it has information per line of items for each establishment. However, when I use this same metric in a column chart to return the value of each establishment, it returns the wrong value. the correct value to return for this establishment 51 -AV PII was supposed to be the sum of the calculation of each line, which would be 5.34, but in the graph it returns the value of 5.17
m
Hi Tomas, from your screenshot where it shows “5.34” I can see that the report you’re checking against has multiple columns - It seems it’s being sliced by multiple attributes and by more metrics. I would like to suggest that you remove those other columns/attributes so it mirrors your Bar-chart and it will likely then show the same results. Can you please check this for me?
t
Hi Tomas, from your screenshot where it shows “5.34” I can see that the report you’re checking against has multiple columns - It seems it’s being sliced by multiple attributes and by more metrics. I would like to suggest that you remove those other columns/attributes so it mirrors your Bar-chart and it will likely then show the same results. Can you please check this for me
Hi Tomas, from your screenshot where it shows “5.34” I can see that the report you’re checking against has multiple columns - It seems it’s being sliced by multiple attributes and by more metrics. I would like to suggest that you remove those other columns/attributes so it mirrors your Bar-chart and it will likely then show the same results. Can you please check this for me