I want to create a bar chart from the following data which will look like the attached picture. The data will have a start time, end time, and a number value. Which will look something like this:
Mainly, I want to create a timeline in the X-axis and I want to see from when to when the “number” is ranging. I tried to use the default bar graphs in excel but they are just showing each bar separately.
[normal bar chart]
I tried to search a lot about this but couldn’t get any direction. Any help would be greatly appreciated!
is one such site which allows me to see this, but the minimum period it allows a comparison is for a week. I need a chart where the prices are changing by the second and I can compare different coins even for a 5 minute period, not just weekly or monthly comparison
I am new to Data Studio, so forgive me if it’s a silly question. This is also my first question on StackExchange, so be nice to me :-]
I am trying to get returning users’ % on a bar chart. It’s more of a visual effect that I want to create.
My goal is that I should have 10% returning users on my website. So I have standardized the second bar to 10%. Now as we know data studio is unable to get returning users directly from google analytics, so I have created the segment and managed to get the number on a scorecard. But now I am not able to get it on a bar chart. I cant seem to get how to use that segment to calculate the % of returning users from the total users and then display it on the bar.
This is how my Total and New User bar looks like since I am able to get the metrics directly. For now, I am having to enter the returning user manually but I would like to automate it.
Here’s what seems to be a simple common thing in excel/sheets that I can’t seem to be able to google in the right way (for hours). three columns: timestamp, email, things_done.
I want a chart with time as the X axis, things_done as the Y axis, and a line for each email.
The things_done could be grouped by week or even month and that would be pretty good.
Ideally I would be able to point some tool at this data and be able to do various things with it like choose weather to group by week or month, look at 5-week moving average, etc.
I’ve been able to sort of achieve this with multiple sheets to get to a pivot table, but the resultant “smooth” chart doesn’t want to consistently connect the dots. And in general my setup is very inflexible.
Is there a way (or third-party tool) to go straight from my source data described above to a nice looking chart with the time aggregation of my choosing (and bonus points for ability to add moving average)?
I’m trying to create an attendance chart. Previously, there was only 1 time slot, so I used a line chart. However, now there are 2 time slots. So, I’d like to do a stacked area line chart to summarize both individual and total attendance between both time slots. The problem is that some attend both time slots. I don’t want the total attendance for the day to be skewed (i.e. total number of people in attendance), nor do I want the attendance for each time slot to be skewed.
How can I track the attendance accurately and represent it on the chart? Is there some way I can specify an “overlap” in attendance (i.e. 100 at time 1, 100 at time 2, 25 at both, for a total of 175 for the day)?
I am working on a 100% stacked area chart in Observable with labels for each series, but I have a ton of series and would like to hide the labels for series that are too small to display (currently they are all scrunched on top of each other). Is anyone able to advise on how I can do this?
I created an if else statement and know I need to somehow say that if the value is below a certain share of the total, don’t display the label, but I am struggling to figure out what exactly needs to go in that statement. If anyone is able to advise, that would be extremely helpful!
Current notebook: https://observablehq.com/d/b981c470fa4ebddc
I asked this question on https://www.reddit.com/r/excel/comments/mikwvz/competition_tracker_create_publicly_accessible/?utm_source=share&utm_medium=web2x&context=3, but didn’t get an actionable (at my level of expertise) answer.
Using Google Sheets I’m trying to create a competition score tracker/graph that displays this information:
Each time an answer is submitted, the response sheet will display the time of the submission, the player’s name, and 8 “flag” cells, one for each flag in the challenge. The only flags that will have data will be correct flag submissions (thanks to Google Form’s “response validation”), and my expectation is that each player will be submitting once for each flag, although players can and should be allowed to submit multiple flags at once. Once factor that I have to account for is that players might re-submit previously submitted flags, so I want to account for that before the score is tallied and displayed on the graph.
Along the X-axis, the graph would track the time that each answer is submitted.
Along the Y-axis, the graph will display the total score.
Each colored line in the line graph will be a different player (my expectation is approx. 5-10 players total). As I linked in the reddit post, my hope is to display a graph that functionally resembles this one
and I’ll use Google Sheets to “publish” the graph so that it can be viewed throughout the competition.