ramansingh89
ETL
Joined 2 years ago
User Profile
User Widgets
Contributions
Single Filter against multiple columns
Hello Experts I wonder if there is way to build a single filter on Dashboard that interacts with 2 different columns in the database? Here is an example 2 columns in table:- - primary City - secondary city On the dashboard level, we would like to build a single filter called 'city' which should filter against both of these columns using OR condition (eg: select sum(sales) from customer_orders where primary_city='Toronto' or secondary_city='Toronto'Solved756Views0likes5CommentsExpose JSON Key in a widget
Hi All, I am trying to understand if there is any way to extract json "keys" as columns in a Sisense widget. Example: Lets say we have a semi-structure table that contains some json attributes which is some key:value pairs attributes:{ "x1": "John Doe", "x2": 30, "x3": 180 } is there a way I use "x2" in my widgets (eg: line chart) without me creating/hard-code into columns on the database/model level?Solved969Views0likes2Comments