Thank you, SAU, very useful.
Great work, SAU! My only concern is what happens when you have many small numbers, which can mix inside the pie. Would be interesting if you explain how you did it.
Hi mgandy, just couple of additions to excellent comments from Rich: You can automate this process of importing data from csv and pushing to Sql database if you have a Qloud. You can use automation...
Hi Jason, I am not a scripting expert, but I think it should work for you: def myMessage = "Enter your data" def myInput = ask(myMessage, ["State":String, "Birthday":Date]) def st = myInput.get("State")...
Hi Davood, you may consider creating one matrix with year (1,2) category and another matrix with year(3) and quarter categories. Then you can place and snap them on canvas for reporting.
Thank you for your time and efforts! The whole idea was how to provide restricted access to parts of the same matrix for different users without duplicating matrix or view (especially important when you...
Very interesting experiment. I was also surprised by such a long loading time of my less that 1mb file on the computer with the latest hardware. I had to split the model. Of course, loading the model on...
Thank you!
Interesting. Yes, the problem is when new item is added, unfortunately we have to add switch manually which is not optimal
Looks interesting, please share your model.
Great idea! Would be good if you share how you did it. Here is my workaround for doughnut chart 🙂
Hi Carlo! I think there is no option to remove it. This information does not appear if you export as csv file. You can open it in excel but then you have layout and format issue. It is done to promote...
James, in original model it is used for data analytics visualization, where user can dynamically form a question and receive an answer in form of ranking which includes budget and actual data. There is...
Thank you SAU for sharing and referencing to my video. This is a way to bring more appealing visuals to canvas with own icons, since existing data visualization tools in Quantrix are limited.
After extensive reading, learning and trying I have figured out how to write this script. If anyone interested in accessing items and categories across the whole model via script with dynamic input, please...
This model is an example. Real models are bigger. Data source for Plan is manual entry.
Hi SAU. I meant from May 2019 until the end of the year. There are many matrices and many model templates where this operations is required. Those are all assumptions which should be simply populated again....
Hi, I am trying to achieve the following: Copy values of "Plan" item to "Revised Plan" item (model is attached). The script should take given particular year and month and apply to this year and this months...