Skip to main content
New Idea

Improve Parity between Data Designer and Report Builder

Related products:None
bruno_giacomelli
  • bruno_giacomelli
    bruno_giacomelli

spencer_engel

Hi there - I’d like to see better parity between Data Designer’s report builder and the normal report builder. I believe this post is an evolution to this one FYI 

 

A few things I’ve noticed are lacking in Data Designer’s reporting tool that are available in the regular report builder include: 

  • Ability to drill down. I’m surprised this doesn’t exist already, but I can’t drill down into bar charts, pie charts, etc.
  • The functionality to drag fields into filters does not exist like it does in report builder.
  • The settings aren’t nearly as robust (can’t re-order things, or re-name axes, etc.)

I know I can just configure the data design and report on it, but sometimes I’d like to keep things confined to data designer, and these limitations are keeping me from doing that in certain circumstances. Thanks for considering.

 

 

14 replies

bradley
Forum|alt.badge.img+7
  • Expert ⭐️
  • 1131 replies
  • April 11, 2022

Also, with the ability to create and publish a report in DD (assuming the design has been published) you don’t get as much benefit if you push it from DD then have to tweak it in report builder anyways.


sarahmiracle
Forum|alt.badge.img+10
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 354 replies
  • April 11, 2022

Agreed -- I often find myself dragging fields up to filters only to remember the functionality is slightly different 😅 If I had to prioritize which features I’d like to see parity on first, it would DEFINITELY be the the ability to see a drill down.


rakesh
Forum|alt.badge.img+1
  • Lets put your data to work!
  • 835 replies
  • April 12, 2022

@All

Data Designer and Report builder are different in one sense - Reports build in explore part of Data Designer are only accessible there, mostly only limited to admins.

We do want to close the structural gaps - drag and drop behavior, etc. so that its uniform. However, we can only make it close, not the same. 

 

@spencer_engel Can you explain a scenario for this:

but sometimes I’d like to keep things confined to data designer,

Why do you want to keep things confined to DD? What are those scenarios? Are you the only consumer of such reports or do others see? If they do are other people also Gainsight admins?


spencer_engel
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 670 replies
  • April 12, 2022

Yeah, there are scenarios where I’m the only consumer (perhaps another admin or two), and I don’t necessarily want to create a whole new MDA object when I know I won’t be placing said reports on a dashboard.


bradley
Forum|alt.badge.img+7
  • Expert ⭐️
  • 1131 replies
  • April 12, 2022
spencer_engel wrote:

Yeah, there are scenarios where I’m the only consumer (perhaps another admin or two), and I don’t necessarily want to create a whole new MDA object when I know I won’t be placing said reports on a dashboard.

Especially because published Data Designs are classified as system objects so we can’t exactly delete them.

 

Edit: It seems now that if you unpublish and delete your design the object goes away, which seems to be new?


sarahmiracle
Forum|alt.badge.img+10
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 354 replies
  • April 20, 2022

Question here as I’m working on a few designs -- am I also not able to rename a design? I have a design that has not been published as a dataset, I’m still just exploring, but it looks like I can’t rename it. 

 

Edit - found it, but in the spirit of this post for having parody with report builder, I think it could have been a bit more intuitive! :) 


Stuart
Forum|alt.badge.img+3
  • Helper ⭐️⭐️
  • 144 replies
  • June 14, 2022

Adding my plus one to this in terms of improvement opportunities in Data Designer.  Specifically, data designer doesn’t have the ‘Chart Editor > Data Labels’ option - the result is inconsistency in the how the charts appear on a Dashboard depending on whether they’ve been created in Report Builder or Data Designer.

 

Hopefully this would be an easy, and quick win for the Dev team to implement!

 

 

 


spencer_engel
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 670 replies
  • September 23, 2022

A big thing I missed in my original post is the ability to export from Data Designer. Linking to this post: 

 


Stuart
Forum|alt.badge.img+3
  • Helper ⭐️⭐️
  • 144 replies
  • November 24, 2022

I can’t +1 this again, but another area where there is not parity is wrt formula fields.  In Report Builder there is the option to create a formula field by adding or subtracting days/weeks/months to a field, however in DD options only exist for units of days and weeks. Hopefully an easy resolve for the dev team 🤞 


alizee
Forum|alt.badge.img+12
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 664 replies
  • November 24, 2022

+1


romihache
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 431 replies
  • January 18, 2024

Voted! Adding my two cents:
 

 


romihache
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 431 replies
  • June 6, 2024

 I can’t +1 this again, but adding some I didn’t before and don’t find in the comments:

  • In DD, after applying an inline filter and then reordering, the inline filter is ignored although it is still showing as active. In report builder, the inline filter is honored.
  • Filters are also different, for the same Person GSID field in DD I have: equals, not equal to, is null, is not null, does not contain, contains, starts with, ends with. In Report Builder: equals, not equals, in, not in, is null, is not null (in green, same; in yellow, different name)


 

PS: And yes, I tried for the 1000x time to drag and drop a field to apply a filter in DD 😖


dayn.johnson
Forum|alt.badge.img+6
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 648 replies
  • June 18, 2024
romihache wrote:
  • Filters are also different, for the same Person GSID field in DD I have: equals, not equal to, is null, is not null, does not contain, contains, starts with, ends with. In Report Builder: equals, not equals, in, not in, is null, is not null


#product_parity!

I can’t begin to emphasize how much it’s going to hurt to start using some of the new DD filters when recreating programs created using query builder (which seem to use a lot of the same logical operators as report builder).​​​​​​​


dayn.johnson
Forum|alt.badge.img+6
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 648 replies
  • September 6, 2024

I found it! Yet another example of the lack of parity between DD and Report Builder. On a related note to @Scotty at Calendly’s idea here (Default “All Fields” report in Data Designer), it would be awesome if when we created a new DD, it opened a report that showed all the fields in the “show me” section.

My idea:

While I typically add fields to the Show Me section in the order I want to see them, I’m often building reports for CSMs or my marketing counterpart, and they’re only interested in certain inforrmation I want to put in the first few columns of the report.

Unfortunately, when I drag a field to “Show Me”, it defaults to the very BOTTOM of the “Show Me” list, so there’s a lot of click, drag, drop, and then re-drag and drop. It even looks like it should work to drop it where I want it, but when you release the pointer, it drops to the bottom.

I don’t build that many reports in DD, but there are a few where I need to merge our company object with our user object to get a few fields, and it’s inconvenient to have to remember to do things differently.

 

 



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings