Hello All!
I will fully admit to being an Analytics non-expert. I am putting together a couple of dashboards, and I have two questions.
1) It seems like you cannot have an out of the box standard column chart with multiple Values (and here especially I would want Y1 and Y2 axes), while also including a break by component. However, elsewhere I WAS able to find a way to use scripting in a separate bar chart which had a category, a value AND a break by to sort BY the value instead of the category. Is anyone aware of an outside the box and/or scripting solution to allow multiple Values for the standard column chart with a break by?
2) I am using the Order Weeks Since OnSale data point to show values (both running and distinct) since onsale for performances, and it is working just fine. When I try to manually interact with the widget, it works just fine; select week 2, and the data on the dashboard filters like it should, showing me that data for that week in the rest of the widgets, yay. However, Week 0 fails. That is, the onsale week itself (where, naturally, a large chunk of the sales actually lie). It LOOKS like it is going to work. Everything else starts greying out and the lovely three dots come up, but then it is like it hits a wall and stops and clears the selection on its own. Is this a known bug, an unknown bug or am I doing something wrong?
Thanks all!
John
Hi John,
The first item I'm happy to hear from others, but I don't think there's a way to implement that in your Analytics. I would be interested to hear the specifics of what you're Categorizing, the 2 Values you've defined, and what you want to Break them by, if you'd be willing to share. It's helpful to hear use cases like this.
I can also confirm that item 2 is a defect (DEV-8140) that is resolved in v16. The workaround: With the dashboard filter visible from prior weeks' selections, edit the filter and manually select 0 from the List, or set a Value type filter “= 0”.
Thanks,Chris
Chris Wallingford,
Thanks for the clarification on item 2. I thought that might be the case, but always good to have it confirmed than to continue to wonder.
As for item 1, happy to share. The core of this particular dashboard is in how our organization books performances (non-Covid times, generally). We are a presenting organization; through which we have a number of genre-themed series each year: Classical, Jazz, Songbook, Country, etc... As such, I am building a dashboard for the management team that shows the performance of those series/genres year over year. E.g. Fiscal Years 2017, 2018 and 2019. However, because we are subject to whatever shows we can book, the fact that single ticket sales were pretty consistent in 2017 and 2018 but nearly doubled in 2019 is not enough to stand on its own. Because maybe there were 4 shows in that series in 2017 and 2018 but 7 in 2019; in that case, that is a boring number. If, however, there were 5 shows in that series every year, that becomes a VERY interesting number. That is in fact one of 3 widgets I have on the dashboard; Subs, Single Tickets and Total Sales, broken by fiscal year. What I want to do is to also put a line graph with a second Y-axis overlaying them showing the number of performances each fiscal year. As it is, I have another column graph standing next to them showing the number of performances, but it does not have quite the same effect that an overlaid line would have. Hopefully that explanation makes sense. If not, let me know. I believe there are some Sisense custom plugins that can help do stuff like this, but we are RAMP, and plugins are always a toss up anyway. At any rate, that is what I would like to do.
Bonus item/question: When I am doing a column graph of performance seats and sales, I have to break it out by date and performance codes because, despite what I said above about being a presenting organization, we DO have 3-5 events that come back every year, and, if I break it out by performance name, those events are grouped together into one. Is there any way to change that? I ask that because dates and performance codes are letter pretty and easy to digest than performance names.
Thanks!
Thanks for laying that out for me. There may be a workaround for that particular visual. Let's see if it works for you:
Without having the break by, the Number of Performance line value can be enabled and rendered on the same chart.
For your bonus item, I don't 100% follow I think. Would there be anything that distinguishes one row from the next? Or is it just...
Performance : ValueMy Favorite Show : $12,345My Favorite Show : $12,346My Favorite Show : $12,347My Favorite Show : $12,348
...without any distinguishing attribute?
Good news on the first part. That works, so that allows me to have a much cleaner set-up there.
For the second thing, and this is probably my inner SQL/database person coming out, but ideally what I would like to do is display the performances left to right in date order. We have a performance every year called the Songbook Academy Finals, and right now, when I use the performance name instead of date+code, it shows them in alphabetical order with the Songbook Academy Finals looking like it has a lot of sales, because of course it has 3 performances worth of sales grouped into the same bar while everything else has only one. If there is no way to order by date, I guess yes, it would need to be as you say above there, three of the same thing in a row with different sales numbers for each. If they were ordered by date, it would be obvious which one is which.
As I said above, I am not the Analytics expert, so it is possible that I am missing something here, and what I am asking is easy.
Assuming a widget that is filtered to Performance name = Songbook Academy Finals, and then the PERFORMANCE DATE - Date field and PERFORMANCE DETAIL - Time after that, both in the Categories panel, we could produce something like this. If there's only 1 performance on any given date, then you could skip adding "Time" to the widget.
Okay, I think we are there. One way or another, solving the issues! Thanks!