Shams
Cloud Apps
Joined 12 months ago
User Profile
User Widgets
Contributions
Blanks in Pivot Widget
Hi all, Wondering if I'm missing something when it comes to using a Pivot. Is there a reason why the last column is always blank here? It doesn't matter which order I rearrange these values, the last one is always blank. I've created another pivot using the configuration but with different metrics and it's all been populated so I'm wondering why this would be different. Rearranged:312Views0likes3CommentsExport "Look and Feel" Templates
Hi all, Can there please be a way to export and import the "Look and Feel" themes in Sisense? At the moment, I've got a dev and prod instances for Sisense and 50+ clients who we aim to have custom themes based on their company branding and colour schemes. After making and testing one out in Dev, I'd love to be able to just copy a theme over from Dev to Prod when promoting a dashboard up instead of the current process of going through each individual settings and copying each colour one by one. Kind regards, ShamsRe: Box & Whisker Plot - Using a summarised value
Hi David, that would be a big help! I was also trying to order the categories on the box & whisker plot by month. I tried bringing in the field using the month numbers and then changing the script to match what I'd done on bar charts before to reformat the month number into the relevant month but it never worked. When I printed ev.result, I could see xAxis.categories and series but I kept getting errors in the console saying they didn't exist.1.5KViews0likes1CommentRe: Box & Whisker Plot - Using a summarised value
UPDATE: I've created a new summary table in the elasticube to get around this which summarises the total bookings for each day. The table can only really be connected to my Dim_Date table since it's at a date granularity now. The issue with doing it this way is we lose the ability of any filters on each booking affecting the widget. It's a shame the default behaviour of the widget doesn't allow us to perform a summary on a field for the categories. Please can this be fixed?1.5KViews1like0CommentsBox & Whisker Plot - Using a summarised value
Hi, I'd like to create a Box & Whisker Plot to show the distribution of "Bookings" by "Day of Week" across the time period so the client/tenant should be able to see, for example, that on Mondays their bookings can range from 150 to 325 but there are a couple of outliers. Currently, my model uses a count of unique Booking ID's to figure out the number of bookings from a fact table in the Elasticube. The issue is that adding Booking IDs to the widget only allows me to select "all values" and so instead of being able to count the total number per day of week, it's adding up each individual Booking ID since Booking ID's are an integer. How can I get around this to count the bookings per day of week? I'm sure I'm missing something but it seems like there should be a simpler way to do this. Thanks in advance.Solved1.6KViews0likes4Comments