Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine multiple tables into one chart

Hi,

 

I'm trying to combine multiple tables into one chart. For every table I get the count of the unique numbers but then it shows like this. It's not looking good as it is still segregated by every item in each table.

 

 

Is there a way that I can create a new table, and get just the count of value from each table like this?

 

Item      |   Value

Table1   |  100

Table2   |  40

Table3   |  76

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    New Table =union (
    summarize(table1, "Name", "Table1", "Value", sum(Table1[value])),
    summarize(table2, "Name", "Table2", "Value", sum(Table2[value])),
    summarize(table3, "Name", "Table3", "Value", sum(Table3[value]))
    )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,

    New Table =union (
    summarize(table1, "Name", "Table1", "Value", sum(Table1[value])),
    summarize(table2, "Name", "Table2", "Value", sum(Table2[value])),
    summarize(table3, "Name", "Table3", "Value", sum(Table3[value]))
    )