Forum Discussion

dinda156's avatar
dinda156
Cloud Apps
06-06-2024
Solved

Counting by the Day of the Week in a Pivot Table

Hello: I am attempting to count incidents by the day of the week across a month.   I am hoping for:             MON   TUE   WED   THU   FRI   SAT   SUN Shift A    3          6          2       5...
dashboards & reporting
  • TriAnthony's avatar
    TriAnthony
    06-10-2024

    Hi dinda156,

    Did you mean that the data model is a live model, or that you do not have access to the model? Do you have access to the Data tab (like shown below) at all? 

    The solution to your question requires changes to the data model (regardless of the model type, elasticube or live), so to achieve this, you'll need edit access to the model. Otherwise, you'll need to ask the data designer of the model to make the changes on your behalf.

Benji_PaldiTeam's avatar
Benji_PaldiTeam
Data Pipeline
06-07-2024

Hi dinda156 ,

If I understand the question correctly, one best approach would be to create a column in the Elasticube table that identifies the day of the week. You can then use this new column instead of 'Time in Alarm DateTime'  in your screenshot.

To achieve this, use the following formula in Elasticube to get the day name:

DayName(DayOfWeek([Table Name].[Date Field]))

This will allow you to group and count incidents by the day of the week without duplication.

 

 

Feel free to reach out if you have further questions, we're always happy to help 🙂
[email protected] 
Paldi Solutions, Number #1 Sisense Plugins Developer

 

  • dinda156's avatar
    dinda156
    Cloud Apps
    06-07-2024

    I probably should have mentioned I am in a cloud environment.  As such, no elasticube.   

    thanks!

  • dinda156's avatar
    dinda156
    Cloud Apps
    06-07-2024

    Hello:
    Working in our cloud environment, SiSense (Cloud) doesn't like DAYNAME. I cannot reference a table in the cloud, only the data element.  Our cloud implementation doesn't permit this. 

     

     

    • TriAnthony's avatar
      TriAnthony
      Admin
      06-10-2024

      Hi dinda156,

      Did you mean that the data model is a live model, or that you do not have access to the model? Do you have access to the Data tab (like shown below) at all? 

      The solution to your question requires changes to the data model (regardless of the model type, elasticube or live), so to achieve this, you'll need edit access to the model. Otherwise, you'll need to ask the data designer of the model to make the changes on your behalf.