R1
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Button in Pivot table at the row level
Hi, Use case explained below: We have a specific set of dashboard requirements for which we're trying to do a feasibility analysis. Let's say we display call info in a table in a dashboard ; where each row corresponds to data of a call. Can we have a thumbs up/thumbs down button - to gather feedback about each call for each row? ? And that will internally call a feedback API And is there a way for us to know who submitted the feedback. Basically the user id of the person logged on to give the feedback. Please let me know your thoughts on the feasibility of doing this on Sisense. Ido_QBeeQ harikm007 intapiuser Regards, Ramya868Views0likes0CommentsRe: Convert timestamp from the data model to a different timezone based on the dashboard filter
harikm007 Hi Hari, Thanks for the help. I'm displaying the "updated timestamp" in my blox widget from the items panel. However, I'm not able to map the timestamp from the data model ( ex: 12/24/2022, 3:16 AM) to just one item on the left panel. The following is how the blox widget allows me to map the timestamp to the items panel. The date part of the timestamp is mapped to "Pulsetimedays" and the time part of the timestamp mapped to "Pulsetimeminute" and i display them on the widget using the following: These are the formats for date and time i've selected in the blox widget for the timestamp to display. How do I concatenate these values in my script to form a single timestamp value?2.3KViews0likes0CommentsConvert timestamp from the data model to a different timezone based on the dashboard filter
harikm007 Hi, My use-case detail: We have a table in our data model with "updated timestamp" column in GMT timezone and another column which has the country name. This country name is one of our dashboard filters. The requirement is to convert the "updated timestamp" from the table into the timezone of the country selected i the dashboard filter and display it in the blox widget. Snapshot of the table with timestamp (GMT) below: My blox widget currently displays the "updated timestamp" as it is in the table. How is this conversion possible? I could think of three ways. 1. If the conversion is done and stored as a custom table in data model, it can be displayed in the blox widget directly. 2. Fetch the updated timestamp from the datamodel from inside my blox widget's script, convert it into the country's timezone( determined by the dashboard filter) and then display the converted timestamp in my blox wdiget.Is there a way for me to fetch this updated timestamp from the data model from the widget script? 3. My blox widget currently displays the "updated timestamp" as it is in the table using the 'Items' on the left panel and using it in the code like "text": "{panel:columnName}" . Could this be fetched inside the script, converted to a Date value and then finally convert to the timezone of the country in the filter? Regards,Ramya2.4KViews0likes2CommentsRe: Dynamic date display in text widget
Hi, Found a way to achieve this using Blox widget, and display the current timezone of the country based on the dashboard filter using the below script. I'm doing the conversion based on the current date and time. However, I want to use the last build date of the live model for conversion (to denote when data was last refreshed). From the documents and old community posts, i got to know how to get the last build time of an elastic cube. How do i achieve/ access the last build time of a live model in my widget script? widget.on("ready", function(w, args) { //make sure the target BloX text has an "id" attribute of "text-to-change" var yourFilterTitle = "Market"; //insert your filter title here //ASSUMPTION: you're using an ordinary "List"-style filter var filterDetails = w.dashboard.filters.$$items.find(function(element){ return element.jaql.title === yourFilterTitle; }).jaql.filter; //$("#text-to-change").text(filterDetails.members + ": " + filterDetails.members) if (filterDetails.members == "France" || filterDetails.members == "Italy" || filterDetails.members == "Netherlands") { let dateString = new Date().toLocaleString('en-US', { timeZone:'Europe/Paris'}); $("#text-to-change").text(filterDetails.members + ": " + dateString + " CET") } else if(filterDetails.members == "United Kingdom"|| filterDetails.members == "UK"){ let dateString = new Date().toLocaleString('en-US', { timeZone:'Europe/London'}); $("#text-to-change").text(filterDetails.members + ": " + dateString + " GMT") } else if(filterDetails.members == "United States of America"|| filterDetails.members == "USA"|| filterDetails.members == "US"){ let dateString = new Date().toLocaleString('en-US', { timeZone:'America/Phoenix'}); $("#text-to-change").text(filterDetails.members + ": " + dateString + " MST") } });1.9KViews0likes0CommentsRe: Widget to display time
Hi, Any help here is highly appreciated. I was able to find the ID of the text widget. However, date doesn't get displayed dynamically according to the filter value. My dashboard filter name is "marketname". This task is of high priority for us to deliver and could we please get on a call to go over this? I see this solution working for you but not for us and so wanted to understand if we're missing something. Attaching the dashboard script and dashboard for reference.3.1KViews0likes0CommentsDynamic date display in text widget
Hi, I'm trying to display the timezone of the country based on the value selected in the country dashboard filter, in a text widget. Using the below dashboard script as kindly shared by a fellow community member, but I don't see date getting populated when the filter is selected. The text widget remains empty. Dashboard filter name, widget ID are all verified correct. What could be the reason and solution for this?1.9KViews0likes1CommentRe: Widget to display time
Thank you Harry. I was able to find the ID of the text widget. However, date doesn't get displayed dynamically according to the filter value. My dashboard filter name is "marketname". Attaching the dashboard script and dashboard for reference. Is there something that i'm missing here?3.2KViews0likes0CommentsRe: Widget to display time
Hi Harry, Thank you so much. That helps. Could you kindly let me know how do i find the widget ID of the text widget in question? I tried finding out the widget ID of the text widget from the Console by giving "prism.activeDashboard.widgets.toArray()" and got the ID. But, the time doesn't get displayed while selecting the filter. Attaching the screenshot of the dashboard too.3.2KViews0likes3Comments