Skip to main content

    Idea Pipeline

    Filter by idea status

    Filter by product area

    6164 Ideas

    stevepost
    stevepostContributor ⭐️⭐️

    Add more date formatting options to reports and formula fieldsNew Idea

    As a user or administrator, I want greater control over the display of date fields in reports. I also want this control when working with formula fields. (in Reports, Data Designer, etc.) This would allow me to display or convert date values however I need for my use case, e.g. 4/15/2024 could be presented as “2024-04-15” or “15 April 2024” or “April 15” or “Apr” or “Q2” or other formats in a table or chart.Example use case - 2 dimension chart:I want to show a bar chart where values are grouped by Month and Year so that 12 sequential months make up the x-axis and year-over-year values grouped for each calendar month, as seen in this example from a spreadsheet:A spreadsheet can group source data by month in one dimension and year in another, resulting in a pleasing chart that is easy to read.A presentation like this allows customer metrics within a certain time period to be visually compare to the corresponding period of a prior year., e.g. one month year-over-year as shown above, or one quarter year-over-year, or each week of a month compared to that week of a prior month.String conversion sequence problemIf I want to represent a date as strictly a month like “Apr” or a quarter like “Q2” in a Gainsight table or chart, I must convert the field to a string using a Formula Field and the string function “Month” which behaves as needed. But converting a date to a string for presentation purposes causes the chart to sort months alphabetically instead of chronologically, creating the problem seen here:Converting with “Month” string formula breaks chronological ordering in chartsNOTE: I can’t choose “April” since the function defaults to abbreviated month strings.If date fields could be presented simply as the month, chronologic sorting could be preserved.Date aggregation grouping problemIf I aggregate my date field using “Month of Date” instead, the chronology is maintained in the chart x-axis, but the year is appended to the month in the chart presentation. This eliminates the grouping of values by month across years, as seen here:Aggregation to “Month of Date” retains chronological order but eliminates groupingThe only way I have found to get close to my goal is to use Data Designer to prepare a label string field which concatenates a month number onto a month name so that “03-Mar” comes before “04-Apr”, for example:Custom month label field must be created using multiple transform steps and results in an undesirable presentation of the monthThis workaround isn’t ideal for a few obvious reasons:Our goal of a simple month label like “Apr” is not achieved The level of effort is too high for admins: Create a Data Designer that fetches the dataset Convert date field to a string to create the month number (“2024-04-15”) Trim the date string to isolate the month number (“04”) Convert date field to a month label (“Apr”) Concat the month number string with the month label string (“04-Apr”) Data freshness would require a scheduled D.D. run for up-to-date presentationThanks for considering my request!

    sami.burk
    sami.burkContributor ⭐️⭐️⭐️⭐️

    Goals Library SortingNew Idea

    We are rolling out a new SP which will heavily rely on Goals. We will especially be leaning on the Goals Library. I noticed a couple things:There does not appear to be a way for an admin to set the default ordering of the list of Library Goals. The admin view can be sorted by name as can the user view, but that is a temporary sort and it will reset once you leave the page. At the minimum, the admin should be able to sort the default order alphabetically. However, full control of the order would be a more robust solution. Currently it appear to sort based on how they were entered, which brings me to point 2:   When creating new library entries, it adds the most recent addition to the top of this list. Because of that behavior, I created a slew of Library Goals from Z to A so that they would show up alphabetically. If that wasn’t a big enough pain, when I go back today, I see now they are default sorted in the order I put them in -- i.e., the default order is now Z-A. It should auto sort alphabetically while adding new items, or at the very least with the first entered being set at the top of the list. Additionally, if it’s going to set the list this way when adding Library Goals, it shouldn’t flip the order later.These two things are frustrating enough. To add to it though, adding a Goal to the Library later is a daunting thing. I will either have to deal with it being at the bottom? top? of the list, or I’ll have to remove them all and input them all again to keep it in a default clean order.