creating a new view using freehand sql
Answered
I am trying to create a new view using freehand sql and it automatically creates the dimension and measures. How would I convert the field in measure to show under dimension. I can able to change the field to dimension, but it is still showing under measures.
The same question
Hi Shahul,
To convert a Measure to a Dimension and have it show under the Dimension folder, please edit the view and move to the Prepare tab. From here, simply right-click the Measure you want to convert and change the Field Type to Dimension, then click and drag it under the Dimensions folder and Publish your view.
If you need anything more help with this please let me know.
Cheers,
Neal
Hi Shahul,
To convert a Measure to a Dimension and have it show under the Dimension folder, please edit the view and move to the Prepare tab. From here, simply right-click the Measure you want to convert and change the Field Type to Dimension, then click and drag it under the Dimensions folder and Publish your view.
If you need anything more help with this please let me know.
Cheers,
Neal
Hi Shahul,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?
Cheers,
Neal
Hi Shahul,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?
Cheers,
Neal
This is resolved now. thanks.
This is resolved now. thanks.
Hi Shahul,
Glad to hear that. Please let me know if you have any issues in the future.
Cheers,
Neal
Hi Shahul,
Glad to hear that. Please let me know if you have any issues in the future.
Cheers,
Neal
Replies have been locked on this page!