How can I achieve this line chart

Jones01 · 2024-09-22T14:20:13+00:00

There was an error rendering this rich post.

Jones01

Hi,

My data looks like this.

My board has a filter for Team.

When the user selects a team , e.g. Team A, I want a line graph by month displaying the following for each month.

A line for the values for Team A, 5, 5

A line for the values for the region Team A belongs to (so in this case East, = 5+6 Jan, 5+4 Feb.

How can I achieve this with a fixed by? or should I use segments?

Thanks

Find more posts tagged with

Accepted answers

DavidChurchman

It seems to that the team/region/country cards would be on such different scales that they wouldn't be that useful to have all on the same card. The simplest implementation would be 3 different line graph cards, one using "Team" for its series, one using "Region" for its series, and one using "Country" for its series. You could add a filter card for "Team", which will filter all three cards. I would recommend checking the "show single series legend" option.

(You would need a Fixed/filter deny for the region/country cards)

All comments

MarkSnodgrass

Segments would be the easiest to implement since you can base it on region, but you would likely have to create a segment for each region and they will always be showing.

I think you will have better luck if you use a variable for your team selection instead of a filter. You can then build a beast mode that is for your team line and another beast mode that is for your region line and you will only have two lines.

MarkSnodgrass

Actually, a fixed function might be easier your region total fixed function would look like this:

SUM(SUM(Value)) FIXED(BY Region FILTER DENY Team)

MarkSnodgrass

Jones01

@MarkSnodgrass thanks but this is an example data set and in reality Team consists of hundreds of records so needs to be a filter based on the data from the set.

I don't think that fixed function would work would it? The line chart is grouped by months and not Team so would essentially sum up everything ignoring the fixed by.

Is there any other way of visualising this perhaps?

They want to choose a team via a filter and then see the values for region and country all by months but for the fixed by to work the chart/visual will have to group by team.

ordinarily we'd write a snippet of sql in 2 mins to see this in our own js charts…

This is basically what I need put into a line chart. This is using fixed by month and region and month and country both with a deny on Team.

DavidChurchman

(You would need a Fixed/filter deny for the region/country cards)

Jones01

@DavidChurchman thanks, yes I think this will be the only way.

This is just sample data but in my actual data the values are % increase on LY so it would be absolutely best to have on one card. (something we can easily produce with a snippet of sql and fusioncharts lib) so is very frustrating this can't be done.