Thank you @Mayura Wasantha
Hi @Mayura Wasantha,Thank you for your solution, it worked.Could you please provide me your investigation approach to identify this solution?Thanks in advance.
Hi @Mayura Wasantha , Navigation is working fine, but I need to know how to retrieve data for specific time periods with proper authorization. For example, I need data for last month and last week. Once I navigate from the lobby page to this screen, how do I set the period in the navigation link? After navigating, I want the option to select either last month or last week as the period to be displayed.
Thanks, @Mayura Wasantha how to pass the parameters in the link.
I'm using a two-column select query (e.g., select count(*) from my_table) in the data source designer. One column represents the current month, and the other represents the previous month. Both columns should be shown in the preview. In the condition field, there are two conditions with parameters. These columns will be utilized in a KPI element, where the actual field corresponds to the current month, and the target field corresponds to the previous month.
@Marcel.Ausan Thanks for your reply, and it is indeed very useful.
@Marcel.Ausan Thank you for your information; it has been very useful.How to calculate Safety Stock in Inventory part screen with auto update using calculate planning data.Could you describe the formula.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.