Is there any way to display the percentage change on this ch GoodData #gd-beginners

Join Slack

Is there any way to display the percentage change ...

# gd-beginners

Cathy Liu

03/05/2025, 5:31 AM

Is there any way to display the percentage change on this chart? And rotate it 90 degrees?

Mauricio Cabezas

03/05/2025, 1:07 PM

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?

Cathy Liu

03/06/2025, 2:17 AM

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.

Mauricio Cabezas

03/06/2025, 4:06 PM

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

Cathy Liu

04/08/2025, 3:27 AM

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:

Cathy Liu

04/08/2025, 3:53 AM

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)

Cathy Liu

07/11/2025, 1:06 AM

Hi Team, I’m trying to display the latest data load date using Rich Text in a GoodData dashboard. I’m referencing the month-end date from my dataset using this syntax: *Latest data load date: **{label/MONTH_END.day}*** However, it currently shows like this: 2025-06-30T000000 What I’d like is for it to display in a cleaner format—either: 2025 June or 2025-06-30 Could you please advise how I can achieve this? Is there a way to format the label or create a custom one for this purpose?

Mauricio Cabezas

07/15/2025, 7:11 AM

HI Cathy, my apologies for this radio silence. I would like to ask if you achieve the the question about max_date with the Turnover, similar to the question about financial year on July 1st? I am checking now your last question

Mauricio Cabezas

07/15/2025, 8:18 AM

Hi Cathy, there a workaround to pass a Date as Metric, I have been testing and I arrived to this metric, will show the last year, month, and day of your data

Copy code

SELECT 
#Day
  (DATETIME_DIFF(MAX({label/SaleDate.month},{dataset/salesdata}),
    MAX({label/SaleDate.day}, {dataset/salesdata})) + 1) * 100 + 
#Month
  (DATETIME_DIFF(MAX({label/SaleDate.year}, {dataset/salesdata}),
    MAX({label/SaleDate.month}, {dataset/salesdata})) + 1) * 10000 +
#year
  DATETIME_DIFF("2000", MAX({label/SaleDate.year}, {dataset/salesdata}), YEAR)

An, if you want, for example a specific month or year, just change the numbers as follow:

Copy code

SELECT 

#Day
  (DATETIME_DIFF(MAX({label/SaleDate.month},{dataset/salesdata}),
    MAX({label/SaleDate.day}, {dataset/salesdata})) + 1) * 100 + 
#Month (March example)
  3 * 10000 +
#year (20XX)
  25

This will returns date encoded as number in format MMDDYY The most important, you need to change the custom format as:

Copy code

[<20000]{{{100|100|00}}} Jan \2\0{{{|100|00}}};
[<30000]{{{100|100|00}}} Feb \2\0{{{|100|00}}};
[<40000]{{{100|100|00}}} Mar \2\0{{{|100|00}}};
[<50000]{{{100|100|00}}} Apr \2\0{{{|100|00}}};
[<60000]{{{100|100|00}}} May \2\0{{{|100|00}}};
[<70000]{{{100|100|00}}} Jun \2\0{{{|100|00}}};
[<80000]{{{100|100|00}}} Jul \2\0{{{|100|00}}};
[<90000]{{{100|100|00}}} Aug \2\0{{{|100|00}}};
[<100000]{{{100|100|00}}} Sep \2\0{{{|100|00}}};
[<110000]{{{100|100|00}}} Oct \2\0{{{|100|00}}};
[<120000]{{{100|100|00}}} Nov \2\0{{{|100|00}}};
{{{100|100|00}}} Dec \2\0{{{|100|00}}}

And you will get something like (attached) Give it a try and let me know 🙂

Cathy Liu

07/15/2025, 11:24 PM

Thanks Mauricio, I'll give it a go

6 Views

Open in Slack

Previous Next