Is there any way to display the percentage change ...
# gd-beginners
c
Is there any way to display the percentage change on this chart? And rotate it 90 degrees?
m
Hi Cathy, could you please provide more details? Do you want bars show as percentage? are there a fact or metric?, with rotation you mean transform it in a 'vertical' bar chart, and keeping the Turnover LY red lines?
c
Thanks MC, I want it show like below chart. Blue is for this year, orange for last year same day of week, the day -364 days or -52 weeks, and show the percentage of difference between them.
m
Hi Cathy, thanks once more for your question about the 90-degree bullet chart and column labels. Sadly, both of those features aren't directly available in GoodData's built-in visualizations. However, there's potential to achieve this through custom development using the GoodData SDK/UI or plugins. These options give you more control, but they do require development effort and may involve a learning curve. Adding labels to each 'bullet/column' would also require this custom development. You can find some examples here. Let us know if you have any more questions
c
Hi MC, thanks for the support. I'm currently running into an issue with date functions. I'm trying to get the day of the week for the
max_date
and then show the turnover trend for that day across the past 52 weeks. eg. max_date is 2025-04-07, the day of week is Monday. I want to have a line chart for each Monday of last 52 weeks. Like snapshot below:
Second question is our financial year start from 1sth July. Is there a way to show the bar chart starting from July to last month? And lately, we need to calc Year to date value. eg. YTD Turnover would be the sum of turnover from 2024-07-01 to max_date. and YTD turnover LY would be from 2023-07-01 to the same dayofweek last year, basically from 52 weeks ago or 364 days ago, ie. date_add(max_date, week, -52) or date_add(max_date, day, -364)