Jijish
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Time Series Chart - Visualizing Hrs/Min/Sec
Thank you intapiuser and taras . This does help address my usecase. I have however run into problem. The X axis which displays the hours starts with some offset minutes. As seen in the below chart, instead of displaying every hours 9:00 AM, 10:00AM, the x-axis starts at 09:20 am. Any ideas on tweaking the script to fix this error ?1.7KViews0likes0CommentsRe: Enhancements to Pulse
I did reach out to the SiSense support with a subset of the above requirement. They redirected me to this forum. I believe the above enhancements are very valid and SiSense users stand to benefit from these enhancements especially the ability to limit the Alerts to pre-defined frequency.990Views0likes0CommentsRe: Drive widgets based on user chosen Timezone
Hi Hamzaj, I had tried the date dimension + data security option suggested. However, that introduced undesired behaviors in my dashboard. 1) The moment I configure a data security layer on a table, that column is added to all of the queries fired from widgets. 2) Owing to #1, undesired joins with tables are getting formed which ends up truncating the dataset fetched from the aggregated tables. 3) The solution proposed works only if I alienate the intra-day transaction table from all other tables in my elasticube which is impossible for me. Explaining the behavior using an example:- Column names of the Intra day table (storing last 36 hours data) :- DateTimeHours ProductID Count of Products sold Column names of Aggregate table :- Date ProductID CountofProducts Sold DateDimTable ( Data Security applied on Timezone) DateTimeHoursInIntraDay Timezone DateTimeHoursWithTimezoneOffset Behaviours introduced by my design :- ProductId is common between Intra-day and Aggregate table. There will be ProductIds in AggregateTable that are not in the Intra-day table as Intra-day stores a snapshot of hourly data. Relationship exists between DateTimeHours and DateTimeHoursInIntraDay Relationship exists between ProductIDs in Intra-day and the aggregate table My observations / findings :- Once the data security is applied, data fetched from AggregateTable gets limited to those ProductIds that are present in the Intra-day table as Timezone data-security forces the SiSense platform to first refer to the DateDimTable --> then fetch matching DateTimeHours from Intraday table to arrive at the ProductIds . Constraints / open questions even with the proposed solution:- Cannot bring all of the transaction data into Elasticube owing to the size Even if I use the DateDim+DataSecurity option, I have to figure out a solution for converting data in aggregate table to logged in user's timezone. Do share your thoughts. Regards Jijish1.1KViews0likes0CommentsDrive widgets based on user chosen Timezone
As the platform has users across the globe, the timezone chosen for reporting must get aligned with the logged-in user's locale. SiSense already displays the ElastiCube's last build time in the logged-in user's timezone. In similar lines, whenever a widgets reports intra-day transactions / volumes, an option to display the data in logged in user's timezone should be made available by default in the SiSense platform.1.1KViews3likes3CommentsRe: How to Hide Export to Excel Option On a Pivot Table (Linux)
Thank you, I was able to hide the Excel/CSV download option using this script. However, if one navigates to the full-screen mode of the widget, then the option to download Excel / CSV is still available. Any pointers on disabling the CSV/Excel download in the full-screen view? I have a requirement to enable the download of CSV / Excel in certain widgets and hence disabling downloads at the dashboard level is not an option I can pursue.1.5KViews0likes0Comments