I have a spreadsheet with data that has multiple items by day. When showing one of the graphs, I want it to display the time interval on the x axis by week - how do I achieve this? Seems pretty simple but I can't figure out how to make it happen.
@brkling - This is going to depend on your data. If you have a date, you could create a calculated column using WEEKNUM:
And use that as your x-axis.
If this doesn't solve your problem, please post an example data row or partial data row.
A date dimension is always the appropriate solution to this sort of problem.
I have a similar problem, that I need to show public in a park per week but my problem is that I need a line per year.
My X should be the week numbers but need two Y, one for showing public per week of 2016 and another for 2017.
How would I do that?
You can do this by creating two calculated measures that filter the public per year (one for 2016 and other for 2017). Something like:
Public2017 = FITLER(Table[ColumnW/PublicNumbers]; YEAR(Table[ColumnW/DateOfTheColectedData]) = 2017)
Public2016 = FITLER(Table[ColumnW/PublicNumbers]; YEAR(Table[ColumnW/DateOfTheColectedData]) = 2016)
And using this calculated measures as line values in your chart.
Hope it helps!
look at this post made by @elliotdixon:
..meanwhile I look for a custom solution for your problem.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.