Avatar

Cyrille, Gina

  • Total activity 47
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 1 user
  • Votes 7
  • Subscriptions 15

Activity overview

Latest activity by Cyrille, Gina
  • Avatar

    Cyrille, Gina commented,

    Resolved: using the ALL() actually helped. The All() function returns the total amount for a dimension, and can be used for various use cases. In the following example, we will use the All function...

  • Avatar

    Cyrille, Gina created a post,

    Storing Grand Total: Pivot Percentage of a Whole

    Answered

    Hi community, I need assistance trying to find the % of a grand total to display on a pivot table. Please review the image. The goal is to display the percentage of column C/ Grand Total(column B) ...

  • Avatar

    Cyrille, Gina commented,

    I'll try that, Thanks!

  • Avatar

    Cyrille, Gina created a post,

    Data Lables or Dynamic Titles

    Answered

    Hi, Is there a way to create Dynamic Titles or just inserting data labels. Examples:          Insert Dynamic Title "Most Recent Date Reflective on [enter last date in data load]" Or even come thing...

  • Avatar

    Cyrille, Gina commented,

    Great!! That worked! Thanks!

  • Avatar

    Cyrille, Gina created a post,

    Order By ID and Display Name

    Answered

    Hi, Is there a way to order by ID but display Description or name without adding ID to the description nor by adding and id column? EX: I want to display the list of statuses in a pivot table repo...

  • Avatar

    Cyrille, Gina commented,

    To find Latest N Date: I added a new column in my table on elasticube called monthDiff with the formula:  MonthDiff((SELECT max([date]) FROM [table]),(SELECT [date] FROM [table])) This calculates t...

  • Avatar

    Cyrille, Gina created a post,

    Display Latest N Dates/ Find Max Date

    Answered

    Is there a way to show latest N dates, like I want to see the growth last 18 months, or just last 3 months?   Or maybe help I figure out how to display the max date in the tables, then I can do a m...

  • Avatar

    Cyrille, Gina created a post,

    Previous Month In Data

    Hi, Need help, please. Is there any way to identify previous month, latest Month based on the data not today? EX:  I need to write a calculation (Total Cost of Lastest Month - Total Cost Previous M...

  • Avatar

    Cyrille, Gina created a post,

    Download Dashboard to PDF

    Hi, Has anyone encounter this error and/or resolved it? Getting this error when trying to download any dashboard to PDF. This error only occurs when reports are fully designed, it doesn't display i...