how to change dimension and measure by JAQL

Follow

Siva

July 20, 2017 09:57

Hi All,

 

We are embedding Sisense in our application using sisense.js.

we have a dropdown in UI with various dimensions. I have one widget, in that I want to change both dimension and measure based on the selection made in dropdown using JAQL. Please let us how to do it.

Attached is the requirement explained in a excel.

Regards,
Sai Krishna.

0

• 

  Michael Becker July 20, 2017 11:21

  Hi Sai,

  maybe those could be easier to implement to gain a similar effect:

  https://support.sisense.com/hc/en-us/community/posts/221224828-Switchable-Dimensions

  https://support.sisense.com/hc/en-us/community/posts/221225468-The-Measure-Changer-Widget-

  Regards,

  Michał

  0

  Comment actions Permalink
• 

  Siva July 22, 2017 05:42

  Hi Michal,

  Thanks for reply. As per the requirement the measure should automatically change based on the dimension selected. But I see these are two separate widgets, one changes dimension and other measure.

  please let me know is there any way to combine both. In the excel I attached, when dimension is changed the chart measure is also changing (population and revenue).

  Regards,
  Sai Krishna.

  0

  Comment actions Permalink

Please sign in to leave a comment.