Forum Discussion

mrrob's avatar
mrrob
Frequent Visitor
4 years ago
Solved

Dynamic x and y axis scatter plot data model

Hi,

I would like to build scatter plot where user can change x and y measures from some kind of slicer. My data looks like that

Param1Param2Param3Param4Param5Param6Param7
135791012
246801113

 

My go to chart will be scatter with 2 slicers: one with list of all params (Param1-Param7) which controls x axis and second also with (Param1-Param7) which controls y axis. 

I already done this but it required pivot and crossjoin table itself what causes performance issues. Do you know any way to model data to acheive n computational complexity instead of n^2 (remove crossjoin somehow)? 

2 Replies