Camantea
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Elasticube Build Behaviour - Upsert
AndrewLoomis thanks for the suggestion / thoughts on this! Yes, we are already using live models in some instances but can not utilize live all the time as a workaround. Would not want to query BQ constantly throughout the day from a live model (driving costs up) and load times are significantly decreased on live vs. cubes - not to mention you can only utilize one data source in a live model and can not build custom columns. This is why a permanent solution vs. numerous workarounds would be very beneficial.1.5KViews1like0CommentsAggregate on more than 1 value in chart when also using "Break By"
Being able to use only 1 field to aggregate on when breaking by a dimension is quite limiting when we are wanting to look at YoY trends on a stacked column chart. I am surprised this has not been brought up yet as one would think this is a fairly common analytical need. As a broad example, how would one look at YoY sales by day and stacked by product types?649Views0likes0CommentsElasticube Build Behaviour - Upsert
Currently, the "Upsert" build behavior is only available for Build to destination. It would be great if we were able to utilize this feature in our Elasticube model where we are not building to destination. We have numerous tables containing created date as well as updated date that are attached to an id field but are unable to use the updated date field since this will bring in duplicate (or more) rows per id which we can not have. Ranking duplicates and filtering out is not a sustainable with the size of our datasets. The ability to look at the id and updated field would solve this issue without the need for a complex workaround in our data source (Big Query). Thank you!2.2KViews12likes4CommentsAutomated Widget Titles
Hi All, I am wondering if anyone has had any success in automating the title of a widget within a dash using the widget script. I am trying to have the title update the month automatically when a filter is applied. For example, trying to show "November Sales Trend" and have this title update when a new filter for the month of sale is selected. I found the below script would work for adjusting the title, but just need the script to grab the Current Month now. widget.on('ready', function(w,e){ prism.activeWidget.title= 'November Venue Sales' /* this changes the title }) Thanks in advance for any suggestions!3.1KViews0likes3Comments