Bar graph is showing data for June-22 in all months. How can I fix this?

Options
wjackm
wjackm Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

I have a bar graph on my UX page showing headcount per month, but the chart shows the same data for all months when I've only loaded data for June 2022. I would like to see all other months show 0 until I load additional data for these months. Are there steps to fix this?

 

The data I've loaded does have a month identifier and I have a time settings module, but wondering if it's possible there is a step I missed somewhere to make this connection that the data I uploaded is for June 2022. I've attached pictures of the chart, the card configuration, and the module feeding into the chart.

 

I would also like to add drop downs to the chart so users can show visuals for segments of the total headcount (i.e. team, subteam, etc) if anyone has any tips for this as well.

Tagged:

Comments

  • wjackm
    wjackm Member, ALL USERS Posts: 5 New Contributor

    Hi @ryan_kohn, thanks for your help. Answers to your questions:

    1. I have the FTE line item displayed in the chart. The formula for this line item is set to 1 so that it counts 1 employee for each line in the data upload and this sums up the total number of employees for the chart each month. So far I have only loaded the June data, which was used to design the model.

    2. Yes, the data is the same for each month in the grid. I would expect this to only show data for June because that's the only month I've uploaded data for. Is it possible I made a mistake here and the data isn't actually linked to June, but all months instead?

    3. It is set to all employees because I want it to count every employee for this data upload. The drop down shows all of the employee IDs, but if I were to just select one that wouldn't show the total number of employees in the month.

Categories