Hi, I would line to create a table that counts the number of new products sold in every month.assuming I have the following dimensions:ProductsStoresMonthswith a Sales Measure.how would I go about designing the data in order to achieve a table with c...
How can I create a model calculation for YOY, MoM,WoW,DoD .
my model has sales [measure] per day [Date dimension].
I saw the YOY built in function but thought maybe someone used that Iterate function to build the same for the rest of the granular...
Hi Nikhil Anand, Amazing! thanks for the quick response.everything worked, and planning to implement as a default calculation for each new model going forward.
Thanks Daniel. nice to see I'm not the only newbie in SAC scripting.
regarding "#4 Use a Dropdown Menu to Navigate Page to Page" - is there a way to generalize the dropdown to load all the pages in a story instead of using "Manual Input"?
Amazing. thanks.
I used a button to hide all the charts with an X measure. and show all the charts with the Y measure. \now I'll have to fix it to use this better version of code...
Hi,
I'm getting an error for type mismatch: Cannot convert from "string" to "Array of string" in line 11.
my input control is a simple two ranges date, for current month and last month. (text show "Aug, 2023" and "Jul, 2023")
how can I see the Id'...
