Forum Discussion

Freddus's avatar
Freddus
Regular Visitor
9 years ago
Solved

Need help presenting a comparable Line graph with 4 different lines

Hi,    I need help to create a Line Graph with four different report (4 sheets). I have done a appended query so the 4 sheets are combined. However, each report have different date periods so the l...
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    there is multiples solutions 

    you could combine the 4 tables by this:

     

    Modeling - New Table

     

    Merged4Books = UNION
    (
    TOPN(30;Table1;Table1[Date];DESC);

    TOPN(30;Table2;Table2[Date];DESC);

    TOPN(30;Table3;Table3[Date];DESC);

    TOPN(30;Table4;Table4[Date];DESC);

    )

     

    or alternatively you can add sorted index by date to the source and then join on that so the most current date is 1 the day before 2 and so on

    theres other possibibilities but for that I would need to see the data

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

Null values of what? Is date Null???

 

The merge should give you 30 rows per table does not matter if some field in rows is blank.

What is the problem? maybe give some screenshot of the Chart or Data???

Freddus's avatar
Freddus
Regular Visitor
9 years ago

I can give you a snap shot of the column that I am comparing in the graph.  

 

However, I am comparing Fuel Consumption and for some dates, the values are 'n/a'.  The graph is adding up the values instead of leaving it as zer value, see graph