I'm trying to build a line chart that tracks cumulative performance revenue by order date. I've noticed in our environment that if there are periods where there were no sales, Tess Analytics does not continue to draw the line, instead it breaks down into smaller dashes and dots. Has anyone else experienced this? Is this part of how the sisense software works, or is there something else to look into? Thanks!
For reference:
Hi Gabe,
Yeah, I've noticed some strange behaviors too.
In the Edit Widget screen, try exploring the settings in the hamburger menus for X-Axis and Values.
On my line chart, the X-Axis gives these options:
See what happens when you check/uncheck the Continuous Timeline options.
Also, in the Values hamburger menu, there is an option for displaying missing values as Zeros.
Hope that helps!
Intriguingly I have neither "Displaying Missing Values as Zeros" nor "Continuous Timeline" options on my line charts.
If the suggestions on this post do not help with your issue please let me know and we'll get a support ticket going to investigate further. Thanks, Mary
Hi Kyle, unfortunately neither of those options are showing up for me. We are on RAMP, and on version 7.1.3.10025 of Sisense, so maybe that is relevant to the issue.
Hi Mary, the options suggested weren't available in my implementation of Sisense. I sent a TASK ticket to RAMP on a similar issue, but have not heard back yet.
Just to close the loop on this, which was helpful, for RAMP folks, they gave me a section of code that had to be inserted into the widget. Instructions are:
Edit the widget, and from the upper-right (...) menu, select Edit Widget Code. This will open a new tab.
Paste this code in:
widget.on("beforeviewloaded",function(scope, args){ args.options.plotOptions.series.connectNulls = true; });
Save the widget and force a reload by Right Clicking and choosing Hard Reload (or just close and reopen the dashboard).
Thanks to Ragan Rhodes for sending this little trick.
Thanks David (and Ragan). I'm putting this in all my RSUM charts and loving it
Hello everyone,
Agreed with Heath, thanks David and Ragan.
This works brilliant where we’re using RSUM when there’s a single Value on the widget, but it doesn’t seem to work when we have multiple values? Has anybody experienced a similar issue and come up with a solution?
Thanks so much
Graeme
Heath Wilder,
I am trying to do something similar and I do not have the "Display Missing Values as Zeros" option either. RAMP as well for me. Did you get that eventually straightened out? I am looking at some running sales data that looks misleading to me because it keeps skipping random numbers.
John
Hi Daniel,
Yes, using that script, points on the original line that are isolated, single data-points not immediately preceded or followed by another non-null data-point of the x-axis, a marker dot will still be rendered on the line chart:
Expanding this script, we can iterate through all series lines, and all data points on each line to explicitly remove the marker dots. This will remove the markers as shown below, however, any series with only one data-point in the whole widget will disappear from the chart altogether. This may be a non-issue in your data however.
//The top script will connect the dashed parts like the top yellow line pictured above
widget.on("beforeviewloaded",function(scope, args){
args.options.plotOptions.series.connectNulls = true;
});
//Turns off the markers
widget.on('render', function(sender,se){
for
(var i = 0; i < sender.queryResult.series.length; i++ ) {
(var j = 0; j < sender.queryResult.series[i].data.length; j++) {
sender.queryResult.series[i].data[j].marker.enabled = false;
}
)
View online
You find that info linked handily in the analytic Coffee! wiki here https://community.tessituranetwork.com/topical_groups/analytics-coffee/w/wiki/793/removing-data-markers-for-isolated-single-data-points
Hey JAM2.0
does that analytic coffee wiki link answer your thoughts. there are get rid of the dots and join the lines options
(Delayed response; was out of the office for a few days, taking them breaks!) Thanks for that suggestion! Unfortunately, it does not, though I feel like it is getting close. The problem with my data is that there are points in all of the data being returned with there is just no information. If there was some OTHER line returning that data point that link helps to connect the non-changing data, so that DID indeed help some of the other lines, but not the overall issue. I am looking at a running sales by week (and by day, but the week is more obvious in its flaw).
For example, this image is just looking a single performance run of one of our classical events (it did not do too well, but was a fabulous concert). Anyway, just looking at this makes one thing that single ticket sales started off slow but then picked up as time went on. If you are looking merely at graph designations, assuming that the changes are weekly, you assume that first month so (4 lines) was a little slow but then things started picking up. However, looking closely AT the axis designations, you will note that there were just plain no sales on weeks 6, 9 and 11. So it is not really one month of slow sales, but almost two full months of slowness.
To anyone looking for a graph of change over time, they want to see those flat sections there. At least, I would. I do not want them skipped because of "no data". Looking at the numbers solves that issues, too, but the general idea behind a dashboard for many is not to have to look THAT closely, and that visual certainly is a little more skewed to the reality than I would like. I want to be able to look at them and say "wow, that was a long time with basically no sales; I wonder why that was" instantly just by reading the graph, not having to read and decipher what was going on on the Axis.
I feel like there HAS to be a way to do this, but I am currently stymied. All thoughts welcome.
JAM 2.0
Oh my dude! you are after Continuous Timeline me thinks. It's an option in the hamburger of the X-axis in the widget
Be careful though if you push through too much data in v15 it'll blow up your dashboard and you have to edit the code in Notepadd++ to go back to Contiunuous Timline =off. But looks like you are on weeks so should be all good.
Hi John,
From an Analytics perspective, when there's no related data (sales and seats in a given bucket) it doesn't know that Fiscal Week of Year 6 comes between 5 and 7 weeks any more than it knows My Name is Not Mom comes between Postmodern Jukebox and Johnny Mathis on an event calendar. The exception to that is the Continuous Timeline feature that's available only on [Date] fields in Analytics. I think we can get you a step closer to what you want though, and then let's look again.
Because those weeks don't exist in the data, we need to expand the data set for the widget and then do the filtering in the values. For example, if we have a dashboard filter limiting the set to the current season, all the widgets on the dashboard might respect that filter. In this widget, we might override the filter to include also last season, or even all seasons. With that, we can expect prior seasons to have sales against those weeks, so they should appear on the x-axis.
Then in each of the Values, add a filter on season that mirrors the dashboard filter. E.g.
( [Total Ticket Count] , [Price Type Category = Subscription] , [Season = 2023 Season] )
I expect that will work, but may also have the unexpected/undesired outcome of showing all future weeks in the current season as well.