Combine datasets into a single graph

[keithkeirstead]

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 data over all the years. In each report for each year it has the same graph, just trying to combine it into a single graph in a dashboard. I tried adding all of the data from 2020, 2021, and 2022 into a single dataset but the data is over 10GB and can no longer auto refresh (each year is 13 columns but 14 million rows). Is this possible at all?

[danextian]

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]

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.