Hi @Yrstruly ,
Go to the Portal and work through Data transformations & Modelling , if you haven’t already.OR review that content again.
See the remarks in this post
@Nagi_k ,
If I were to tackle something like this, here’s the general approach I would take:
Before even delving into the data model and the report, I would develop an analysis plan listing the questions I need the report (or far more likely, reports) to be able to address
I would then try to arrange these questions into like groups with the idea of trying to bin them into separate reports, each supported by a much simpler data model geared specifically to addressing that subset of questions/…
and also review this video by @Greg .
If you still have questions after that, post an updated/reworked model.
2 Likes
