Within a report: Create a month date hierarchy

Daria shared this question 1 year ago
Answered

Hi!

I have created a report with the columns (day, Metric 1, Metric 2) based on 2 different view and save it as a view "from report". I would like to create a new report#2 based on this new view "from report" and create year -month- day drill down.

Within my view "from report" there is no option to edit it in view builder.

When i'm trying to build new calculated field in my new report#2 based on a day field no date sql function works (no extract, no date_part as well).

Is there a work around how to build two additional dimenstions and afterwards build an hierarchy for them within the report editing mode?

Comments (3)

photo
1

Hi Daria,

Thanks for reaching out with your question. If you are using a report as a view, it's not possible to manipulate that in the View Builder.

Using a Report as a View also limits your functionality for Calculated Fields.

In regards to building a hierarchy, this must happen at a View level.

Does this answer your question?

Thanks,

Ryan

photo
1

Yes, thank you.

photo
1

Hi Daria,

Happy to help! I'll go ahead and mark this ticket as Completed. Don't hesitate to reach out with further questions or issues.

Thanks,

Ryan