Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Month in column on top of the report

Accepted answer
32
Views
5
Comments
Lauriane Massin Whitaker
Lauriane Massin Whitaker Rank 6 - Analytics Lead
in Oracle Fusion Data Intelligence

Hi,

I have an issue with the month column display :

In the 1st screenshot below, I have been able to add the month as a column including all the main other columns (which are all VALUES) - except for POLES which is not a value.

image.png

In this 2nd screenshot (since only the last column is a value I guess), the month column is only displayed for that particular column.

image.png

Is there any way for me to extend this month column and make it displayed including all the columns ?

Or any other idea to have it in the title of the report and changed automatically when i change the month in the filter ?

Thank you.

Regards,

Lauriane

Best Answer

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Lauriane Massin Whitaker

    Reg. you quesiton —> any other idea to have it in the title of the report and changed automatically when i change the month in the filter .

    you can use the below formula to use the parameter in title of the report.

    @parameter("parameter name")

    Use a Parameter in a Visualization's Title

    Regards,

    Arjun

  • Lauriane Massin Whitaker
    Lauriane Massin Whitaker Rank 6 - Analytics Lead

    Thank you, I will try !

    Regards,

    LAuriane

  • Lauriane Massin Whitaker
    Lauriane Massin Whitaker Rank 6 - Analytics Lead

    Hi Mallikarjuna,

    I've tried but it does not seem to be working ?

    image.png

    Dashboard filter added with the parameter "month". Title of the vizualization changed to "xxxxx for parameter("Month"). But the month does not appear.

    Have I missed anything ?

    Thank you very much.

    Regards,

    Lauriane

  • Lauriane Massin Whitaker
    Lauriane Massin Whitaker Rank 6 - Analytics Lead

    Hi @Mallikarjuna,

    I realized I first added a dashboard filter instead of a parameter. I tried again but can"t figure it out. Could you send me screenshots of how you did it on test and what info you put in the parameter ?

    Let's say I want to have the data "month" as a parameter, the same I have on my filter bar, how can I do it ?

    Every month my client will have to change the month to see her data, and I want this month to be displayed in the title of her report.

    Thank you.

    Regards

    Lauriane