Hi Team, I have yet another question- this is abou...
# gooddata-cloud
m
Hi Team, I have yet another question- this is about comparative reporting in our system- we have added a visualization for income by date, that has a comparison with the previous year, at the moment. The filter has been applied in the way described by THIS article, directly to the visualization. However, it's causing some trouble when we try to filter the overall dashboard on a smaller range- e.g, if the date range on the dashboard is a month total, but the visualization's filter is this year vs last year, the graph doesn't scale to a smaller set of units? What I'm wondering is if there is any way to get the visualization to change the range on the x-axis according to the overall filter on the dashboard? For e.g, if one date filter can be used to set the current range on the dashboard, and another to set the range to be compared to, or the previous range on the dashboard?
m
Hi Maria, if I understand correctly you would like the x-axis date dimension to dynamically change to a smaller / larger grain based on date range that you apply to the report? Unfortunately we don’t support this functionality, but I will be happy to mark this as “Product feedback” on your behalf and this will then be highlighted to our Product team who will review this and will consider this for future development.
m
Sure you can mark it like that, thank you for clarifying Could you also look into my other point, about the dashboard date filters working for comparative ranges? Since right now if we try to set a range for the current period on one filter and a range on another filter for the previous period, it doesn't work the way we'd like it to- that is to say, by using one filter to set the current period's date range and the other to set the previous period's range independently.
e
+1 for the Product feedback :)
m
Hi Maria, would you please be so kind as to provide me which an example regarding the comparative ranges on how it’s currently working now versus how you expect/like to see the comparative range work? Once have this clarification, I will be happy to check this further for you 🙂 You can find more details on the Time-over-Time Comparison filter options here: https://www.gooddata.com/docs/cloud/create-visualizations/filter/time-over-time/#apply-time-over-time-comparison-to-a-visualization
m
Okay sure
Right now we have a graph that has time-over-time comparison for a current period that is linked with the dashboard filter and the previous period is defined by the filter within the visualization, as per the documentation for Time-over-time comparison. But what we'd like to be able to do is to control both the current and previous periods through the dashboard filter. Here is what it looks like now:
But if we use the comparison filter on the main dashboard to compare say, even this quarter and the previous quarter, the visualization shows up empty. According to my understanding that shows that the filters try to find the common data between the two ranges but we're trying to assign one filter to the current period and the other to the previous period, so that our clients can adjust the date range that they want to see themselves. In the current way, even if we remove the filter we're using for comparison, the scale of the graph remains at Date by Month/Year, but what if the client wants to see a comparison for a shorter date range than that? The graph wouldn't be of much use to them if they were to pick a custom range for example, of 10 days
So to sum it all up, I want the visualization to do two things which it's not doing currently: • Allow me to select the current and previous period from the dashboard filter instead of the internal filter alone (not all comparisons need to be done with the "current" being this year and "previous" being last year) • And second, to scale automatically if I pick a period that's shorter than a month so that the data remains useful
Hi, is there an update on this? Or any further information that I could provide?
m
HI Maria, thank you for this feedback - I am going to go ahead and mark both as these points as “Product feedback” which will then highlight this to our Product team who will review this and will then consider this for future product development 🙂
p
🎉 New note created.