Best way to combine different reports into a single report

Ask the Community
,
1

hi there! i have three different reports that take place over a month-year basis.

for example:

report a - counts number of apples bought every month
report b - counts number of bananas bought every month
report c - counts number of cherries bought every month

is there a way to aggregate all these reports into a single report that adds up all the counts in a single month. or what is the easiest way to do this?

obviously, my use-case is much more complicated than just these simple counts as they include where statements and count distincts, but ideas?

–

one idea is to do a huge with as subquery for each report (with sub_query as() ) and then combine them into a huge query

2

Hi Paul,

Does using the date dim approach meet your needs? Using a Date Dimension model | Holistics Docs (4.0)

Best,

3

great - thank you! --closed–