Thanks for the breakdown! Could you help me with something unrelated: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). How should I go about transferring them to Binance?
You help me very much, You are the best master of MST that i found on internet. Much better and clear than the manual of advance reporting. PS: my life is hard, and you help me a lot whit this. Many, many thanks again,
Hey Roost would love to see some videos on the following if your willing... XEG and using web services for cubes and reports(Prompted and non prompted).
Why is Region level not applied on NatRev at one point(7:14) and applied when category is added(9:54)? I am assuming metric has 3 levels defined in it(Report Level, Year and Region). What is the reason for it?
Thank you for this great video. However I think the calculation for “All Years Revenue” is incorrect. The sum of all Revenue in Tutorial project is around $35 M.There is no way it adds to $1 Billion. Category is in the report object but not in the template. Thus the “All Year Revenue” is being summed for each category. That is why we are getting $1 Billion. If you change the Grouping of “All Years Revenue” from "Standard" to "None" the problem will be fixed.
+Reza Ghandchi Ah good point, It was meant all revenue across all years for the applicable category not all Revenue of the year. I should have labeled it better to be "Timeless Category Revenue" or 'Category Revenue all Years'. Thanks for keeping me honest ;)
Hiya. Great video. I have this business case wherein I have to read 'Yearly Targets' from one table, 'Quartely Targets' from another, and 'Monthly Targets' from third. I created three metrics for them and made all of them level metrics so they don't wrong add up targets. [for example, Monthly Targets don't get sum up if user pulls accidently aganist Qtr. However, ideally I want to provide only single metric to the user such that depending on which attribute (Year, Qtr or Month) the user pulls it, it will show the appropriate Targets. Can you think of any way to do this? Alternatively, if there any way to zero out the level metric at unwanted levels. i.e. if 'Qtr Targets' metric is used against Months or Years, then instead of repeating the 'Qtr Target' values, it should just show nulls or zeros.
Very helpful videos! I appreciate it! I am learning a lot. Would you be able to post some more videos on Level and conditional metrics and create a scenario to explain the example? And whats the purpose of using Transformation, if we can get the requirement by creating a conditional metric? Is transformation used on a regular basis.. Thank you very much!
+Vikram Tiwari Many reasons why to use a transformation vs conditional but in a nutshell a filter has interactions with the where clause that messes your ability to put two metrics next to each other such as this year X and last year X. You could indeed get around them, but if you want to take advantage of Transformation tables etc, then you would be over complicating a problem that is easy to solve using a transformation. See the video on Transformations: ruclips.net/video/Csy68aIh9vI/видео.html
Hey Rooster, Thanks for the video and the tutorial series. Very Helpful for a beginner like me. I just want to ask about a problem that I am facing. I am creating a Predictive Metric (Liner Regression). 11 independent variables and 1 dependent is used to create a Linear Regression Model. Now, the model is working fine and the Predicted Results are pretty good. We are good there. But, the main outcome that we need is the coefficient of one of the independent variables in the model (say VarImp). I have tried a couple of things but what I see till now that MSTR is not designed to report the coefficients separately. Is there any trick or method to get this done? Thanks in advance.
+Nilotpal Banerjee Try to graph your results(maybe bar graph) and in the series options for trend lines you may be able to allow viewing the coefficients.
Hey rooster.. (bear with me here..) We had a circumstance with a combo chart where the line part had to be one value at the highest level for all drilldown levels while the bars changed at each drilldown. We tried everything with level metrics but could not stop the line part from changing at each level. What we ended up doing is creating a metric directly from a fact in one report and blending it with a different report that had a metric that changed. So basically when blended in a document one metric stayed the same at all levels and the other changed at different levels. Is there any other way to do this? set a metric in a report that never changes regardless of drill while other metric do the default value change at each level?
Thanks for the breakdown! Could you help me with something unrelated: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). How should I go about transferring them to Binance?
You help me very much, You are the best master of MST that i found on internet. Much better and clear than the manual of advance reporting.
PS: my life is hard, and you help me a lot whit this.
Many, many thanks again,
Marta Cuevas Glad to have been able to help and thanks for participating.
+Marta Cuevas True that!
Hey Roost would love to see some videos on the following if your willing...
XEG and using web services for cubes and reports(Prompted and non prompted).
Why is Region level not applied on NatRev at one point(7:14) and applied when category is added(9:54)? I am assuming metric has 3 levels defined in it(Report Level, Year and Region). What is the reason for it?
Thank you for this great video.
However I think the calculation for “All Years Revenue” is incorrect.
The sum of all Revenue in Tutorial project is around $35 M.There is no way it adds to $1 Billion.
Category is in the report object but not in the template.
Thus the “All Year Revenue” is being summed for each category.
That is why we are getting $1 Billion.
If you change the Grouping of “All Years Revenue” from "Standard" to "None" the problem will be fixed.
+Reza Ghandchi Ah good point, It was meant all revenue across all years for the applicable category not all Revenue of the year. I should have labeled it better to be "Timeless Category Revenue" or 'Category Revenue all Years'. Thanks for keeping me honest ;)
Hiya. Great video. I have this business case wherein I have to read 'Yearly Targets' from one table, 'Quartely Targets' from another, and 'Monthly Targets' from third. I created three metrics for them and made all of them level metrics so they don't wrong add up targets. [for example, Monthly Targets don't get sum up if user pulls accidently aganist Qtr. However, ideally I want to provide only single metric to the user such that depending on which attribute (Year, Qtr or Month) the user pulls it, it will show the appropriate Targets.
Can you think of any way to do this?
Alternatively, if there any way to zero out the level metric at unwanted levels. i.e. if 'Qtr Targets' metric is used against Months or Years, then instead of repeating the 'Qtr Target' values, it should just show nulls or zeros.
Very helpful videos!
I appreciate it! I am learning a lot.
Would you be able to post some more videos on Level and conditional metrics and create a scenario to explain the example?
And whats the purpose of using Transformation, if we can get the requirement by creating a conditional metric? Is transformation used on a regular basis..
Thank you very much!
+Vikram Tiwari Many reasons why to use a transformation vs conditional but in a nutshell a filter has interactions with the where clause that messes your ability to put two metrics next to each other such as this year X and last year X. You could indeed get around them, but if you want to take advantage of Transformation tables etc, then you would be over complicating a problem that is easy to solve using a transformation. See the video on Transformations: ruclips.net/video/Csy68aIh9vI/видео.html
Hey Rooster, Thanks for the video and the tutorial series. Very Helpful for a beginner like me. I just want to ask about a problem that I am facing. I am creating a Predictive Metric (Liner Regression). 11 independent variables and 1 dependent is used to create a Linear Regression Model. Now, the model is working fine and the Predicted Results are pretty good. We are good there. But, the main outcome that we need is the coefficient of one of the independent variables in the model (say VarImp). I have tried a couple of things but what I see till now that MSTR is not designed to report the coefficients separately. Is there any trick or method to get this done?
Thanks in advance.
+Nilotpal Banerjee Try to graph your results(maybe bar graph) and in the series options for trend lines you may be able to allow viewing the coefficients.
Hey rooster.. (bear with me here..)
We had a circumstance with a combo chart where the line part had to be one value at the highest level for all drilldown levels while the bars changed at each drilldown. We tried everything with level metrics but could not stop the line part from changing at each level. What we ended up doing is creating a metric directly from a fact in one report and blending it with a different report that had a metric that changed. So basically when blended in a document one metric stayed the same at all levels and the other changed at different levels. Is there any other way to do this? set a metric in a report that never changes regardless of drill while other metric do the default value change at each level?
+Stillgar71 Have you looked into Fact extension?
+MicroRooster
thanks Roost... I will have a look at... Keep up the good work..
Thaaanks