Hi good data team,
I need to create a report that ...
# gooddata-cloudh
Haseeb Ahmad
07/18/2025, 1:04 AMHi good data team,
I need to create a report that shows the number of jobs, grouped by organisation name in the rows and by the job creation date in the columns.
However, the current visualization is incorrectly using the organisation's created_at date instead of the job's created_at date for the column grouping.
How can I make sure the report uses the created_at date from the jobs dataset?
m
Mauricio Cabezas
07/18/2025, 8:53 AMHi Hasseb, thank you for this.
My apologies, if I did not understand correctly. When you include a Date attribute in your visualisation, in this case a table (column) you are able you change or choose which date you want to use like the attached screenshot.
Please, let me know if that helps.
If not, can you share a screenshot to understand better.
Thank you
h
Haseeb Ahmad
07/22/2025, 7:43 AMHi @Mauricio Cabezas,
This is the case, I want to get total jobs by organisation on monthly basis. currently, the jobs is grouped by organisation name and organisation created_at but i want that jobs should be grouped by organisation name and jobs created_at.
is it possible to do something like this?
m
Mauricio Cabezas
07/22/2025, 12:28 PMHi Haseeb, thank you for the explanation, but to check further I will need to see the LDM, would you be so kind to share the direct link to the table?, please feel free to use DM.
Mauricio Cabezas
07/23/2025, 1:01 PMHi Hasseb, thank you for share the direct lin kby DM, but I can not identify nor recreate the table as I can not see all the attributes and metrics involved there, can you please create the table and save it?
Mauricio Cabezas
07/28/2025, 5:22 PMHi, with the table, I mean, similar to the Table (insight) from your screenshot, no in the LDM.
From there I can not see clearly the ID's or attributes involved, and after impersonation I was not able to find the table.
Mauricio Cabezas
07/31/2025, 10:27 PMHi Hassed, As I mentioned in my previous comments, I am still unable to reproduce the table (insight) shown in your screenshot. For instance, I see an 'Organization Name' (edited) alongside a real attribute labeled 'Name,' but there are four entries instead with the same name.
Could you please create the table and save it? That would greatly assist me in identifying the issue and help with the solution. Thank you!