Forum Discussion

keithkeirstead's avatar
keithkeirstead
Frequent Visitor
4 years ago

Combine datasets into a single graph

Hi,   I have multiple datasets created for each year, so 2020, 2021, 2022, ect. all with the same type of data (columns are all the same) and I am trying to create a single graph that shows the dat...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi keithkeirstead ,

 

What do you mean by it can no longer auto-refresh? Ideally, if all the data sources  have the same set of columns, I would just combine them into one table by appending one to the other. This will make calculations simpler.

 

If you need the tables to be separate and have them all presented in one visual, you can create a separate table of dimensions and relate it to all the fact tables. Use the column/s from this dimension table in your chart. Your measure should be something like 

CombinedMeasure = 
[Measure Table1] + [Measure Table2] + [Measure Table1] //and so on

That's just one measure. I can imagine how tedious this would be if you had a lot more.

keithkeirstead's avatar
keithkeirstead
Frequent Visitor
4 years ago

Hi danextian 

 

The reason I had broken it up into years is because combining all the years and setting to auto refresh I get met with the error that "The amount of data on the gateway client has exceeded the limit for a single table" so I figured break it down so each year is a signle dataset and then only auto refresh the current year.