Two lines in a chart, one showing values one showing count

[BMac-Coop]

I'm stuck trying to get two lines working right on a chart.

One dataset has:

THING	WEEKCREATED
A	1
B	1
C	2

The other dataset has target goals:

WEEKNUM	TARGET
1	2
2	3

In this dataset, I have Summarize By in the model set to "None"

I'm trying to have a line chart where it plots one line with the count of things in each week, and another line that shows the goal.  I start with an Axis of WEEKCREATED and a Value of "Count of THING".  I can't for the life of me figure out how to put in the straight value of TARGET.

Any help is appriciated!  Thanks!

[AlB · Accepted solution]

Hi @BMac-Coop 

You can best create a date table with the week numbers. Then set up relationships between DateT and both your actuals and target tables. You can then create the line chart with DateT[Week] in the x axis and the count of "things" in values. It's advisable to create explicit measures for the counts rather than using implicit ones.

See it all at work in the attached file.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[BMac-Coop]

It's not loading as I'd expect in the file you provided.  The line for TARGET is straight at a value of 1.  The goal is the TARGET number changes week over week.  It's showing the number of TARGET rows for the week I think, not the value of the TARGET row.

[BMac-Coop]

I think I figured it out.  I had to change the TARGET value datapoint from "Count of TARGET" to Sum of TARGET (which just displays now as "TARGET").  With that change it looks as I'd expect.  Thanks!  Off to the next thing to figure out!