Model Connection Not showing the Correct Bar Chart Values

hctrgrc — Wed, 03 Jul 2024 16:52:44 GMT

Hello, I'm trying to display data from two tables. 1) My main table with historical sales in volume is based on Sales representatives. and 2) A forecast table with a single month with the corresponding volume for each sales representative. I have the names of the S.R. (sales representatives) on both tables and I join them with a [1 to many] connections as the historical data has many SR and my forecast table only has a few.

I then simply graph each of the SR in a clustered bar chart (from the main [1] table, and then I want to add the forecast volume for each SR as a model relationship has been made already . The problem is when I add to the bar chart my forecast volume, it is displayed for every SR as the total volume amount of the forecast table instead of the corresponding value for each SR. I then get the option to display it as the "Count" or the "Sum" of the values but nothing helps to display it correctly.

Is there a way around this? I've tried to look into the type of data my forecast table is showing but it all seems to show whole numbers (no text or different type of format).

Re: Model Connection Not showing the Correct Bar Chart Values

lbendlin — Thu, 08 Aug 2024 00:55:05 GMT

These tables should not be linked directly. Instead they should both be controlled by dimension tables for Sales Rep and Calendar etc.

topic Model Connection Not showing the Correct Bar Chart Values in Custom Visuals Development Discussion

Model Connection Not showing the Correct Bar Chart Values

Re: Model Connection Not showing the Correct Bar Chart Values